DBA Data[Home] [Help]

APPS.XLA_CMP_EVENT_TYPE_PKG dependencies on DBMS_SQL

Line 4650: RETURN DBMS_SQL.VARCHAR2S

4646: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
4647: , p_procedure IN VARCHAR2
4648: , p_IsCompiled OUT NOCOPY BOOLEAN
4649: )
4650: RETURN DBMS_SQL.VARCHAR2S
4651: IS
4652: --
4653: l_event CLOB;
4654: l_array_event DBMS_SQL.VARCHAR2S;

Line 4654: l_array_event DBMS_SQL.VARCHAR2S;

4650: RETURN DBMS_SQL.VARCHAR2S
4651: IS
4652: --
4653: l_event CLOB;
4654: l_array_event DBMS_SQL.VARCHAR2S;
4655: --
4656: l_IsExtractValid BOOLEAN;
4657: l_IsCompiled BOOLEAN;
4658: --

Line 4701: l_array_insert_sources DBMS_SQL.VARCHAR2S;

4697: --
4698: -- Transaction Objects Diagnostics variables
4699: --
4700: l_insert_sources CLOB;
4701: l_array_insert_sources DBMS_SQL.VARCHAR2S;
4702: --
4703: BEGIN
4704: IF g_log_enabled THEN
4705: l_log_module := C_DEFAULT_MODULE||'.GetEventTypeClassProc';

Line 5121: RETURN DBMS_SQL.VARCHAR2S

5117: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5118: --
5119: , p_IsCompiled OUT NOCOPY BOOLEAN
5120: )
5121: RETURN DBMS_SQL.VARCHAR2S
5122: IS
5123:
5124: l_event DBMS_SQL.VARCHAR2S;
5125: l_IsCompiled BOOLEAN;

Line 5124: l_event DBMS_SQL.VARCHAR2S;

5120: )
5121: RETURN DBMS_SQL.VARCHAR2S
5122: IS
5123:
5124: l_event DBMS_SQL.VARCHAR2S;
5125: l_IsCompiled BOOLEAN;
5126: l_log_module VARCHAR2(240);
5127:
5128: BEGIN

Line 5256: RETURN DBMS_SQL.VARCHAR2S

5252: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5253: --
5254: , p_IsCompiled OUT NOCOPY BOOLEAN
5255: )
5256: RETURN DBMS_SQL.VARCHAR2S
5257: IS
5258: --
5259: l_events DBMS_SQL.VARCHAR2S;
5260: l_array_events DBMS_SQL.VARCHAR2S;

Line 5259: l_events DBMS_SQL.VARCHAR2S;

5255: )
5256: RETURN DBMS_SQL.VARCHAR2S
5257: IS
5258: --
5259: l_events DBMS_SQL.VARCHAR2S;
5260: l_array_events DBMS_SQL.VARCHAR2S;
5261: --
5262: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5263: l_array_event_class xla_cmp_source_pkg.t_array_VL30;

Line 5260: l_array_events DBMS_SQL.VARCHAR2S;

5256: RETURN DBMS_SQL.VARCHAR2S
5257: IS
5258: --
5259: l_events DBMS_SQL.VARCHAR2S;
5260: l_array_events DBMS_SQL.VARCHAR2S;
5261: --
5262: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5263: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5264: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

Line 5422: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

5418: , p_product_rule_name IN VARCHAR2
5419: , p_package_name IN VARCHAR2
5420: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5421: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
5422: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
5423: )
5424: RETURN BOOLEAN
5425: IS
5426: --

Line 5428: l_events DBMS_SQL.VARCHAR2S;

5424: RETURN BOOLEAN
5425: IS
5426: --
5427: l_IsCompiled BOOLEAN:= TRUE;
5428: l_events DBMS_SQL.VARCHAR2S;
5429: l_log_module VARCHAR2(240);
5430: --
5431: BEGIN
5432:

Line 5838: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S

5834: , p_package_name IN VARCHAR2
5835: --
5836: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
5837: --
5838: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
5839: )
5840: RETURN BOOLEAN
5841: IS
5842: --

Line 5845: l_array_main DBMS_SQL.VARCHAR2S;

5841: IS
5842: --
5843: l_MainProcedure CLOB;
5844: l_MainBody CLOB;
5845: l_array_main DBMS_SQL.VARCHAR2S;
5846: l_IsCompiled BOOLEAN;
5847: l_log_module VARCHAR2(240);
5848: --
5849: BEGIN