DBA Data[Home] [Help]

APPS.XLA_CMP_EVENT_TYPE_PKG dependencies on DBMS_SQL

Line 4633: RETURN DBMS_SQL.VARCHAR2S

4629: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
4630: , p_procedure IN VARCHAR2
4631: , p_IsCompiled OUT NOCOPY BOOLEAN
4632: )
4633: RETURN DBMS_SQL.VARCHAR2S
4634: IS
4635: --
4636: l_event CLOB;
4637: l_array_event DBMS_SQL.VARCHAR2S;

Line 4637: l_array_event DBMS_SQL.VARCHAR2S;

4633: RETURN DBMS_SQL.VARCHAR2S
4634: IS
4635: --
4636: l_event CLOB;
4637: l_array_event DBMS_SQL.VARCHAR2S;
4638: --
4639: l_IsExtractValid BOOLEAN;
4640: l_IsCompiled BOOLEAN;
4641: --

Line 4684: l_array_insert_sources DBMS_SQL.VARCHAR2S;

4680: --
4681: -- Transaction Objects Diagnostics variables
4682: --
4683: l_insert_sources CLOB;
4684: l_array_insert_sources DBMS_SQL.VARCHAR2S;
4685: --
4686: BEGIN
4687: IF g_log_enabled THEN
4688: l_log_module := C_DEFAULT_MODULE||'.GetEventTypeClassProc';

Line 5104: RETURN DBMS_SQL.VARCHAR2S

5100: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5101: --
5102: , p_IsCompiled OUT NOCOPY BOOLEAN
5103: )
5104: RETURN DBMS_SQL.VARCHAR2S
5105: IS
5106:
5107: l_event DBMS_SQL.VARCHAR2S;
5108: l_IsCompiled BOOLEAN;

Line 5107: l_event DBMS_SQL.VARCHAR2S;

5103: )
5104: RETURN DBMS_SQL.VARCHAR2S
5105: IS
5106:
5107: l_event DBMS_SQL.VARCHAR2S;
5108: l_IsCompiled BOOLEAN;
5109: l_log_module VARCHAR2(240);
5110:
5111: BEGIN

Line 5239: RETURN DBMS_SQL.VARCHAR2S

5235: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5236: --
5237: , p_IsCompiled OUT NOCOPY BOOLEAN
5238: )
5239: RETURN DBMS_SQL.VARCHAR2S
5240: IS
5241: --
5242: l_events DBMS_SQL.VARCHAR2S;
5243: l_array_events DBMS_SQL.VARCHAR2S;

Line 5242: l_events DBMS_SQL.VARCHAR2S;

5238: )
5239: RETURN DBMS_SQL.VARCHAR2S
5240: IS
5241: --
5242: l_events DBMS_SQL.VARCHAR2S;
5243: l_array_events DBMS_SQL.VARCHAR2S;
5244: --
5245: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5246: l_array_event_class xla_cmp_source_pkg.t_array_VL30;

Line 5243: l_array_events DBMS_SQL.VARCHAR2S;

5239: RETURN DBMS_SQL.VARCHAR2S
5240: IS
5241: --
5242: l_events DBMS_SQL.VARCHAR2S;
5243: l_array_events DBMS_SQL.VARCHAR2S;
5244: --
5245: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5246: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5247: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

Line 5405: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

5401: , p_product_rule_name IN VARCHAR2
5402: , p_package_name IN VARCHAR2
5403: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5404: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
5405: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
5406: )
5407: RETURN BOOLEAN
5408: IS
5409: --

Line 5411: l_events DBMS_SQL.VARCHAR2S;

5407: RETURN BOOLEAN
5408: IS
5409: --
5410: l_IsCompiled BOOLEAN:= TRUE;
5411: l_events DBMS_SQL.VARCHAR2S;
5412: l_log_module VARCHAR2(240);
5413: --
5414: BEGIN
5415:

Line 5821: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

5817: , p_package_name IN VARCHAR2
5818: --
5819: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
5820: --
5821: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
5822: )
5823: RETURN BOOLEAN
5824: IS
5825: --

Line 5828: l_array_main DBMS_SQL.VARCHAR2S;

5824: IS
5825: --
5826: l_MainProcedure CLOB;
5827: l_MainBody CLOB;
5828: l_array_main DBMS_SQL.VARCHAR2S;
5829: l_IsCompiled BOOLEAN;
5830: l_log_module VARCHAR2(240);
5831: --
5832: BEGIN