{"id":1206,"date":"2016-01-21T13:05:12","date_gmt":"2016-01-21T11:05:12","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1206"},"modified":"2016-01-21T13:07:25","modified_gmt":"2016-01-21T11:07:25","slug":"api-apps-fnd_flex_keyval-validate_segs-walidacja-konta-ksiegowego","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1206","title":{"rendered":"API &#8211; APPS.FND_FLEX_KEYVAL.VALIDATE_SEGS  walidacja konta ksi\u0119gowego"},"content":{"rendered":"<pre lang='PLSQL'>\r\ncreate or replace PROCEDURE xx_valid_cc(\r\n    segments1  IN VARCHAR2,\r\n    segments2  IN VARCHAR2,\r\n    segments3  IN VARCHAR2,\r\n    segments4  IN VARCHAR2,\r\n    segments5  IN VARCHAR2,\r\n    segments6  IN VARCHAR2,\r\n    segments7  IN VARCHAR2,\r\n    segments8  IN VARCHAR2,\r\n    segments9  IN VARCHAR2,\r\n    segments10 IN VARCHAR2,\r\n    segments11 IN VARCHAR2,\r\n    l_success OUT NUMBER,\r\n    l_message OUT VARCHAR2 )\r\nIS\r\n  l_conc_segs GL_CODE_COMBINATIONS_KFV.CONCATENATED_SEGMENTS%TYPE;\r\n  l_structure_num FND_ID_FLEX_STRUCTURES.ID_FLEX_NUM%TYPE;\r\n  l_valid_combination BOOLEAN;\r\nBEGIN\r\n  SELECT id_flex_num\r\n  INTO l_structure_num\r\n  FROM apps.fnd_id_flex_structures\r\n  WHERE id_flex_code        = 'GL#'\r\n  AND id_flex_structure_code='XXX_PLAN_KONT';\r\n  l_conc_segs              := segments1||'-'||segments2||'-'||segments3||'-'||segments4||'-'||segments5||'-'||segments6||'-'||segments7||'-'||segments8||'-'||segments9||'-'||segments10||'-'||segments11;\r\n  l_valid_combination := APPS.FND_FLEX_KEYVAL.VALIDATE_SEGS ( operation => 'CHECK_COMBINATION', appl_short_name => 'SQLGL', key_flex_code => 'GL#', structure_number => L_STRUCTURE_NUM, concat_segments => L_CONC_SEGS );\r\n  IF l_valid_combination THEN\r\n    l_success :='1';\r\n    l_message := 'OK';\r\n  ELSE\r\n    l_success :='0';\r\n    l_message := FND_FLEX_KEYVAL.ERROR_MESSAGE;\r\n  END IF;\r\nEXCEPTION\r\nWHEN OTHERS THEN\r\n  l_success :='0';\r\n  l_message := 'Nieobs\u0142ugiwany wyj\u0105tek';\r\nEND xx_valid_cc;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>create or replace PROCEDURE xx_valid_cc( segments1 IN VARCHAR2, segments2 IN VARCHAR2, segments3 IN VARCHAR2, segments4 IN VARCHAR2, segments5 IN VARCHAR2, segments6 IN VARCHAR2, segments7 IN VARCHAR2, segments8 IN VARCHAR2, segments9 IN VARCHAR2, segments10 IN VARCHAR2, segments11 IN VARCHAR2, l_success OUT &hellip; <a href=\"https:\/\/oracle.malin.pl\/?p=1206\">Czytaj dalej <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[234,88],"tags":[140],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1206"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1206"}],"version-history":[{"count":2,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1206\/revisions"}],"predecessor-version":[{"id":1208,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1206\/revisions\/1208"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}