eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_CMP_EVENT_TYPE_PKG dependencies on XLA_CMP_SOURCE_PKG

Line 1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1314: p_application_id IN NUMBER
1315: , p_amb_context_code IN VARCHAR2
1316: , p_product_rule_code IN VARCHAR2
1317: , p_product_rule_type_code IN VARCHAR2
1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1315: , p_amb_context_code IN VARCHAR2
1316: , p_product_rule_code IN VARCHAR2
1317: , p_product_rule_type_code IN VARCHAR2
1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1323: )

Line 1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1316: , p_product_rule_code IN VARCHAR2
1317: , p_product_rule_type_code IN VARCHAR2
1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1323: )
1324: IS

Line 1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1317: , p_product_rule_type_code IN VARCHAR2
1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1323: )
1324: IS
1325: --

Line 1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

1318: , p_array_entity OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1319: , p_array_event_class OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1320: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1321: , p_array_event_class_acctd_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1322: , p_array_event_class_g_l_flag OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
1323: )
1324: IS
1325: --
1326: -- get event_type belong entered product rule

Line 1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

1402: AND xald.line_definition_code = xld.line_definition_code
1403: AND xld.budgetary_control_flag = 'Y'
1404: ORDER BY xpah.event_type_code;
1405: --
1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;
1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

Line 1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;

1403: AND xld.budgetary_control_flag = 'Y'
1404: ORDER BY xpah.event_type_code;
1405: --
1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;
1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
1411: l_log_module VARCHAR2(240);

Line 1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;

1404: ORDER BY xpah.event_type_code;
1405: --
1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;
1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
1411: l_log_module VARCHAR2(240);
1412: --

Line 1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;

1405: --
1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;
1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
1411: l_log_module VARCHAR2(240);
1412: --
1413: BEGIN

Line 1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

1406: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1407: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
1408: l_array_entity xla_cmp_source_pkg.t_array_VL30;
1409: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
1410: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
1411: l_log_module VARCHAR2(240);
1412: --
1413: BEGIN
1414:

Line 1500: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1496: p_application_id IN NUMBER
1497: , p_amb_context_code IN VARCHAR2
1498: , p_product_rule_code IN VARCHAR2
1499: , p_product_rule_type_code IN VARCHAR2
1500: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1501: )
1502: IS
1503: --
1504: -- get event_type belong entered product rule

Line 1531: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

1527: OR
1528: xpah.validation_status_code <> 'R') -- not Running
1529: ;
1530: --
1531: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1532: l_log_module VARCHAR2(240);
1533: --
1534: BEGIN
1535: IF g_log_enabled THEN

Line 1595: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

1591: PROCEDURE GetEventType(
1592: p_application_id IN NUMBER
1593: , p_entity_code IN VARCHAR2
1594: , p_event_class_code IN VARCHAR2
1595: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1596: )
1597: IS
1598: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1599:

Line 1598: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

1594: , p_event_class_code IN VARCHAR2
1595: , p_array_event_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
1596: )
1597: IS
1598: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
1599:
1600: CURSOR event_type_cur
1601: IS
1602: SELECT DISTINCT

Line 1877: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30

1873: --+==========================================================================+
1874: --
1875: FUNCTION IsOptionFlagInEventExtract (
1876: p_source_option IN VARCHAR2
1877: , p_array_source_code IN xla_cmp_source_pkg.t_array_VL30
1878: )
1879: RETURN NUMBER
1880: IS
1881:

Line 1883: l_array_source_code xla_cmp_source_pkg.t_array_VL30;

1879: RETURN NUMBER
1880: IS
1881:
1882: l_IsSourceExists NUMBER;
1883: l_array_source_code xla_cmp_source_pkg.t_array_VL30;
1884: l_log_module VARCHAR2(240);
1885:
1886: BEGIN
1887: IF g_log_enabled THEN

Line 1955: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

1951: --| |
1952: --+==========================================================================+
1953: --
1954: PROCEDURE GetIndexOfOptionFlags (
1955: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1956: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1957: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1958: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1959: , p_ThirdPartyIdx OUT NOCOPY NUMBER

Line 1956: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

1952: --+==========================================================================+
1953: --
1954: PROCEDURE GetIndexOfOptionFlags (
1955: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1956: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1957: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1958: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1959: , p_ThirdPartyIdx OUT NOCOPY NUMBER
1960: , p_AcctReversalIdx OUT NOCOPY NUMBER

Line 1957: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30

1953: --
1954: PROCEDURE GetIndexOfOptionFlags (
1955: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1956: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1957: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1958: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1959: , p_ThirdPartyIdx OUT NOCOPY NUMBER
1960: , p_AcctReversalIdx OUT NOCOPY NUMBER
1961: , p_TrxReversalIdx OUT NOCOPY NUMBER

Line 1958: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

1954: PROCEDURE GetIndexOfOptionFlags (
1955: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1956: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1957: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
1958: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
1959: , p_ThirdPartyIdx OUT NOCOPY NUMBER
1960: , p_AcctReversalIdx OUT NOCOPY NUMBER
1961: , p_TrxReversalIdx OUT NOCOPY NUMBER
1962: )

Line 2037: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2033: , p_amb_context_code IN VARCHAR2
2034: , p_product_rule_type_code IN VARCHAR2
2035: , p_product_rule_code IN VARCHAR2
2036: --
2037: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2041: --

Line 2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

2034: , p_product_rule_type_code IN VARCHAR2
2035: , p_product_rule_code IN VARCHAR2
2036: --
2037: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2041: --
2042: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

Line 2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

2035: , p_product_rule_code IN VARCHAR2
2036: --
2037: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2041: --
2042: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2043: )

Line 2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int

2036: --
2037: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2041: --
2042: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2043: )
2044: IS

Line 2042: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2038: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2039: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2040: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2041: --
2042: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2043: )
2044: IS
2045: --
2046: --

Line 2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;

2101: ;
2102: --
2103: --
2104: l_SourceIdx BINARY_INTEGER;
2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2109: l_source_code xla_cmp_source_pkg.t_array_VL30;

Line 2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;

2102: --
2103: --
2104: l_SourceIdx BINARY_INTEGER;
2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2109: l_source_code xla_cmp_source_pkg.t_array_VL30;
2110: l_log_module VARCHAR2(240);

Line 2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;

2103: --
2104: l_SourceIdx BINARY_INTEGER;
2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2109: l_source_code xla_cmp_source_pkg.t_array_VL30;
2110: l_log_module VARCHAR2(240);
2111: --

Line 2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;

2104: l_SourceIdx BINARY_INTEGER;
2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2109: l_source_code xla_cmp_source_pkg.t_array_VL30;
2110: l_log_module VARCHAR2(240);
2111: --
2112: BEGIN

Line 2109: l_source_code xla_cmp_source_pkg.t_array_VL30;

2105: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2106: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2107: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2108: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2109: l_source_code xla_cmp_source_pkg.t_array_VL30;
2110: l_log_module VARCHAR2(240);
2111: --
2112: BEGIN
2113: --

Line 2164: l_SourceIdx := xla_cmp_source_pkg.StackSource(

2160: ,p_module => l_log_module);
2161: END IF;
2162: IF l_source_code.EXISTS(Idx) AND l_source_code(Idx) IS NOT NULL THEN
2163:
2164: l_SourceIdx := xla_cmp_source_pkg.StackSource(
2165: p_source_code => l_source_code(Idx)
2166: , p_source_type_code => l_source_type_code(Idx)
2167: , p_source_application_id => l_source_application_id(Idx)
2168: , p_array_source_index => p_array_evt_source_index

Line 2217: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2213: p_entity IN VARCHAR2
2214: , p_event_class IN VARCHAR2
2215: , p_application_id IN NUMBER
2216: --
2217: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2221: --

Line 2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

2214: , p_event_class IN VARCHAR2
2215: , p_application_id IN NUMBER
2216: --
2217: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2221: --
2222: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

Line 2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

2215: , p_application_id IN NUMBER
2216: --
2217: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2221: --
2222: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2223: )

Line 2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int

2216: --
2217: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2221: --
2222: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2223: )
2224: IS

Line 2222: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2218: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2219: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2220: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2221: --
2222: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2223: )
2224: IS
2225: --
2226: CURSOR source_cur

Line 2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;

2251: AND xsb.source_code = eca.source_code
2252: ;
2253: --
2254: l_SourceIdx BINARY_INTEGER;
2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2259: l_source_code xla_cmp_source_pkg.t_array_VL30;

Line 2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;

2252: ;
2253: --
2254: l_SourceIdx BINARY_INTEGER;
2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2259: l_source_code xla_cmp_source_pkg.t_array_VL30;
2260: l_number NUMBER;

Line 2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;

2253: --
2254: l_SourceIdx BINARY_INTEGER;
2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2259: l_source_code xla_cmp_source_pkg.t_array_VL30;
2260: l_number NUMBER;
2261: l_log_module VARCHAR2(240);

Line 2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;

2254: l_SourceIdx BINARY_INTEGER;
2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2259: l_source_code xla_cmp_source_pkg.t_array_VL30;
2260: l_number NUMBER;
2261: l_log_module VARCHAR2(240);
2262: --

Line 2259: l_source_code xla_cmp_source_pkg.t_array_VL30;

2255: l_accounting_source xla_cmp_source_pkg.t_array_VL30;
2256: l_accounting_source_type xla_cmp_source_pkg.t_array_VL1;
2257: l_source_application_id xla_cmp_source_pkg.t_array_Num;
2258: l_source_type_code xla_cmp_source_pkg.t_array_VL1;
2259: l_source_code xla_cmp_source_pkg.t_array_VL30;
2260: l_number NUMBER;
2261: l_log_module VARCHAR2(240);
2262: --
2263: BEGIN

Line 2314: l_SourceIdx := xla_cmp_source_pkg.StackSource (

2310: FOR Idx IN l_accounting_source.FIRST .. l_accounting_source.LAST LOOP
2311:
2312: IF l_source_code.EXISTS(Idx) AND l_source_code(Idx) IS NOT NULL THEN
2313:
2314: l_SourceIdx := xla_cmp_source_pkg.StackSource (
2315: p_source_code => l_source_code(Idx)
2316: , p_source_type_code => l_source_type_code(Idx)
2317: , p_source_application_id => l_source_application_id(Idx)
2318: , p_array_source_index => p_array_evt_source_index

Line 2374: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2370: , p_application_id IN NUMBER
2371: , p_product_rule_code IN VARCHAR2
2372: , p_product_rule_type_code IN VARCHAR2
2373: , p_amb_context_code IN VARCHAR2
2374: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2375: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2376: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2377: )
2378: IS

Line 2376: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2372: , p_product_rule_type_code IN VARCHAR2
2373: , p_amb_context_code IN VARCHAR2
2374: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2375: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2376: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2377: )
2378: IS
2379: --
2380: l_description_type_code VARCHAR2(1);

Line 2412: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(

2408: AND xpah.amb_context_code = p_amb_context_code
2409: AND xpah.accounting_required_flag = 'Y'
2410: ;
2411:
2412: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(
2413: p_object => xla_cmp_source_pkg.C_DESC
2414: , p_object_code => l_description_code
2415: , p_object_type_code => l_description_type_code
2416: , p_application_id => p_application_id

Line 2413: p_object => xla_cmp_source_pkg.C_DESC

2409: AND xpah.accounting_required_flag = 'Y'
2410: ;
2411:
2412: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(
2413: p_object => xla_cmp_source_pkg.C_DESC
2414: , p_object_code => l_description_code
2415: , p_object_type_code => l_description_type_code
2416: , p_application_id => p_application_id
2417: , p_event_class_code => NULL

Line 2424: xla_cmp_source_pkg.GetSourcesInAADObject(

2420: );
2421:
2422: IF l_ObjectIndex IS NOT NULL THEN
2423:
2424: xla_cmp_source_pkg.GetSourcesInAADObject(
2425: p_object => xla_cmp_source_pkg.C_DESC
2426: , p_object_code => l_description_code
2427: , p_object_type_code => l_description_type_code
2428: , p_application_id => p_application_id

Line 2425: p_object => xla_cmp_source_pkg.C_DESC

2421:
2422: IF l_ObjectIndex IS NOT NULL THEN
2423:
2424: xla_cmp_source_pkg.GetSourcesInAADObject(
2425: p_object => xla_cmp_source_pkg.C_DESC
2426: , p_object_code => l_description_code
2427: , p_object_type_code => l_description_type_code
2428: , p_application_id => p_application_id
2429: , p_event_class_code => NULL

Line 2493: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2489: , p_application_id IN NUMBER
2490: , p_product_rule_code IN VARCHAR2
2491: , p_product_rule_type_code IN VARCHAR2
2492: , p_amb_context_code IN VARCHAR2
2493: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2494: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2495: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2496: )
2497: IS

Line 2494: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2490: , p_product_rule_code IN VARCHAR2
2491: , p_product_rule_type_code IN VARCHAR2
2492: , p_amb_context_code IN VARCHAR2
2493: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2494: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2495: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2496: )
2497: IS
2498: --

Line 2495: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2491: , p_product_rule_type_code IN VARCHAR2
2492: , p_amb_context_code IN VARCHAR2
2493: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2494: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2495: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2496: )
2497: IS
2498: --
2499: CURSOR alt_cur

Line 2545: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;

2541: ORDER BY xldj.accounting_line_type_code, xldj.accounting_line_code
2542: , xldj.line_definition_owner_code, xldj.line_definition_code
2543: ;
2544: --
2545: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
2546: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
2547: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
2548: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
2549: l_ObjectIndex BINARY_INTEGER;

Line 2546: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;

2542: , xldj.line_definition_owner_code, xldj.line_definition_code
2543: ;
2544: --
2545: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
2546: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
2547: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
2548: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
2549: l_ObjectIndex BINARY_INTEGER;
2550: l_log_module VARCHAR2(240);

Line 2547: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;

2543: ;
2544: --
2545: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
2546: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
2547: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
2548: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
2549: l_ObjectIndex BINARY_INTEGER;
2550: l_log_module VARCHAR2(240);
2551: invalid_jlt EXCEPTION;

Line 2548: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;

2544: --
2545: l_array_alt_code xla_cmp_source_pkg.t_array_VL30;
2546: l_array_alt_type_code xla_cmp_source_pkg.t_array_VL1;
2547: l_array_jld_code xla_cmp_source_pkg.t_array_VL30;
2548: l_array_jld_owner_code xla_cmp_source_pkg.t_array_VL1;
2549: l_ObjectIndex BINARY_INTEGER;
2550: l_log_module VARCHAR2(240);
2551: invalid_jlt EXCEPTION;
2552: --

Line 2584: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(

2580: FOR Idx IN l_array_alt_code.FIRST .. l_array_alt_code.LAST LOOP
2581:
2582: IF l_array_alt_code.EXISTS(Idx) THEN
2583:
2584: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(
2585: p_object => xla_cmp_source_pkg.C_ALT
2586: , p_object_code => l_array_alt_code(Idx)
2587: , p_object_type_code => l_array_alt_type_code(Idx)
2588: , p_application_id => p_application_id

Line 2585: p_object => xla_cmp_source_pkg.C_ALT

2581:
2582: IF l_array_alt_code.EXISTS(Idx) THEN
2583:
2584: l_ObjectIndex :=xla_cmp_source_pkg.GetAADObjectPosition(
2585: p_object => xla_cmp_source_pkg.C_ALT
2586: , p_object_code => l_array_alt_code(Idx)
2587: , p_object_type_code => l_array_alt_type_code(Idx)
2588: , p_application_id => p_application_id
2589: , p_line_definition_code => l_array_jld_code(Idx)

Line 2598: xla_cmp_source_pkg.GetSourcesInAADObject(

2594: );
2595:
2596: IF l_ObjectIndex IS NOT NULL THEN
2597:
2598: xla_cmp_source_pkg.GetSourcesInAADObject(
2599: p_object => xla_cmp_source_pkg.C_ALT
2600: , p_object_code => l_array_alt_code(Idx)
2601: , p_object_type_code => l_array_alt_type_code(Idx)
2602: , p_application_id => p_application_id

Line 2599: p_object => xla_cmp_source_pkg.C_ALT

2595:
2596: IF l_ObjectIndex IS NOT NULL THEN
2597:
2598: xla_cmp_source_pkg.GetSourcesInAADObject(
2599: p_object => xla_cmp_source_pkg.C_ALT
2600: , p_object_code => l_array_alt_code(Idx)
2601: , p_object_type_code => l_array_alt_type_code(Idx)
2602: , p_application_id => p_application_id
2603: , p_line_definition_code => l_array_jld_code(Idx)

Line 2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2673: , p_application_id IN NUMBER
2674: , p_product_rule_code IN VARCHAR2
2675: , p_product_rule_type_code IN VARCHAR2
2676: , p_amb_context_code IN VARCHAR2
2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

Line 2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

2674: , p_product_rule_code IN VARCHAR2
2675: , p_product_rule_type_code IN VARCHAR2
2676: , p_amb_context_code IN VARCHAR2
2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

Line 2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

2675: , p_product_rule_type_code IN VARCHAR2
2676: , p_amb_context_code IN VARCHAR2
2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int

Line 2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int

2676: , p_amb_context_code IN VARCHAR2
2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER

Line 2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30

2677: , p_array_evt_source_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

Line 2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1

2678: , p_array_hdr_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

Line 2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int

2679: , p_array_hdr_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2680: , p_array_hdr_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2687: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

Line 2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt

2681: , p_array_line_acctg_source OUT NOCOPY xla_cmp_source_pkg.t_array_VL30
2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2687: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2688: )
2689: IS

Line 2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

2682: , p_array_line_acctg_source_type OUT NOCOPY xla_cmp_source_pkg.t_array_VL1
2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2687: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2688: )
2689: IS
2690:

Line 2687: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2683: , p_array_line_acct_attr_source OUT NOCOPY xla_cmp_source_pkg.t_array_int
2684: , p_hdr_description_index IN OUT NOCOPY BINARY_INTEGER
2685: , p_array_alt_index IN OUT NOCOPY xla_cmp_source_pkg.t_array_ByInt
2686: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
2687: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2688: )
2689: IS
2690:
2691: l_Idx BINARY_INTEGER;

Line 2856: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

2852: +-----------------------------------------------------------------------*/
2853:
2854: FUNCTION GenerateHdrDescription (
2855: p_hdr_description_index IN BINARY_INTEGER
2856: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
2857: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
2858: )
2859: RETURN CLOB
2860: IS

Line 2857: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources

2853:
2854: FUNCTION GenerateHdrDescription (
2855: p_hdr_description_index IN BINARY_INTEGER
2856: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
2857: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
2858: )
2859: RETURN CLOB
2860: IS
2861:

Line 2941: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

2937: | |
2938: +-----------------------------------------------------------------------*/
2939:
2940: FUNCTION GenerateHdrAcctgSources (
2941: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
2942: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
2943: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
2944: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2945: )

Line 2942: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

2938: +-----------------------------------------------------------------------*/
2939:
2940: FUNCTION GenerateHdrAcctgSources (
2941: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
2942: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
2943: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
2944: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2945: )
2946: RETURN CLOB

Line 2943: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

2939:
2940: FUNCTION GenerateHdrAcctgSources (
2941: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
2942: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
2943: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
2944: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2945: )
2946: RETURN CLOB
2947: IS

Line 2944: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

2940: FUNCTION GenerateHdrAcctgSources (
2941: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
2942: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
2943: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
2944: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
2945: )
2946: RETURN CLOB
2947: IS
2948: --

Line 2994: l_source := xla_cmp_source_pkg.GenerateSource(

2990: IF p_array_hdr_acctg_source(Idx) not in ('EXCHANGE_GAIN_CCID', 'EXCHANGE_LOSS_CCID') THEN
2991: IF p_array_hdr_acctg_source(Idx) <> 'ACCRUAL_REVERSAL_GL_DATE' THEN -- 4262811
2992: l_index := l_index + 1; -- 4262811
2993:
2994: l_source := xla_cmp_source_pkg.GenerateSource(
2995: p_Index => p_array_hdr_acct_attr_source(Idx)
2996: , p_rec_sources => p_rec_sources
2997: , p_variable => p_array_hdr_acctg_source_type(Idx)
2998: , p_translated_flag => 'N') ;

Line 3037: l_source := xla_cmp_source_pkg.GenerateSource(

3033: 'XLA_LAST_DAY_NEXT_GL_PERIOD') AND
3034: (p_rec_sources.array_source_type_code (p_array_hdr_acct_attr_source(Idx)) <> 'Y' OR
3035: p_rec_sources.array_application_id (p_array_hdr_acct_attr_source(Idx)) <> 602) THEN
3036:
3037: l_source := xla_cmp_source_pkg.GenerateSource(
3038: p_Index => p_array_hdr_acct_attr_source(Idx)
3039: , p_rec_sources => p_rec_sources
3040: , p_variable => p_array_hdr_acctg_source_type(Idx)
3041: , p_translated_flag => 'N') ;

Line 3107: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

3103: | |
3104: +-----------------------------------------------------------------------*/
3105:
3106: FUNCTION GenerateGainLossAcctSources(
3107: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3108: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3109: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3110: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3111: )

Line 3108: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

3104: +-----------------------------------------------------------------------*/
3105:
3106: FUNCTION GenerateGainLossAcctSources(
3107: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3108: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3109: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3110: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3111: )
3112: RETURN CLOB

Line 3109: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

3105:
3106: FUNCTION GenerateGainLossAcctSources(
3107: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3108: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3109: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3110: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3111: )
3112: RETURN CLOB
3113: IS

Line 3110: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

3106: FUNCTION GenerateGainLossAcctSources(
3107: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3108: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3109: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3110: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3111: )
3112: RETURN CLOB
3113: IS
3114: --

Line 3160: l_source := xla_cmp_source_pkg.GenerateSource(

3156: p_array_hdr_acctg_source_type.EXISTS(Idx) THEN
3157:
3158: IF p_array_hdr_acctg_source(Idx) in ('EXCHANGE_GAIN_CCID', 'EXCHANGE_LOSS_CCID') THEN
3159:
3160: l_source := xla_cmp_source_pkg.GenerateSource(
3161: p_Index => p_array_hdr_acct_attr_source(Idx)
3162: , p_rec_sources => p_rec_sources
3163: , p_variable => p_array_hdr_acctg_source_type(Idx)
3164: , p_translated_flag => 'N') ;

Line 3236: p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30

3232: | |
3233: +---------------------------------------------------------------*/
3234:
3235: FUNCTION GenerateReversalAcctgSources (
3236: p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3237: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3238: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3239: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3240: )

Line 3237: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

3233: +---------------------------------------------------------------*/
3234:
3235: FUNCTION GenerateReversalAcctgSources (
3236: p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3237: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3238: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3239: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3240: )
3241: RETURN CLOB

Line 3238: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

3234:
3235: FUNCTION GenerateReversalAcctgSources (
3236: p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3237: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3238: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3239: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3240: )
3241: RETURN CLOB
3242: IS

Line 3239: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

3235: FUNCTION GenerateReversalAcctgSources (
3236: p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3237: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3238: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3239: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3240: )
3241: RETURN CLOB
3242: IS
3243:

Line 3287: xla_cmp_source_pkg.GenerateSource(

3283: l_line_acctg_source := REPLACE(C_SET_REV_ACCT_SOURCES ,'$accounting_attribute$',
3284: p_array_line_acctg_source(Idx));
3285:
3286: l_line_acctg_source := REPLACE(l_line_acctg_source , '$source$',
3287: xla_cmp_source_pkg.GenerateSource(
3288: p_Index => p_array_line_acct_attr_source(Idx)
3289: , p_rec_sources => p_rec_sources
3290: , p_variable => p_array_line_acctg_source_type(Idx)
3291: , p_translated_flag => 'N')

Line 3358: p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt

3354: | |
3355: +---------------------------------------------------------------*/
3356:
3357: FUNCTION GenerateAcctLinetypes (
3358: p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3359: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3360: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3361: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3362: )

Line 3359: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1

3355: +---------------------------------------------------------------*/
3356:
3357: FUNCTION GenerateAcctLinetypes (
3358: p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3359: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3360: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3361: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3362: )
3363: RETURN CLOB

Line 3360: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

3356:
3357: FUNCTION GenerateAcctLinetypes (
3358: p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3359: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3360: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3361: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3362: )
3363: RETURN CLOB
3364: IS

Line 3361: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources

3357: FUNCTION GenerateAcctLinetypes (
3358: p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3359: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3360: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3361: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3362: )
3363: RETURN CLOB
3364: IS
3365:

Line 3473: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

3469: | 4884853 - add logic to get array_gl_date for accrual reversal|
3470: | |
3471: +---------------------------------------------------------------*/
3472: FUNCTION GenerateAccRevBody (
3473: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3474: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int -- (to generate ACCRUAL_REVERSAL_GL_DATE)
3475: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3476: )
3477: RETURN CLOB

Line 3474: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int -- (to generate ACCRUAL_REVERSAL_GL_DATE)

3470: | |
3471: +---------------------------------------------------------------*/
3472: FUNCTION GenerateAccRevBody (
3473: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3474: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int -- (to generate ACCRUAL_REVERSAL_GL_DATE)
3475: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3476: )
3477: RETURN CLOB
3478: IS

Line 3475: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources

3471: +---------------------------------------------------------------*/
3472: FUNCTION GenerateAccRevBody (
3473: p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3474: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int -- (to generate ACCRUAL_REVERSAL_GL_DATE)
3475: , p_rec_sources IN xla_cmp_source_pkg.t_rec_sources
3476: )
3477: RETURN CLOB
3478: IS
3479:

Line 3626: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt

3622: , p_event_class IN VARCHAR2
3623: , p_event_type IN VARCHAR2
3624:
3625: , p_hdr_description_index IN BINARY_INTEGER
3626: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1

3623: , p_event_type IN VARCHAR2
3624:
3625: , p_hdr_description_index IN BINARY_INTEGER
3626: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

3625: , p_hdr_description_index IN BINARY_INTEGER
3626: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

3626: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

3627: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:

Line 3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30

3628:
3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

Line 3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

3629: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

Line 3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

3630: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3631: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

Line 3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

3632: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:

Line 3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

3633: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

3634: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

3635:
3636: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3643:

Line 3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

3637: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3643:
3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

3638: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
3639: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3643:
3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3646:

Line 3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

3640:
3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3643:
3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3646:
3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

3641: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
3642: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
3643:
3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3646:
3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3649:

Line 3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

3643:
3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3646:
3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3649:
3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

3644: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3645: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3646:
3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3649:
3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3652:

Line 3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

3646:
3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3649:
3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3652:
3653: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3654: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

Line 3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

3647: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
3648: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
3649:
3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3652:
3653: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3654: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3655: )

Line 3653: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

3649:
3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3652:
3653: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3654: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3655: )
3656: RETURN CLOB
3657: IS

Line 3654: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

3650: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
3651: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
3652:
3653: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
3654: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
3655: )
3656: RETURN CLOB
3657: IS
3658:

Line 3725: , xla_cmp_source_pkg.GenerateSource(

3721: (l_body,'$third_party_code$', C_THIRD_PARTY_CHANGE_BODY);
3722:
3723: l_body := xla_cmp_string_pkg.replace_token(l_body
3724: ,'$third_party_change$'
3725: , xla_cmp_source_pkg.GenerateSource(
3726: p_Index => p_array_hdr_acct_attr_source(l_ThirdPartyIdx)
3727: , p_rec_sources => p_rec_sources
3728: , p_variable => p_array_hdr_acctg_source_type(l_ThirdPartyIdx)
3729: , p_translated_flag => 'N'

Line 3744: ,xla_cmp_source_pkg.GenerateSource(

3740: p_array_hdr_acct_attr_source(l_TrxReversalIdx) IS NOT NULL
3741: THEN
3742: l_body := xla_cmp_string_pkg.replace_token
3743: (l_body,'$trx_reversal_source$'
3744: ,xla_cmp_source_pkg.GenerateSource(
3745: p_Index => p_array_hdr_acct_attr_source(l_TrxReversalIdx)
3746: ,p_rec_sources => p_rec_sources
3747: ,p_variable => p_array_hdr_acctg_source_type(l_TrxReversalIdx)
3748: ,p_translated_flag => 'N')

Line 3916: , xla_cmp_source_pkg.GenerateSource

3912: p_array_line_acct_attr_source(l_AcctReversalIdx) IS NOT NULL
3913: THEN
3914: l_body := xla_cmp_string_pkg.replace_token -- 4417664
3915: (l_body,'$acct_reversal_source$'
3916: , xla_cmp_source_pkg.GenerateSource
3917: (p_Index => p_array_line_acct_attr_source(l_AcctReversalIdx)
3918: ,p_rec_sources => p_rec_sources
3919: ,p_variable => p_array_line_acctG_source_type(l_AcctReversalIdx)
3920: ,p_translated_flag => 'N')

Line 3984: p_array_table_name IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30,

3980: | |
3981: +---------------------------------------------------------------*/
3982:
3983: PROCEDURE PopulateBCObjectNames(
3984: p_array_table_name IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30,
3985: p_array_join_condition IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
3986: )
3987: IS
3988: l_log_module VARCHAR2(240);

Line 3985: p_array_join_condition IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000

3981: +---------------------------------------------------------------*/
3982:
3983: PROCEDURE PopulateBCObjectNames(
3984: p_array_table_name IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL30,
3985: p_array_join_condition IN OUT NOCOPY xla_cmp_source_pkg.t_array_VL2000
3986: )
3987: IS
3988: l_log_module VARCHAR2(240);
3989: BEGIN

Line 4052: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt

4048: , p_event_class IN VARCHAR2
4049: , p_event_type IN VARCHAR2
4050: --
4051: , p_hdr_description_index IN BINARY_INTEGER
4052: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1

4049: , p_event_type IN VARCHAR2
4050: --
4051: , p_hdr_description_index IN BINARY_INTEGER
4052: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

4051: , p_hdr_description_index IN BINARY_INTEGER
4052: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

4052: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

4053: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --

Line 4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30

4054: --
4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

Line 4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

4055: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

4056: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4057: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

Line 4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4058: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

4059: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --

Line 4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

4060: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

4061: --
4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

4062: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4063: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4070: --

Line 4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

4064: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4070: --
4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

4065: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4066: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4070: --
4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4073: --

Line 4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4067: --
4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4070: --
4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4073: --
4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

4068: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4069: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4070: --
4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4073: --
4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4076: --

Line 4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4070: --
4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4073: --
4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4076: --
4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4071: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4072: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4073: --
4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4076: --
4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4079: --

Line 4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

4073: --
4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4076: --
4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4079: --
4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

4074: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4075: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4076: --
4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4079: --
4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4082: --

Line 4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4076: --
4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4079: --
4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4082: --
4083: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4084: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

Line 4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4077: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4078: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4079: --
4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4082: --
4083: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4084: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4085: --

Line 4083: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

4079: --
4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4082: --
4083: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4084: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4085: --
4086: , p_extract_status IN BOOLEAN
4087: , p_procedure IN VARCHAR2

Line 4084: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

4080: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4081: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4082: --
4083: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4084: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4085: --
4086: , p_extract_status IN BOOLEAN
4087: , p_procedure IN VARCHAR2
4088: )

Line 4460: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt

4456: , p_acctd_flag IN VARCHAR2
4457: , p_g_l_flag IN VARCHAR2
4458: --
4459: , p_hdr_description_index IN BINARY_INTEGER
4460: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1

4457: , p_g_l_flag IN VARCHAR2
4458: --
4459: , p_hdr_description_index IN BINARY_INTEGER
4460: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30

4459: , p_hdr_description_index IN BINARY_INTEGER
4460: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

Line 4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

4460: , p_array_alt_index IN xla_cmp_source_pkg.t_array_ByInt
4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

Line 4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int

4461: , p_array_evt_source_Level IN xla_cmp_source_pkg.t_array_VL1
4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --

Line 4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30

4462: --
4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

Line 4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1

4463: , p_array_hdr_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int

4464: , p_array_hdr_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4465: , p_array_hdr_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

Line 4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30

4466: , p_array_line_acctg_source IN xla_cmp_source_pkg.t_array_VL30
4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt

4467: , p_array_line_acctg_source_type IN xla_cmp_source_pkg.t_array_VL1
4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --

Line 4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30

4468: , p_array_line_acct_attr_source IN xla_cmp_source_pkg.t_array_int
4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

Line 4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30

4469: --
4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

Line 4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1

4470: , p_array_table_name IN xla_cmp_source_pkg.t_array_VL30
4471: , p_array_parent_table_index IN xla_cmp_source_pkg.t_array_ByInt
4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4478: --

Line 4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1

4472: , p_array_table_type IN xla_cmp_source_pkg.t_array_VL30
4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4478: --
4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000

4473: , p_array_table_hash IN xla_cmp_source_pkg.t_array_VL30
4474: , p_array_populated_flag IN xla_cmp_source_pkg.t_array_VL1
4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4478: --
4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4481: --

Line 4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt

4475: --
4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4478: --
4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4481: --
4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt

4476: , p_array_ref_obj_flag IN xla_cmp_source_pkg.t_array_VL1
4477: , p_array_join_condition IN xla_cmp_source_pkg.t_array_VL2000
4478: --
4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4481: --
4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4484: --

Line 4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4478: --
4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4481: --
4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4484: --
4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4479: , p_array_h_source_index IN xla_cmp_source_pkg.t_array_ByInt
4480: , p_array_h_table_index IN xla_cmp_source_pkg.t_array_ByInt
4481: --
4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4484: --
4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4487: --

Line 4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt

4481: --
4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4484: --
4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4487: --
4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

Line 4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt

4482: , p_array_h_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4483: , p_array_h_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4484: --
4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4487: --
4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4490:

Line 4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt

4484: --
4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4487: --
4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4490:
4491: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4492: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

Line 4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt

4485: , p_array_l_source_index IN xla_cmp_source_pkg.t_array_ByInt
4486: , p_array_l_table_index IN xla_cmp_source_pkg.t_array_ByInt
4487: --
4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4490:
4491: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4492: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4493: --

Line 4491: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

4487: --
4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4490:
4491: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4492: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4493: --
4494: , p_extract_status IN BOOLEAN
4495: , p_procedure IN VARCHAR2

Line 4492: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

4488: , p_array_l_mls_source_index IN xla_cmp_source_pkg.t_array_ByInt
4489: , p_array_l_mls_table_index IN xla_cmp_source_pkg.t_array_ByInt
4490:
4491: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
4492: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
4493: --
4494: , p_extract_status IN BOOLEAN
4495: , p_procedure IN VARCHAR2
4496: )

Line 4645: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

4641: , p_application_id IN NUMBER
4642: , p_product_rule_code IN VARCHAR2
4643: , p_product_rule_type_code IN VARCHAR2
4644: , p_amb_context_code IN VARCHAR2
4645: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
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: )

Line 4646: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

4642: , p_product_rule_code IN VARCHAR2
4643: , p_product_rule_type_code IN VARCHAR2
4644: , p_amb_context_code IN VARCHAR2
4645: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
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

Line 4659: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;

4655: --
4656: l_IsExtractValid BOOLEAN;
4657: l_IsCompiled BOOLEAN;
4658: --
4659: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
4660: l_array_evt_source_level xla_cmp_source_pkg.t_array_VL1;
4661: --
4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --

Line 4660: l_array_evt_source_level xla_cmp_source_pkg.t_array_VL1;

4656: l_IsExtractValid BOOLEAN;
4657: l_IsCompiled BOOLEAN;
4658: --
4659: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
4660: l_array_evt_source_level xla_cmp_source_pkg.t_array_VL1;
4661: --
4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;

Line 4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;

4658: --
4659: l_array_evt_source_index xla_cmp_source_pkg.t_array_ByInt;
4660: l_array_evt_source_level xla_cmp_source_pkg.t_array_VL1;
4661: --
4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;

Line 4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;

4660: l_array_evt_source_level xla_cmp_source_pkg.t_array_VL1;
4661: --
4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;

Line 4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;

4661: --
4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;

Line 4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;

4662: l_array_null_source_index xla_cmp_source_pkg.t_array_ByInt;
4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --

Line 4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;

4663: --
4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;

Line 4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;

4664: l_array_hdr_acctg_source xla_cmp_source_pkg.t_array_VL30;
4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;

4665: l_array_hdr_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4666: l_array_hdr_acct_attr_source xla_cmp_source_pkg.t_array_int;
4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;

Line 4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;

4667: l_array_line_acctg_source xla_cmp_source_pkg.t_array_VL30;
4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

Line 4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;

4668: l_array_line_acctg_source_type xla_cmp_source_pkg.t_array_VL1;
4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --

Line 4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;

4669: l_array_line_acct_attr_source xla_cmp_source_pkg.t_array_int;
4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

Line 4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;

4670: --
4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

Line 4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;

4671: l_array_table_name xla_cmp_source_pkg.t_array_VL30;
4672: l_array_parent_table_index xla_cmp_source_pkg.t_array_ByInt;
4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
4679: --

Line 4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;

4673: l_array_table_type xla_cmp_source_pkg.t_array_VL30;
4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
4679: --
4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;

4674: l_array_table_hash xla_cmp_source_pkg.t_array_VL30;
4675: l_array_populated_flag xla_cmp_source_pkg.t_array_VL1;
4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
4679: --
4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
4682: --

Line 4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;

4676: --
4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
4679: --
4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
4682: --
4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;

4677: l_array_ref_obj_flag xla_cmp_source_pkg.t_array_VL1;
4678: l_array_join_condition xla_cmp_source_pkg.t_array_VL2000;
4679: --
4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
4682: --
4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4685: --

Line 4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

4679: --
4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
4682: --
4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4685: --
4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

4680: l_array_h_source_index xla_cmp_source_pkg.t_array_ByInt;
4681: l_array_h_table_index xla_cmp_source_pkg.t_array_ByInt;
4682: --
4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4685: --
4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
4688: --

Line 4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;

4682: --
4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4685: --
4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
4688: --
4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

Line 4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;

4683: l_array_h_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4684: l_array_h_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4685: --
4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
4688: --
4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4691: --

Line 4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;

4685: --
4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
4688: --
4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4691: --
4692: l_hdr_description_index BINARY_INTEGER;
4693: l_array_alt_index xla_cmp_source_pkg.t_array_ByInt;

Line 4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;

4686: l_array_l_source_index xla_cmp_source_pkg.t_array_ByInt;
4687: l_array_l_table_index xla_cmp_source_pkg.t_array_ByInt;
4688: --
4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4691: --
4692: l_hdr_description_index BINARY_INTEGER;
4693: l_array_alt_index xla_cmp_source_pkg.t_array_ByInt;
4694: --

Line 4693: l_array_alt_index xla_cmp_source_pkg.t_array_ByInt;

4689: l_array_l_mls_source_index xla_cmp_source_pkg.t_array_ByInt;
4690: l_array_l_mls_table_index xla_cmp_source_pkg.t_array_ByInt;
4691: --
4692: l_hdr_description_index BINARY_INTEGER;
4693: l_array_alt_index xla_cmp_source_pkg.t_array_ByInt;
4694: --
4695: l_ObjectIndex BINARY_INTEGER;
4696: l_log_module VARCHAR2(240);
4697: --

Line 4860: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (

4856: END IF;
4857:
4858: IF p_procedure = 'EVENT_TYPE' THEN
4859:
4860: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
4861: p_object => xla_cmp_source_pkg.C_EVT
4862: , p_object_code => p_event_type
4863: , p_object_type_code => 'S'
4864: , p_application_id => p_application_id

Line 4861: p_object => xla_cmp_source_pkg.C_EVT

4857:
4858: IF p_procedure = 'EVENT_TYPE' THEN
4859:
4860: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
4861: p_object => xla_cmp_source_pkg.C_EVT
4862: , p_object_code => p_event_type
4863: , p_object_type_code => 'S'
4864: , p_application_id => p_application_id
4865: , p_array_source_Index => l_array_evt_source_index

Line 4874: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (

4870: l_event := xla_cmp_string_pkg.replace_token(l_event,'$package_name$' , g_package_name); -- 4417664
4871:
4872: ELSIF p_procedure = 'EVENT_CLASS' THEN
4873:
4874: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
4875: p_object => xla_cmp_source_pkg.C_CLASS
4876: , p_object_code => p_event_class
4877: , p_object_type_code => 'S'
4878: , p_application_id => p_application_id

Line 4875: p_object => xla_cmp_source_pkg.C_CLASS

4871:
4872: ELSIF p_procedure = 'EVENT_CLASS' THEN
4873:
4874: l_ObjectIndex := xla_cmp_source_pkg.CacheAADObject (
4875: p_object => xla_cmp_source_pkg.C_CLASS
4876: , p_object_code => p_event_class
4877: , p_object_type_code => 'S'
4878: , p_application_id => p_application_id
4879: , p_array_source_Index => l_array_evt_source_index

Line 5116: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

5112: , p_event_type IN VARCHAR2
5113: , p_acctd_flag IN VARCHAR2
5114: , p_g_l_flag IN VARCHAR2
5115: --
5116: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
5117: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5118: --
5119: , p_IsCompiled OUT NOCOPY BOOLEAN
5120: )

Line 5117: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

5113: , p_acctd_flag IN VARCHAR2
5114: , p_g_l_flag IN VARCHAR2
5115: --
5116: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
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

Line 5251: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

5247: , p_product_rule_type_code IN VARCHAR2
5248: , p_application_id IN NUMBER
5249: , p_amb_context_code IN VARCHAR2
5250: --
5251: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
5252: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects
5253: --
5254: , p_IsCompiled OUT NOCOPY BOOLEAN
5255: )

Line 5252: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

5248: , p_application_id IN NUMBER
5249: , p_amb_context_code IN VARCHAR2
5250: --
5251: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources
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

Line 5262: l_array_entity xla_cmp_source_pkg.t_array_VL30;

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;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

Line 5263: l_array_event_class xla_cmp_source_pkg.t_array_VL30;

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;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --

Line 5264: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

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;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;

Line 5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;

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;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;
5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;

Line 5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

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;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;
5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;
5270: l_array_null_event_type xla_cmp_source_pkg.t_array_VL30;

Line 5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;

5264: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;
5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;
5270: l_array_null_event_type xla_cmp_source_pkg.t_array_VL30;
5271: --
5272: l_IsCompiled BOOLEAN;

Line 5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;

5265: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;
5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;
5270: l_array_null_event_type xla_cmp_source_pkg.t_array_VL30;
5271: --
5272: l_IsCompiled BOOLEAN;
5273: l_log_module VARCHAR2(240);

Line 5270: l_array_null_event_type xla_cmp_source_pkg.t_array_VL30;

5266: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5267: --
5268: l_array_null_entity xla_cmp_source_pkg.t_array_VL30;
5269: l_array_null_event_class xla_cmp_source_pkg.t_array_VL30;
5270: l_array_null_event_type xla_cmp_source_pkg.t_array_VL30;
5271: --
5272: l_IsCompiled BOOLEAN;
5273: l_log_module VARCHAR2(240);
5274: --

Line 5420: , p_rec_aad_objects IN OUT NOCOPY xla_cmp_source_pkg.t_rec_aad_objects

5416: , p_product_rule_version IN VARCHAR2
5417: , p_amb_context_code IN VARCHAR2
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

Line 5421: , p_rec_sources IN OUT NOCOPY xla_cmp_source_pkg.t_rec_sources

5417: , p_amb_context_code IN VARCHAR2
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

Line 5558: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

5554: , p_amb_context_code IN VARCHAR2
5555: , p_product_rule_code IN VARCHAR2
5556: , p_product_rule_type_code IN VARCHAR2
5557: , p_product_rule_name IN VARCHAR2
5558: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects
5559: )
5560: RETURN CLOB
5561: IS
5562: ------------------------------------------------------------

Line 5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;

5627: l_MainBodyProc CLOB;
5628: l_name VARCHAR2(80);
5629: l_ObjectIndex BINARY_INTEGER;
5630: l_call_event VARCHAR2(32000);
5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;

Line 5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;

5628: l_name VARCHAR2(80);
5629: l_ObjectIndex BINARY_INTEGER;
5630: l_call_event VARCHAR2(32000);
5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;

Line 5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;

5629: l_ObjectIndex BINARY_INTEGER;
5630: l_call_event VARCHAR2(32000);
5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

Line 5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;

5630: l_call_event VARCHAR2(32000);
5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5638: l_log_module VARCHAR2(240);

Line 5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;

5631: l_array_entity xla_cmp_source_pkg.t_array_VL30;
5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5638: l_log_module VARCHAR2(240);
5639:

Line 5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;

5632: l_array_event_type xla_cmp_source_pkg.t_array_VL30;
5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5638: l_log_module VARCHAR2(240);
5639:
5640: BEGIN

Line 5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;

5633: l_array_NoAcctg_event_type xla_cmp_source_pkg.t_array_VL30;
5634: l_array_event_class xla_cmp_source_pkg.t_array_VL30;
5635: l_array_EventTypeInClass xla_cmp_source_pkg.t_array_VL30;
5636: l_array_event_class_acctd_flag xla_cmp_source_pkg.t_array_VL1;
5637: l_array_event_class_g_l_flag xla_cmp_source_pkg.t_array_VL1;
5638: l_log_module VARCHAR2(240);
5639:
5640: BEGIN
5641:

Line 5692: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(

5688: IF l_array_event_type.COUNT > 0 THEN
5689: FOR Idx IN l_array_event_type.FIRST .. l_array_event_type.LAST LOOP
5690: IF (l_array_event_type(Idx) <> l_array_event_class(Idx)||'_ALL') THEN
5691:
5692: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(
5693: p_object => xla_cmp_source_pkg.C_EVT
5694: , p_object_code => l_array_event_type(Idx)
5695: , p_object_type_code => 'S'
5696: , p_application_id => p_application_id

Line 5693: p_object => xla_cmp_source_pkg.C_EVT

5689: FOR Idx IN l_array_event_type.FIRST .. l_array_event_type.LAST LOOP
5690: IF (l_array_event_type(Idx) <> l_array_event_class(Idx)||'_ALL') THEN
5691:
5692: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(
5693: p_object => xla_cmp_source_pkg.C_EVT
5694: , p_object_code => l_array_event_type(Idx)
5695: , p_object_type_code => 'S'
5696: , p_application_id => p_application_id
5697: , p_event_class_code => NULL

Line 5720: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(

5716: , p_array_event_type => l_array_EventTypeInClass);
5717: --
5718: IF l_array_EventTypeInClass.COUNT > 0 THEN
5719:
5720: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(
5721: p_object => xla_cmp_source_pkg.C_CLASS
5722: , p_object_code => l_array_event_class(Idx)
5723: , p_object_type_code => 'S'
5724: , p_application_id => p_application_id

Line 5721: p_object => xla_cmp_source_pkg.C_CLASS

5717: --
5718: IF l_array_EventTypeInClass.COUNT > 0 THEN
5719:
5720: l_ObjectIndex := xla_cmp_source_pkg.GetAADObjectPosition(
5721: p_object => xla_cmp_source_pkg.C_CLASS
5722: , p_object_code => l_array_event_class(Idx)
5723: , p_object_type_code => 'S'
5724: , p_application_id => p_application_id
5725: , p_event_class_code => NULL

Line 5836: , p_rec_aad_objects IN xla_cmp_source_pkg.t_rec_aad_objects

5832: , p_product_rule_version IN VARCHAR2
5833: , p_amb_context_code IN VARCHAR2
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