DBA Data[Home] [Help]

APPS.GCS_LEX_MAP_API_PKG dependencies on AD_DDL

Line 1132: -- Creates a function using ad_ddl. Returns 'TRUE' if there was an error.

1128: --
1129: -- Function
1130: -- Create_AD
1131: -- Purpose
1132: -- Creates a function using ad_ddl. Returns 'TRUE' if there was an error.
1133: -- Returns 'FALSE' if there was no error.
1134: -- Arguments
1135: -- Func_Body Body of the function.
1136: -- Func_Name Name of the function.

Line 1137: -- My_Appl APPLSYS schema, required for ad_ddl.

1133: -- Returns 'FALSE' if there was no error.
1134: -- Arguments
1135: -- Func_Body Body of the function.
1136: -- Func_Name Name of the function.
1137: -- My_Appl APPLSYS schema, required for ad_ddl.
1138: -- Example
1139: -- GCS_LEX_MAP_PKG.Create_AD('create ...', 'foo', 'APPLSYS');
1140: -- Notes
1141: --

Line 1158: ad_ddl.build_statement(substr(func_body, curr_index, 200), lines);

1154: lines := 0;
1155: body_len := LENGTH(func_body);
1156: WHILE curr_index <= body_len LOOP
1157: lines := lines + 1;
1158: ad_ddl.build_statement(substr(func_body, curr_index, 200), lines);
1159: curr_index := curr_index + 200;
1160: END LOOP;
1161:
1162: ad_ddl.create_plsql_object(my_appl, 'FND', func_name, 1,lines,'FALSE',err);

Line 1162: ad_ddl.create_plsql_object(my_appl, 'FND', func_name, 1,lines,'FALSE',err);

1158: ad_ddl.build_statement(substr(func_body, curr_index, 200), lines);
1159: curr_index := curr_index + 200;
1160: END LOOP;
1161:
1162: ad_ddl.create_plsql_object(my_appl, 'FND', func_name, 1,lines,'FALSE',err);
1163: return err;
1164: END;
1165:
1166: --

Line 2206: -- My_Appl APPLSYS schema, which is needed for ad_ddl.

2202: -- rule this derivation is part of.
2203: -- Target_Column_Type Specifies the type of the column.
2204: -- Derivation_Text Text of the derivation to test.
2205: -- Derivation_Id ID of derivation being tested.
2206: -- My_Appl APPLSYS schema, which is needed for ad_ddl.
2207: -- Example
2208: -- GCS_LEX_MAP_PKG.Test_Deriv
2209: -- ('gcs_lex_get_111_123',
2210: -- 'segment1 varchar2, acct_date date',

Line 2264: -- My_Appl APPLSYS schema, which is needed for ad_ddl.

2260: -- depending on the success of creating the function.
2261: -- Arguments
2262: -- Rule_Set_Id Rule Set for which the function should be created.
2263: -- Rule_Id Rule for which the function should be created.
2264: -- My_Appl APPLSYS schema, which is needed for ad_ddl.
2265: -- Example
2266: -- GCS_LEX_MAP_PKG.Create_Get_Function(111, 123, 'APPLSYS')
2267: -- Notes
2268: --

Line 3030: -- My_Appl APPLSYS schema, which is needed for ad_ddl.

3026: -- 'N' depending on the success of creating the function.
3027: -- Arguments
3028: -- Rule_Set_Id Rule Set for which the function should be created.
3029: -- Rule_Id Rule for which the function should be created.
3030: -- My_Appl APPLSYS schema, which is needed for ad_ddl.
3031: -- Example
3032: -- GCS_LEX_MAP_PKG.Create_VRS_Get_Function(111, 123, 'APPLSYS')
3033: -- Notes
3034: --

Line 3185: -- Get APPLSYS information. Needed for ad_ddl

3181: END IF;
3182:
3183: idt_name := initial_rule_set_check(p_rule_set_id, 'TRANSFORMATION', 'N');
3184:
3185: -- Get APPLSYS information. Needed for ad_ddl
3186: app_flag := fnd_installation.get_app_info('FND', status, industry,my_appl);
3187: IF NOT app_flag THEN
3188: raise gcs_lex_applsys_not_found;
3189: END IF;

Line 3658: -- Get APPLSYS information. Needed for ad_ddl

3654: END IF;
3655:
3656: idt_name := initial_rule_set_check(p_rule_set_id, 'VALIDATION', 'N');
3657:
3658: -- Get APPLSYS information. Needed for ad_ddl
3659: app_flag := fnd_installation.get_app_info('FND', status, industry,my_appl);
3660: IF NOT app_flag THEN
3661: raise gcs_lex_applsys_not_found;
3662: END IF;