DBA Data[Home] [Help]

APPS.XLA_CMP_ADR_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 821: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

817: , p_value_flexfield_segment IN VARCHAR2
818: , p_input_source_appl_id IN NUMBER
819: , p_input_source_type_code IN VARCHAR2
820: , p_input_source_code IN VARCHAR2
821: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
822: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
823: )
824: RETURN CLOB
825: IS

Line 822: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

818: , p_input_source_appl_id IN NUMBER
819: , p_input_source_type_code IN VARCHAR2
820: , p_input_source_code IN VARCHAR2
821: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
822: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
823: )
824: RETURN CLOB
825: IS
826:

Line 943: l_Idx := xla_cmp_source_pkg.StackSource (

939: p_value_source_type_code IS NOT NULL AND
940: p_value_source_code IS NOT NULL
941: THEN
942: -- source
943: l_Idx := xla_cmp_source_pkg.StackSource (
944: p_source_code => p_value_source_code
945: , p_source_type_code => p_value_source_type_code
946: , p_source_application_id => p_value_source_appl_id
947: , p_array_source_index => p_array_adr_source_index

Line 963: nvl(xla_cmp_source_pkg.GenerateSource(

959:
960: IF p_value_flexfield_segment IS NULL THEN
961: -- segment
962: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source$',
963: nvl(xla_cmp_source_pkg.GenerateSource(
964: p_Index => l_Idx
965: , p_rec_sources => p_rec_sources
966: , p_translated_flag => 'N'),' null')
967: );

Line 978: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$combination_id$', xla_cmp_source_pkg.GenerateSource(

974: THEN
975:
976: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source$' , C_TAD_FLEXFIELD_SEGMENT);
977:
978: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$combination_id$', xla_cmp_source_pkg.GenerateSource(
979: p_Index => l_Idx
980: , p_rec_sources => p_rec_sources
981: , p_translated_flag => 'N')
982: );

Line 991: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$code_combination_id$', xla_cmp_source_pkg.GenerateSource(

987: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source_application_id$',to_char(p_rec_sources.array_application_id(l_Idx)) );
988:
989: ELSE
990:
991: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$code_combination_id$', xla_cmp_source_pkg.GenerateSource(
992: p_Index => l_Idx
993: , p_rec_sources => p_rec_sources
994: , p_translated_flag => 'N')
995: );

Line 1028: l_Idx := xla_cmp_source_pkg.StackSource (

1024: p_input_source_type_code IS NOT NULL AND
1025: p_input_source_appl_id IS NOT NULL
1026: THEN
1027: -- Mapping set
1028: l_Idx := xla_cmp_source_pkg.StackSource (
1029: p_source_code => p_input_source_code
1030: , p_source_type_code => p_input_source_type_code
1031: , p_source_application_id => p_input_source_appl_id
1032: , p_array_source_index => p_array_adr_source_index

Line 1050: xla_cmp_source_pkg.GenerateSource(

1046: --segment mapping set
1047: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source$', C_MAPPING_SEGMENT);
1048: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$mapping_set_code$',p_value_mapping_set_code);
1049: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$input_source$',
1050: xla_cmp_source_pkg.GenerateSource(
1051: p_Index => l_Idx
1052: , p_rec_sources => p_rec_sources
1053: , p_translated_flag => 'N')
1054: );

Line 1071: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$combination_id$', xla_cmp_source_pkg.GenerateSource(

1067: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$code_combination_id$', ' null');
1068: END IF;
1069:
1070: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$mapping_set_code$',p_value_mapping_set_code);
1071: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$combination_id$', xla_cmp_source_pkg.GenerateSource(
1072: p_Index => l_Idx
1073: , p_rec_sources => p_rec_sources
1074: , p_translated_flag => 'N')
1075: );

Line 1143: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1139: , p_value_mapping_set_code IN VARCHAR2
1140: , p_input_source_appl_id IN NUMBER
1141: , p_input_source_type_code IN VARCHAR2
1142: , p_input_source_code IN VARCHAR2
1143: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1144: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1145: )
1146: RETURN CLOB
1147: IS

Line 1144: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1140: , p_input_source_appl_id IN NUMBER
1141: , p_input_source_type_code IN VARCHAR2
1142: , p_input_source_code IN VARCHAR2
1143: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1144: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1145: )
1146: RETURN CLOB
1147: IS
1148:

Line 1238: l_Idx := xla_cmp_source_pkg.StackSource (

1234: p_value_source_type_code IS NOT NULL AND
1235: p_value_source_appl_id IS NOT NULL
1236: THEN
1237: --source
1238: l_Idx := xla_cmp_source_pkg.StackSource (
1239: p_source_code => p_value_source_code
1240: , p_source_type_code => p_value_source_type_code
1241: , p_source_application_id => p_value_source_appl_id
1242: , p_array_source_index => p_array_adr_source_index

Line 1255: xla_cmp_source_pkg.GenerateSource(

1251: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$value_type_code$',p_value_type_code);
1252: END IF;
1253:
1254: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source$',
1255: xla_cmp_source_pkg.GenerateSource(
1256: p_Index => l_Idx
1257: , p_rec_sources => p_rec_sources
1258: , p_translated_flag => 'N')
1259: );

Line 1287: l_Idx := xla_cmp_source_pkg.StackSource (

1283: p_input_source_appl_id IS NOT NULL
1284: THEN
1285: -- Mapping set
1286:
1287: l_Idx := xla_cmp_source_pkg.StackSource (
1288: p_source_code => p_input_source_code
1289: , p_source_type_code => p_input_source_type_code
1290: , p_source_application_id => p_input_source_appl_id
1291: , p_array_source_index => p_array_adr_source_index

Line 1300: xla_cmp_source_pkg.GenerateSource(

1296: THEN
1297: l_detail := C_TAD_MAPPING_CCID;
1298: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$mapping_set_code$',p_value_mapping_set_code);
1299: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$input_source$',
1300: xla_cmp_source_pkg.GenerateSource(
1301: p_Index => l_Idx
1302: , p_rec_sources => p_rec_sources
1303: , p_translated_flag => 'N')
1304: );

Line 1313: xla_cmp_source_pkg.GenerateSource(

1309: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$value_type_code$',p_value_type_code);
1310: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$source$', C_MAPPING_CCID );
1311: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$mapping_set_code$',p_value_mapping_set_code);
1312: l_detail := xla_cmp_string_pkg.replace_token(l_detail ,'$input_source$',
1313: xla_cmp_source_pkg.GenerateSource(
1314: p_Index => l_Idx
1315: , p_rec_sources => p_rec_sources
1316: , p_translated_flag => 'N')
1317: );

Line 1358: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1354: , p_value_segment_rule_appl_id IN NUMBER
1355: , p_value_segment_rule_type_code IN VARCHAR2
1356: , p_value_segment_rule_code IN VARCHAR2
1357: , p_flexfield_assign_mode IN VARCHAR2
1358: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1359: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1360: )
1361: RETURN CLOB
1362: IS

Line 1359: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1355: , p_value_segment_rule_type_code IN VARCHAR2
1356: , p_value_segment_rule_code IN VARCHAR2
1357: , p_flexfield_assign_mode IN VARCHAR2
1358: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1359: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1360: )
1361: RETURN CLOB
1362: IS
1363: l_details CLOB;

Line 1572: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1568: , p_segment_rule_code IN VARCHAR2
1569: , p_segment_rule_type_code IN VARCHAR2
1570: , p_flexfield_assign_mode IN VARCHAR2
1571: , p_adr_name IN VARCHAR2
1572: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1573: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1574: , p_IsCompiled OUT NOCOPY BOOLEAN
1575: )
1576: RETURN CLOB

Line 1573: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1569: , p_segment_rule_type_code IN VARCHAR2
1570: , p_flexfield_assign_mode IN VARCHAR2
1571: , p_adr_name IN VARCHAR2
1572: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1573: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1574: , p_IsCompiled OUT NOCOPY BOOLEAN
1575: )
1576: RETURN CLOB
1577: IS

Line 1789: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

1785: , p_flex_value_set_id IN NUMBER
1786: , p_transaction_coa_id IN NUMBER
1787: , p_accounting_coa_id IN NUMBER
1788: , p_adr_name IN VARCHAR2
1789: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1790: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1791: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1792: , p_IsCompiled OUT NOCOPY BOOLEAN
1793: )

Line 1790: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

1786: , p_transaction_coa_id IN NUMBER
1787: , p_accounting_coa_id IN NUMBER
1788: , p_adr_name IN VARCHAR2
1789: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1790: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1791: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1792: , p_IsCompiled OUT NOCOPY BOOLEAN
1793: )
1794: RETURN CLOB

Line 1791: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

1787: , p_accounting_coa_id IN NUMBER
1788: , p_adr_name IN VARCHAR2
1789: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
1790: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
1791: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
1792: , p_IsCompiled OUT NOCOPY BOOLEAN
1793: )
1794: RETURN CLOB
1795: IS

Line 1899: xla_cmp_source_pkg.get_obj_parm_for_tab(

1895: THEN
1896: --Replace the ADR name
1897: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr , '$ADR_NAME$' , nvl(g_component_name,' ') ); -- 4417664
1898: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr , '$parameters$',
1899: xla_cmp_source_pkg.get_obj_parm_for_tab(
1900: p_array_source_index => p_array_adr_source_index
1901: , p_rec_sources => p_rec_sources
1902: ));
1903:

Line 1906: nvl(xla_cmp_source_pkg.GenerateParameters(

1902: ));
1903:
1904: ELSE
1905: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr , '$parameters$',
1906: nvl(xla_cmp_source_pkg.GenerateParameters(
1907: p_array_source_index => p_array_adr_source_index
1908: , p_rec_sources => p_rec_sources
1909: ),' '));
1910: END IF;

Line 1916: xla_cmp_source_pkg.CacheAADObject (

1912: IF g_component_type = 'TAB_ADR'
1913: THEN
1914:
1915: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr ,'$adr_hash_id$',TO_CHAR(
1916: xla_cmp_source_pkg.CacheAADObject (
1917: p_object => xla_cmp_source_pkg.C_ADR
1918: , p_object_code => p_segment_rule_code
1919: , p_object_type_code => p_segment_rule_type_code
1920: , p_application_id => p_application_id

Line 1917: p_object => xla_cmp_source_pkg.C_ADR

1913: THEN
1914:
1915: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr ,'$adr_hash_id$',TO_CHAR(
1916: xla_cmp_source_pkg.CacheAADObject (
1917: p_object => xla_cmp_source_pkg.C_ADR
1918: , p_object_code => p_segment_rule_code
1919: , p_object_type_code => p_segment_rule_type_code
1920: , p_application_id => p_application_id
1921: , p_event_class_code => NULL

Line 1930: xla_cmp_source_pkg.CacheAADObject (

1926:
1927: ELSE
1928:
1929: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr ,'$adr_hash_id$',TO_CHAR(
1930: xla_cmp_source_pkg.CacheAADObject (
1931: p_object => xla_cmp_source_pkg.C_ADR
1932: , p_object_code => p_segment_rule_code
1933: , p_object_type_code => p_segment_rule_type_code
1934: , p_application_id => p_application_id

Line 1931: p_object => xla_cmp_source_pkg.C_ADR

1927: ELSE
1928:
1929: l_Adr := xla_cmp_string_pkg.replace_token(l_Adr ,'$adr_hash_id$',TO_CHAR(
1930: xla_cmp_source_pkg.CacheAADObject (
1931: p_object => xla_cmp_source_pkg.C_ADR
1932: , p_object_code => p_segment_rule_code
1933: , p_object_type_code => p_segment_rule_type_code
1934: , p_application_id => p_application_id
1935: , p_event_class_code => NULL

Line 2012: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2008: , p_transaction_coa_id IN NUMBER
2009: , p_accounting_coa_id IN NUMBER
2010: , p_adr_name IN VARCHAR2
2011: --
2012: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2013: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2014: --
2015: , p_IsCompiled OUT NOCOPY BOOLEAN
2016: )

Line 2013: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2009: , p_accounting_coa_id IN NUMBER
2010: , p_adr_name IN VARCHAR2
2011: --
2012: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2013: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2014: --
2015: , p_IsCompiled OUT NOCOPY BOOLEAN
2016: )
2017: RETURN DBMS_SQL.VARCHAR2S

Line 2020: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;

2016: )
2017: RETURN DBMS_SQL.VARCHAR2S
2018: IS
2019: --
2020: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;
2022: --
2023: l_adr_code VARCHAR2(30);
2024: l_Adr CLOB; -- 4697330

Line 2021: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;

2017: RETURN DBMS_SQL.VARCHAR2S
2018: IS
2019: --
2020: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;
2021: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;
2022: --
2023: l_adr_code VARCHAR2(30);
2024: l_Adr CLOB; -- 4697330
2025: l_array_adr DBMS_SQL.VARCHAR2S;

Line 2145: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2141: p_product_rule_code IN VARCHAR2
2142: , p_product_rule_type_code IN VARCHAR2
2143: , p_application_id IN NUMBER
2144: , p_amb_context_code IN VARCHAR2
2145: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2146: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2147: , p_IsCompiled IN OUT NOCOPY BOOLEAN
2148: )
2149: RETURN DBMS_SQL.VARCHAR2S

Line 2146: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2142: , p_product_rule_type_code IN VARCHAR2
2143: , p_application_id IN NUMBER
2144: , p_amb_context_code IN VARCHAR2
2145: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2146: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2147: , p_IsCompiled IN OUT NOCOPY BOOLEAN
2148: )
2149: RETURN DBMS_SQL.VARCHAR2S
2150: IS

Line 2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;

2273: AND xld.budgetary_control_flag = XLA_CMP_PAD_PKG.g_bc_pkg_flag
2274: ORDER BY 5,2,3 --ORDER BY xsrb.flexfield_segment_code, xsrb.segment_rule_type_code, xsrb.segment_rule_code
2275: ;
2276: --
2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;
2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;

Line 2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;

2274: ORDER BY 5,2,3 --ORDER BY xsrb.flexfield_segment_code, xsrb.segment_rule_type_code, xsrb.segment_rule_code
2275: ;
2276: --
2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;
2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;

Line 2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;

2275: ;
2276: --
2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;
2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;

Line 2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;

2276: --
2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;
2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;

Line 2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;

2277: l_array_adr_appl_id xla_cmp_source_pkg.t_array_Num;
2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;

Line 2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;

2278: l_array_adr_code xla_cmp_source_pkg.t_array_VL30;
2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --

Line 2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;

2279: l_array_adr_name xla_cmp_source_pkg.t_array_VL80;
2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;

Line 2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;

2280: l_array_adr_type_code xla_cmp_source_pkg.t_array_VL1;
2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;
2288: l_array_string DBMS_SQL.VARCHAR2S;

Line 2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;

2281: l_array_assign_mode xla_cmp_source_pkg.t_array_VL1;
2282: l_array_flex_segment_code xla_cmp_source_pkg.t_array_VL30;
2283: l_array_flex_value_set_id xla_cmp_source_pkg.t_array_Num;
2284: l_array_trans_coa_id xla_cmp_source_pkg.t_array_Num;
2285: l_array_acctg_coa_id xla_cmp_source_pkg.t_array_Num;
2286: --
2287: l_null_array_string DBMS_SQL.VARCHAR2S;
2288: l_array_string DBMS_SQL.VARCHAR2S;
2289: l_Adrs DBMS_SQL.VARCHAR2S;

Line 2418: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2414: , p_application_id IN NUMBER
2415: , p_amb_context_code IN VARCHAR2
2416: , p_package_name IN VARCHAR2
2417: --
2418: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2419: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2420: --
2421: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
2422: )

Line 2419: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2415: , p_amb_context_code IN VARCHAR2
2416: , p_package_name IN VARCHAR2
2417: --
2418: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2419: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2420: --
2421: , p_package_body OUT NOCOPY DBMS_SQL.VARCHAR2S
2422: )
2423: RETURN BOOLEAN

Line 2541: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2537: , p_transaction_coa_id IN NUMBER
2538: , p_accounting_coa_id IN NUMBER
2539: , p_adr_name IN VARCHAR2
2540:
2541: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2542:
2543: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2544: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2545:

Line 2543: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2539: , p_adr_name IN VARCHAR2
2540:
2541: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2542:
2543: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2544: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2545:
2546: , x_adr_spec_text OUT NOCOPY CLOB
2547: )

Line 2544: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2540:
2541: , p_array_adr_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2542:
2543: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2544: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2545:
2546: , x_adr_spec_text OUT NOCOPY CLOB
2547: )
2548: RETURN BOOLEAN

Line 2599: l_parms:= xla_cmp_source_pkg.get_obj_parm_for_tab(

2595: g_component_type;
2596: RAISE ge_fatal_error;
2597: END IF;
2598:
2599: l_parms:= xla_cmp_source_pkg.get_obj_parm_for_tab(
2600: p_array_source_index => p_array_adr_source_index
2601: , p_rec_sources => p_rec_sources
2602: );
2603:

Line 2609: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (

2605: ,'$parameters$'
2606: ,NVL(l_parms, ' ')
2607: ); -- 4417664
2608:
2609: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
2610: p_object => xla_cmp_source_pkg.C_ADR
2611: , p_object_code => p_segment_rule_code
2612: , p_object_type_code => p_segment_rule_type_code
2613: , p_application_id => p_application_id

Line 2610: p_object => xla_cmp_source_pkg.C_ADR

2606: ,NVL(l_parms, ' ')
2607: ); -- 4417664
2608:
2609: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
2610: p_object => xla_cmp_source_pkg.C_ADR
2611: , p_object_code => p_segment_rule_code
2612: , p_object_type_code => p_segment_rule_type_code
2613: , p_application_id => p_application_id
2614: , p_array_source_Index => p_array_adr_source_index

Line 2707: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2703: , p_transaction_coa_id IN NUMBER
2704: , p_accounting_coa_id IN NUMBER
2705: , p_adr_name IN VARCHAR2
2706: --
2707: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2708: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2709: --
2710: , x_adr_hash_id OUT NOCOPY BINARY_INTEGER
2711: , x_adr_function_name OUT NOCOPY VARCHAR2

Line 2708: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2704: , p_accounting_coa_id IN NUMBER
2705: , p_adr_name IN VARCHAR2
2706: --
2707: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2708: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2709: --
2710: , x_adr_hash_id OUT NOCOPY BINARY_INTEGER
2711: , x_adr_function_name OUT NOCOPY VARCHAR2
2712: , x_table_of_adr_sources OUT NOCOPY gt_table_of_adr_sources

Line 2720: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;

2716: )
2717: RETURN BOOLEAN
2718: IS
2719:
2720: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;
2721: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;
2722:
2723: l_adr_code VARCHAR2(30);
2724: l_adr_body VARCHAR2(32000);

Line 2721: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;

2717: RETURN BOOLEAN
2718: IS
2719:
2720: l_array_adr_source_index xla_cmp_source_pkg.t_array_ByInt;
2721: l_array_null_adr_source_Idx xla_cmp_source_pkg.t_array_ByInt;
2722:
2723: l_adr_code VARCHAR2(30);
2724: l_adr_body VARCHAR2(32000);
2725: l_parms VARCHAR2(10000);

Line 2803: x_adr_hash_id := xla_cmp_source_pkg.CacheAADObject

2799: , x_adr_spec_text => x_adr_spec
2800: );
2801:
2802: --Get the ADR hash id assigned during the compilation
2803: x_adr_hash_id := xla_cmp_source_pkg.CacheAADObject
2804: (
2805: p_object => xla_cmp_source_pkg.C_ADR
2806: ,p_object_code => p_segment_rule_code
2807: ,p_object_type_code => p_segment_rule_type_code

Line 2805: p_object => xla_cmp_source_pkg.C_ADR

2801:
2802: --Get the ADR hash id assigned during the compilation
2803: x_adr_hash_id := xla_cmp_source_pkg.CacheAADObject
2804: (
2805: p_object => xla_cmp_source_pkg.C_ADR
2806: ,p_object_code => p_segment_rule_code
2807: ,p_object_type_code => p_segment_rule_type_code
2808: ,p_application_id => p_application_id
2809: ,p_array_source_Index => l_array_adr_source_index

Line 2951: l_rec_aad_objects xla_cmp_source_pkg.t_rec_aad_objects ;

2947: l_trans_coa_id NUMBER;
2948: l_acctg_coa_id NUMBER;
2949: l_adr_name VARCHAR2(80);
2950:
2951: l_rec_aad_objects xla_cmp_source_pkg.t_rec_aad_objects ;
2952: l_rec_sources xla_cmp_source_pkg.t_rec_sources;
2953:
2954:
2955: l_array_string DBMS_SQL.VARCHAR2S;

Line 2952: l_rec_sources xla_cmp_source_pkg.t_rec_sources;

2948: l_acctg_coa_id NUMBER;
2949: l_adr_name VARCHAR2(80);
2950:
2951: l_rec_aad_objects xla_cmp_source_pkg.t_rec_aad_objects ;
2952: l_rec_sources xla_cmp_source_pkg.t_rec_sources;
2953:
2954:
2955: l_array_string DBMS_SQL.VARCHAR2S;
2956: