APPS.CSTPAPBR dependencies on CSTPALTY

Line 26: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;

22: o_err_num OUT NOCOPY NUMBER,
23: o_err_code OUT NOCOPY VARCHAR2,
24: o_err_msg OUT NOCOPY VARCHAR2
25: )IS
26: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
27: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
28: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
29: l_cost_type_name VARCHAR2(10);
30: l_cost_group_name VARCHAR2(10);

Line 27: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();

23: o_err_code OUT NOCOPY VARCHAR2,
24: o_err_msg OUT NOCOPY VARCHAR2
25: )IS
26: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
27: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
28: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
29: l_cost_type_name VARCHAR2(10);
30: l_cost_group_name VARCHAR2(10);
31: l_period_name VARCHAR2(15);

Line 28: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

24: o_err_msg OUT NOCOPY VARCHAR2
25: )IS
26: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
27: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
28: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
29: l_cost_type_name VARCHAR2(10);
30: l_cost_group_name VARCHAR2(10);
31: l_period_name VARCHAR2(15);
32: l_operating_unit NUMBER;

Line 583: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

579: | lines in the form of PL/SQL table and returns to the main procedure. |
580: |============================================================================*/
581:
582: PROCEDURE create_inv_ae_lines(
583: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

Line 584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

580: |============================================================================*/
581:
582: PROCEDURE create_inv_ae_lines(
583: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

581:
582: PROCEDURE create_inv_ae_lines(
583: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
589: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

583: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
589: l_err_rec CSTPALTY.cst_ae_err_rec_type;
590: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
591:

Line 588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

584: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
589: l_err_rec CSTPALTY.cst_ae_err_rec_type;
590: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
591:
592: /* Drop Ship/Global Proc changes */

Line 589: l_err_rec CSTPALTY.cst_ae_err_rec_type;

585: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
589: l_err_rec CSTPALTY.cst_ae_err_rec_type;
590: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
591:
592: /* Drop Ship/Global Proc changes */
593: l_logical_transaction NUMBER;

Line 590: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;

586: ) IS
587: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
588: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
589: l_err_rec CSTPALTY.cst_ae_err_rec_type;
590: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
591:
592: /* Drop Ship/Global Proc changes */
593: l_logical_transaction NUMBER;
594:

Line 634: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();

630: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
631: || ' transaction_id: ' || i_ae_txn_rec.transaction_id);
632: END IF;
633:
634: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
635: --l_ae_line_tbl := CSTPALBR.cst_ae_line_tbl_type();
636:
637: -- Initialize local variables.
638: -- ---------------------------

Line 1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

1205: -- ===================================================================
1206: -- WIP transactions.
1207: -- ===================================================================
1208: procedure wip_cost_txn(
1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1211: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1212: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1213: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

Line 1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

1206: -- WIP transactions.
1207: -- ===================================================================
1208: procedure wip_cost_txn(
1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1211: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1212: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1213: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
1214: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

Line 1211: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

1207: -- ===================================================================
1208: procedure wip_cost_txn(
1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1211: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1212: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1213: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
1214: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
1215: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 1212: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

1208: procedure wip_cost_txn(
1209: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1210: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1211: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1212: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1213: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
1214: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
1215: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
1216: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 1225: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1221: l_ovhd_absp NUMBER;
1222: l_mat_ovhd_exists NUMBER;
1223: l_rep_sched_id NUMBER;
1224: l_cost NUMBER;
1225: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1226: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1227: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
1228: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
1229: l_acct_class VARCHAR2(10);

Line 1226: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1222: l_mat_ovhd_exists NUMBER;
1223: l_rep_sched_id NUMBER;
1224: l_cost NUMBER;
1225: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1226: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1227: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
1228: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
1229: l_acct_class VARCHAR2(10);
1230: l_acct_line_type NUMBER;

Line 1575: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

1571: -- ===================================================================
1572: -- Subinventory transfer transactions.
1573: -- ===================================================================
1574: procedure sub_cost_txn(
1575: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1576: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1577: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1578: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1579: ) IS

Line 1576: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

1572: -- Subinventory transfer transactions.
1573: -- ===================================================================
1574: procedure sub_cost_txn(
1575: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1576: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1577: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1578: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1579: ) IS
1580: l_subinv VARCHAR2(10);

Line 1577: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

1573: -- ===================================================================
1574: procedure sub_cost_txn(
1575: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1576: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1577: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1578: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1579: ) IS
1580: l_subinv VARCHAR2(10);
1581: l_exp_sub1 NUMBER;

Line 1578: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

1574: procedure sub_cost_txn(
1575: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1576: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1577: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1578: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1579: ) IS
1580: l_subinv VARCHAR2(10);
1581: l_exp_sub1 NUMBER;
1582: l_exp_acct1 NUMBER;

Line 1591: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1587: l_stmt_num NUMBER;
1588: process_error EXCEPTION;
1589: l_dr_flag BOOLEAN;
1590: l_exp_flag BOOLEAN;
1591: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1592: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1593: BEGIN
1594:
1595: IF g_debug_flag = 'Y' THEN

Line 1592: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1588: process_error EXCEPTION;
1589: l_dr_flag BOOLEAN;
1590: l_exp_flag BOOLEAN;
1591: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1592: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1593: BEGIN
1594:
1595: IF g_debug_flag = 'Y' THEN
1596: fnd_file.put_line(fnd_file.log,'Sub_cost_txn <<');

Line 1829: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

1825: ===================================================================
1826: =================================================================== */
1827:
1828: procedure interorg_cost_txn(
1829: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1830: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1831: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1832: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1833: ) IS

Line 1830: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

1826: =================================================================== */
1827:
1828: procedure interorg_cost_txn(
1829: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1830: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1831: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1832: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1833: ) IS
1834: l_exp_sub1 NUMBER;

Line 1831: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

1827:
1828: procedure interorg_cost_txn(
1829: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1830: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1831: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1832: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1833: ) IS
1834: l_exp_sub1 NUMBER;
1835: l_exp_sub2 NUMBER;

Line 1832: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

1828: procedure interorg_cost_txn(
1829: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1830: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1831: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1832: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1833: ) IS
1834: l_exp_sub1 NUMBER;
1835: l_exp_sub2 NUMBER;
1836: l_exp_sub NUMBER;

Line 1842: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1838: l_exp2 NUMBER;
1839: l_dr_flag BOOLEAN;
1840: l_acct_exist NUMBER;
1841: l_stmt_num NUMBER := 0;
1842: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1843: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1844: l_txn_cost_group_id NUMBER;
1845: l_txfr_txn_cost_group_id NUMBER;
1846:

Line 1843: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1839: l_dr_flag BOOLEAN;
1840: l_acct_exist NUMBER;
1841: l_stmt_num NUMBER := 0;
1842: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1843: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1844: l_txn_cost_group_id NUMBER;
1845: l_txfr_txn_cost_group_id NUMBER;
1846:
1847: process_error EXCEPTION;

Line 1896: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

1892: l_mat_ovhd_cost NUMBER;
1893: l_ovhd_absp NUMBER;
1894: l_mptcd_cost NUMBER;
1895:
1896: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
1897:
1898: -- INVCONV sikhanna, Variables added for OPM Convergence project
1899: l_pwac_cost NUMBER;
1900: l_profit_or_loss NUMBER;

Line 5985: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

5981: -- ===================================================================
5982: -- Cost Update Transactions.
5983: -- ===================================================================
5984: procedure pcu_cost_txn(
5985: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5986: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5987: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5988: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5989: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

Line 5986: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

5982: -- Cost Update Transactions.
5983: -- ===================================================================
5984: procedure pcu_cost_txn(
5985: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5986: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5987: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5988: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5989: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5990: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

Line 5987: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

5983: -- ===================================================================
5984: procedure pcu_cost_txn(
5985: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5986: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5987: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5988: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5989: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5990: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
5991: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 5988: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

5984: procedure pcu_cost_txn(
5985: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5986: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5987: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5988: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5989: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5990: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
5991: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
5992: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 6001: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

5997: l_acct_exist NUMBER;
5998: l_ele_exist NUMBER;
5999: l_dr_flag BOOLEAN;
6000: l_loop_count NUMBER := 0;
6001: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6002: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6003: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6004: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
6005: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;

Line 6002: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

5998: l_ele_exist NUMBER;
5999: l_dr_flag BOOLEAN;
6000: l_loop_count NUMBER := 0;
6001: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6002: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6003: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6004: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
6005: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
6006: --l_err_rec CSTPALBR.cst_ae_err_rec_type;

Line 6003: l_err_rec CSTPALTY.cst_ae_err_rec_type;

5999: l_dr_flag BOOLEAN;
6000: l_loop_count NUMBER := 0;
6001: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6002: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6003: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6004: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
6005: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
6006: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
6007: l_txn_ce_bal_account NUMBER; -- Bug 4586534

Line 6473: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6469: -- ===================================================================
6470: -- Rest of inventory transactions.
6471: -- ===================================================================
6472: procedure inv_cost_txn(
6473: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6474: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6475: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6476: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6477: ) IS

Line 6474: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6470: -- Rest of inventory transactions.
6471: -- ===================================================================
6472: procedure inv_cost_txn(
6473: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6474: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6475: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6476: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6477: ) IS
6478: l_exp_sub NUMBER;

Line 6475: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6471: -- ===================================================================
6472: procedure inv_cost_txn(
6473: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6474: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6475: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6476: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6477: ) IS
6478: l_exp_sub NUMBER;
6479: l_dropship_type_code NUMBER;

Line 6476: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6472: procedure inv_cost_txn(
6473: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6474: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6475: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6476: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6477: ) IS
6478: l_exp_sub NUMBER;
6479: l_dropship_type_code NUMBER;
6480: l_elemental NUMBER;

Line 6488: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6484: l_stmt_num NUMBER;
6485: l_dr_flag BOOLEAN;
6486: l_exp_flag BOOLEAN;
6487: process_error EXCEPTION;
6488: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6489: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6490: l_count_so NUMBER;
6491: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6492: BEGIN

Line 6489: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

6485: l_dr_flag BOOLEAN;
6486: l_exp_flag BOOLEAN;
6487: process_error EXCEPTION;
6488: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6489: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6490: l_count_so NUMBER;
6491: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6492: BEGIN
6493:

Line 6860: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6856: --
6857: -- 20-Jul-03 Anju Creation
6858: -- ===================================================================
6859: procedure cost_logical_txn(
6860: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6861: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6862: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6863: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6864: ) IS

Line 6861: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6857: -- 20-Jul-03 Anju Creation
6858: -- ===================================================================
6859: procedure cost_logical_txn(
6860: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6861: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6862: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6863: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6864: ) IS
6865: l_exp_sub NUMBER;

Line 6862: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6858: -- ===================================================================
6859: procedure cost_logical_txn(
6860: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6861: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6862: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6863: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6864: ) IS
6865: l_exp_sub NUMBER;
6866: l_exp_acct NUMBER;

Line 6863: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6859: procedure cost_logical_txn(
6860: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6861: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6862: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6863: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6864: ) IS
6865: l_exp_sub NUMBER;
6866: l_exp_acct NUMBER;
6867: l_elemental NUMBER;

Line 6874: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6870: l_stmt_num NUMBER;
6871: l_dr_flag BOOLEAN;
6872: l_exp_flag BOOLEAN;
6873: process_error EXCEPTION;
6874: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6875: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6876:
6877: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6878: /* Bug12914738 */

Line 6875: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

6871: l_dr_flag BOOLEAN;
6872: l_exp_flag BOOLEAN;
6873: process_error EXCEPTION;
6874: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6875: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6876:
6877: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6878: /* Bug12914738 */
6879: l_acc_value NUMBER;

Line 6880: l_ae_line_rec_std_var CSTPALTY.cst_ae_line_rec_type;

6876:
6877: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6878: /* Bug12914738 */
6879: l_acc_value NUMBER;
6880: l_ae_line_rec_std_var CSTPALTY.cst_ae_line_rec_type;
6881: l_std_cost_adj_var_acct NUMBER;
6882: /* Bug12914738 */
6883: BEGIN
6884:

Line 7197: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7193: --
7194: -- 20-Jul-03 Anju Creation
7195: -- ===================================================================
7196: procedure cost_consigned_update_txn(
7197: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7198: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7199: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7200: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7201: ) IS

Line 7198: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7194: -- 20-Jul-03 Anju Creation
7195: -- ===================================================================
7196: procedure cost_consigned_update_txn(
7197: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7198: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7199: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7200: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7201: ) IS
7202: l_exp_sub NUMBER;

Line 7199: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7195: -- ===================================================================
7196: procedure cost_consigned_update_txn(
7197: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7198: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7199: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7200: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7201: ) IS
7202: l_exp_sub NUMBER;
7203: l_qty NUMBER;

Line 7200: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7196: procedure cost_consigned_update_txn(
7197: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7198: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7199: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7200: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7201: ) IS
7202: l_exp_sub NUMBER;
7203: l_qty NUMBER;
7204: l_exp_acct NUMBER;

Line 7214: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7210: l_ele_exist NUMBER;
7211: l_cost NUMBER;
7212: process_error EXCEPTION;
7213: no_txn_det_error EXCEPTION;
7214: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7215: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7216: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7217:
7218: BEGIN

Line 7215: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

7211: l_cost NUMBER;
7212: process_error EXCEPTION;
7213: no_txn_det_error EXCEPTION;
7214: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7215: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7216: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7217:
7218: BEGIN
7219:

Line 7216: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7212: process_error EXCEPTION;
7213: no_txn_det_error EXCEPTION;
7214: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7215: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7216: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7217:
7218: BEGIN
7219:
7220: IF g_debug_flag = 'Y' THEN

Line 7360: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7356:
7357:
7358:
7359: procedure encumbrance_account(
7360: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7361: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7362: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7364: ) IS

Line 7361: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7357:
7358:
7359: procedure encumbrance_account(
7360: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7361: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7362: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7364: ) IS
7365: l_acct NUMBER;

Line 7362: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7358:
7359: procedure encumbrance_account(
7360: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7361: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7362: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7364: ) IS
7365: l_acct NUMBER;
7366: l_acct_line_type NUMBER;

Line 7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7359: procedure encumbrance_account(
7360: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7361: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7362: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7364: ) IS
7365: l_acct NUMBER;
7366: l_acct_line_type NUMBER;
7367: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 7367: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7363: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7364: ) IS
7365: l_acct NUMBER;
7366: l_acct_line_type NUMBER;
7367: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7368: l_stmt_num NUMBER;
7369: l_dr_flag BOOLEAN;
7370: process_error exception;
7371: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 7371: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7367: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7368: l_stmt_num NUMBER;
7369: l_dr_flag BOOLEAN;
7370: process_error exception;
7371: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7372: BEGIN
7373: IF g_debug_flag = 'Y' THEN
7374: fnd_file.put_line(fnd_file.log,'Encumbrance_account <<');
7375: END IF;

Line 7439: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7435: -- Legal Entity-CG-CT and Item Category. Ignore the account passed
7436: -- since this used to be from Subinventory
7437:
7438: procedure inventory_accounts(
7439: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7440: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7441: i_exp_flag IN BOOLEAN,
7442: i_exp_account IN NUMBER,
7443: i_dr_flag IN BOOLEAN,

Line 7440: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7436: -- since this used to be from Subinventory
7437:
7438: procedure inventory_accounts(
7439: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7440: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7441: i_exp_flag IN BOOLEAN,
7442: i_exp_account IN NUMBER,
7443: i_dr_flag IN BOOLEAN,
7444: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

Line 7444: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7440: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7441: i_exp_flag IN BOOLEAN,
7442: i_exp_account IN NUMBER,
7443: i_dr_flag IN BOOLEAN,
7444: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7445: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7446: i_intransit_flag IN NUMBER
7447: ) IS
7448: l_cost NUMBER;

Line 7445: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,

7441: i_exp_flag IN BOOLEAN,
7442: i_exp_account IN NUMBER,
7443: i_dr_flag IN BOOLEAN,
7444: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7445: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7446: i_intransit_flag IN NUMBER
7447: ) IS
7448: l_cost NUMBER;
7449: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 7449: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7445: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7446: i_intransit_flag IN NUMBER
7447: ) IS
7448: l_cost NUMBER;
7449: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7450: l_ele_exist NUMBER;
7451: l_acct_exist NUMBER;
7452: l_stmt_num NUMBER := 0;
7453: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.inventory_accounts';

Line 7457: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7453: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.inventory_accounts';
7454:
7455: l_expense_account NUMBER;
7456:
7457: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7458: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7459:
7460: /* Bug 3123936: Propogation of 2896193 */
7461: l_dr_flag BOOLEAN;

Line 7458: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

7454:
7455: l_expense_account NUMBER;
7456:
7457: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7458: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7459:
7460: /* Bug 3123936: Propogation of 2896193 */
7461: l_dr_flag BOOLEAN;
7462: l_var NUMBER;

Line 7729: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7725: -- ===================================================================
7726: -- Offset Accounts.
7727: -- ===================================================================
7728: procedure offset_accounts(
7729: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7730: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7731: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7732: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7733: i_acct_line_type IN NUMBER,

Line 7730: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7726: -- Offset Accounts.
7727: -- ===================================================================
7728: procedure offset_accounts(
7729: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7730: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7731: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7732: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7733: i_acct_line_type IN NUMBER,
7734: i_elemental IN NUMBER,

Line 7737: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

7733: i_acct_line_type IN NUMBER,
7734: i_elemental IN NUMBER,
7735: i_ovhd_absp IN NUMBER,
7736: i_dr_flag IN BOOLEAN,
7737: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7738: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7739: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7740: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7741: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 7738: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7734: i_elemental IN NUMBER,
7735: i_ovhd_absp IN NUMBER,
7736: i_dr_flag IN BOOLEAN,
7737: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7738: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7739: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7740: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7741: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7742: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 7739: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7735: i_ovhd_absp IN NUMBER,
7736: i_dr_flag IN BOOLEAN,
7737: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7738: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7739: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7740: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7741: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7742: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
7743: )IS

Line 7744: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7740: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7741: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7742: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
7743: )IS
7744: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7745: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
7746: l_ele_exist NUMBER;
7747: l_cost NUMBER;
7748: l_stmt_num NUMBER := 0;

Line 7749: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7745: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
7746: l_ele_exist NUMBER;
7747: l_cost NUMBER;
7748: l_stmt_num NUMBER := 0;
7749: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7750: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7751: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
7752: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
7753: process_error EXCEPTION;

Line 7750: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

7746: l_ele_exist NUMBER;
7747: l_cost NUMBER;
7748: l_stmt_num NUMBER := 0;
7749: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7750: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7751: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
7752: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
7753: process_error EXCEPTION;
7754: no_txn_det_error EXCEPTION;

Line 7962: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7958: -- ===================================================================
7959: -- Overhead.
7960: -- ===================================================================
7961: procedure ovhd_accounts(
7962: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7963: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7964: i_dr_flag IN BOOLEAN,
7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

Line 7963: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7959: -- Overhead.
7960: -- ===================================================================
7961: procedure ovhd_accounts(
7962: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7963: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7964: i_dr_flag IN BOOLEAN,
7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7967: )IS

Line 7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7961: procedure ovhd_accounts(
7962: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7963: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7964: i_dr_flag IN BOOLEAN,
7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7967: )IS
7968: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7969: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7962: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7963: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7964: i_dr_flag IN BOOLEAN,
7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7967: )IS
7968: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7969: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7970: l_res_id NUMBER;

Line 7968: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7964: i_dr_flag IN BOOLEAN,
7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7967: )IS
7968: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7969: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7970: l_res_id NUMBER;
7971: l_cost NUMBER;
7972: l_stmt_num NUMBER;

Line 7969: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7965: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7966: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7967: )IS
7968: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7969: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7970: l_res_id NUMBER;
7971: l_cost NUMBER;
7972: l_stmt_num NUMBER;
7973: l_txn_cost_group_id NUMBER;

Line 8102: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8098: -- ===================================================================
8099: -- Insert Account.
8100: -- ===================================================================
8101: PROCEDURE insert_account(
8102: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8103: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8104: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
8106: i_dr_flag IN BOOLEAN,

Line 8103: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

8099: -- Insert Account.
8100: -- ===================================================================
8101: PROCEDURE insert_account(
8102: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8103: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8104: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
8106: i_dr_flag IN BOOLEAN,
8107: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

Line 8107: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

8103: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8104: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
8106: i_dr_flag IN BOOLEAN,
8107: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8108: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8109: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
8110: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8111: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 8108: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8104: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
8106: i_dr_flag IN BOOLEAN,
8107: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8108: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8109: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
8110: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8111: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8112: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)

Line 8109: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
8106: i_dr_flag IN BOOLEAN,
8107: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8108: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8109: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
8110: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8111: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8112: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
8113: IS

Line 8114: l_err_rec CSTPALTY.cst_ae_err_rec_type;

8110: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8111: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8112: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
8113: IS
8114: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8115: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
8116: l_entered_value NUMBER;
8117: l_accounted_value NUMBER;
8118: l_exp_sub1 NUMBER;

Line 8345: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8341: -- ===================================================================
8342: -- Balance Account.
8343: -- ===================================================================
8344: procedure balance_account (
8345: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8346: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
8347: --(l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8348: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
8349: IS

Line 8346: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

8342: -- Balance Account.
8343: -- ===================================================================
8344: procedure balance_account (
8345: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8346: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
8347: --(l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8348: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
8349: IS
8350: l_ent_value NUMBER := 0;

Line 8419: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8415: procedure create_wip_ae_lines(
8416: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8417: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8418: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8419: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

Line 8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8416: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8417: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8418: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8419: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

8417: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8418: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8419: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8425:

Line 8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

8419: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8425:
8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654
8427:

Line 8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;

8420: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8421: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8425:
8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654
8427:
8428: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654

8422: ) IS
8423: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8425:
8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654
8427:
8428: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8429: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8430: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();

Line 8428: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

8424: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8425:
8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654
8427:
8428: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8429: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8430: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();
8431: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;
8432: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;

Line 8429: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;

8425:
8426: l_ae_enc_curr_rec CSTPALTY.cst_ae_curr_rec_type; -- BUG#9356654
8427:
8428: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8429: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8430: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();
8431: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;
8432: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
8433: --l_ae_err_rec CSTPALBR.cst_ae_err_rec_type;

Line 8916: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8912: -- ===================================================================
8913: -- Get Account from the entities (Used in WIP transactions).
8914: -- ===================================================================
8915: procedure get_accts(
8916: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8917: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8918: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8919: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8920: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,

Line 8917: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

8913: -- Get Account from the entities (Used in WIP transactions).
8914: -- ===================================================================
8915: procedure get_accts(
8916: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8917: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8918: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8919: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8920: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8921: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 8918: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8914: -- ===================================================================
8915: procedure get_accts(
8916: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8917: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8918: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8919: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8920: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8921: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8922: o_acct_id1 OUT NOCOPY NUMBER,

Line 8924: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

8920: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8921: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8922: o_acct_id1 OUT NOCOPY NUMBER,
8923: o_acct_id2 OUT NOCOPY NUMBER,
8924: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8925: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8926: ) IS
8927: l_stmt_num NUMBER;
8928: l_entity_type NUMBER;

Line 8933: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;

8929: l_wip_entity_id NUMBER;
8930: l_line_id NUMBER;
8931: l_res_id NUMBER;
8932: l_acct_exist NUMBER;
8933: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8934: --l_ae_err_rec CSTPALBR.cst_ae_err_rec_type;
8935: no_dj_acct_error EXCEPTION;
8936: no_abs_acct_error EXCEPTION;
8937: no_wrs_acct_error EXCEPTION;

Line 9144: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

9140: -- ===================================================================
9141: -- WIP Accounts.
9142: -- ===================================================================
9143: procedure WIP_accounts(
9144: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9145: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9146: i_acct_line_type IN NUMBER,
9147: i_ovhd_absp IN NUMBER,
9148: i_dr_flag IN BOOLEAN,

Line 9145: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

9141: -- WIP Accounts.
9142: -- ===================================================================
9143: procedure WIP_accounts(
9144: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9145: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9146: i_acct_line_type IN NUMBER,
9147: i_ovhd_absp IN NUMBER,
9148: i_dr_flag IN BOOLEAN,
9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

Line 9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

9145: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9146: i_acct_line_type IN NUMBER,
9147: i_ovhd_absp IN NUMBER,
9148: i_dr_flag IN BOOLEAN,
9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
9150: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9151: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9152: )IS
9153: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 9150: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

9146: i_acct_line_type IN NUMBER,
9147: i_ovhd_absp IN NUMBER,
9148: i_dr_flag IN BOOLEAN,
9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
9150: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9151: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9152: )IS
9153: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9154: l_ele_exist NUMBER;

Line 9151: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

9147: i_ovhd_absp IN NUMBER,
9148: i_dr_flag IN BOOLEAN,
9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
9150: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9151: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9152: )IS
9153: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9154: l_ele_exist NUMBER;
9155: l_cost NUMBER;

Line 9153: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

9149: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
9150: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9151: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9152: )IS
9153: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9154: l_ele_exist NUMBER;
9155: l_cost NUMBER;
9156: l_dr_flag BOOLEAN;
9157: l_wip_variance NUMBER;

Line 9159: l_err_rec CSTPALTY.cst_ae_err_rec_type;

9155: l_cost NUMBER;
9156: l_dr_flag BOOLEAN;
9157: l_wip_variance NUMBER;
9158: l_stmt_num NUMBER;
9159: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9160: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9161: process_error EXCEPTION;
9162: no_txn_det_error EXCEPTION;
9163: BEGIN

Line 9160: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

9156: l_dr_flag BOOLEAN;
9157: l_wip_variance NUMBER;
9158: l_stmt_num NUMBER;
9159: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9160: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9161: process_error EXCEPTION;
9162: no_txn_det_error EXCEPTION;
9163: BEGIN
9164: IF g_debug_flag = 'Y' THEN

Line 9399: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

9395: -- This Procedure uses the same logic as in CST_TPRICE_PVT.Adjust_acct
9396: -- to get the intercompany accrual account id
9397: -- ========================================================================
9398: Function Get_Intercompany_account(
9399: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9400: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
9401: IS
9402: l_snd_sob_id NUMBER;
9403: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

Line 9400: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER

9396: -- to get the intercompany accrual account id
9397: -- ========================================================================
9398: Function Get_Intercompany_account(
9399: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9400: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
9401: IS
9402: l_snd_sob_id NUMBER;
9403: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9404: l_rcv_sob_id NUMBER;

Line 9410: l_err_rec CSTPALTY.cst_ae_err_rec_type;

9406: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
9407: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;
9408: l_conv_rate NUMBER;
9409: l_conv_date DATE;
9410: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9411: l_from_org NUMBER;
9412: l_to_org NUMBER;
9413: l_from_ou NUMBER;
9414: l_to_ou NUMBER;

Line 9725: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

9721: -- Cr. Payables @ Transfer price
9722:
9723: -- =======================================================================*/
9724: PROCEDURE cost_internal_order_exp_txn(
9725: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9726: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9727: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9728: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9729: )

Line 9726: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

9722:
9723: -- =======================================================================*/
9724: PROCEDURE cost_internal_order_exp_txn(
9725: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9726: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9727: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9728: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9729: )
9730: IS

Line 9727: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

9723: -- =======================================================================*/
9724: PROCEDURE cost_internal_order_exp_txn(
9725: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9726: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9727: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9728: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9729: )
9730: IS
9731: l_exp_sub NUMBER;

Line 9728: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

9724: PROCEDURE cost_internal_order_exp_txn(
9725: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9726: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9727: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9728: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9729: )
9730: IS
9731: l_exp_sub NUMBER;
9732: l_exp_flag BOOLEAN;

Line 9735: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

9731: l_exp_sub NUMBER;
9732: l_exp_flag BOOLEAN;
9733: l_dr_flag BOOLEAN;
9734: l_stmt_num NUMBER := 0;
9735: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9736: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9737: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9738: l_txn_cost_group_id NUMBER;
9739: l_txfr_txn_cost_group_id NUMBER;

Line 9736: l_err_rec CSTPALTY.cst_ae_err_rec_type;

9732: l_exp_flag BOOLEAN;
9733: l_dr_flag BOOLEAN;
9734: l_stmt_num NUMBER := 0;
9735: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9736: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9737: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9738: l_txn_cost_group_id NUMBER;
9739: l_txfr_txn_cost_group_id NUMBER;
9740:

Line 9737: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

9733: l_dr_flag BOOLEAN;
9734: l_stmt_num NUMBER := 0;
9735: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9736: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9737: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9738: l_txn_cost_group_id NUMBER;
9739: l_txfr_txn_cost_group_id NUMBER;
9740:
9741: l_mfa_exp_account NUMBER;

Line 10660: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

10656: -- distributions for Logical Expense Destination Receipt trxn.
10657: -- ======================================================================*/
10658:
10659: Procedure get_pacp_priorPrd_mta_cost (
10660: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10661: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10662: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10663: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10664: o_pacp_flag OUT NOCOPY NUMBER,

Line 10661: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

10657: -- ======================================================================*/
10658:
10659: Procedure get_pacp_priorPrd_mta_cost (
10660: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10661: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10662: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10663: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10664: o_pacp_flag OUT NOCOPY NUMBER,
10665: o_pacp_pwac_cost OUT NOCOPY NUMBER,

Line 10662: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

10658:
10659: Procedure get_pacp_priorPrd_mta_cost (
10660: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10661: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10662: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10663: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10664: o_pacp_flag OUT NOCOPY NUMBER,
10665: o_pacp_pwac_cost OUT NOCOPY NUMBER,
10666: o_prev_period_flag OUT NOCOPY NUMBER,

Line 10663: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,

10659: Procedure get_pacp_priorPrd_mta_cost (
10660: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10661: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10662: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10663: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10664: o_pacp_flag OUT NOCOPY NUMBER,
10665: o_pacp_pwac_cost OUT NOCOPY NUMBER,
10666: o_prev_period_flag OUT NOCOPY NUMBER,
10667: o_prev_period_pwac_cost OUT NOCOPY NUMBER,

Line 10683: l_err_rec CSTPALTY.cst_ae_err_rec_type;

10679: l_txfr_cost NUMBER;
10680: l_use_prev_period_cost NUMBER;
10681: l_transfer_cost_flag VARCHAR2(1);
10682:
10683: l_err_rec CSTPALTY.cst_ae_err_rec_type;
10684:
10685: l_api_name CONSTANT VARCHAR2(240) := 'CSTPAPBR.get_pacp_priorPrd_mta_cost';
10686:
10687: BEGIN

Line 10965: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

10961: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10962: p_total_primary_qty IN NUMBER,
10963: x_encumbrance_amount OUT NOCOPY NUMBER,
10964: x_encumbrance_account OUT NOCOPY NUMBER,
10965: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10966: ) IS
10967:
10968: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10969: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

Line 10990: l_err_rec CSTPALTY.cst_ae_err_rec_type;

10986: l_stmt_num NUMBER;
10987: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';
10988: l_api_version NUMBER := 1.0;
10989:
10990: l_err_rec CSTPALTY.cst_ae_err_rec_type;
10991:
10992:
10993: BEGIN
10994: -- Initialize local variables.

Line 11099: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

11095: p_api_version IN NUMBER,
11096: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
11097: x_encumbrance_amount OUT NOCOPY NUMBER,
11098: x_encumbrance_account OUT NOCOPY NUMBER,
11099: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
11100: ) IS
11101:
11102: l_total_primary_qty NUMBER;
11103: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;

Line 11117: l_err_rec CSTPALTY.cst_ae_err_rec_type;

11113:
11114: l_stmt_num NUMBER;
11115: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';
11116: l_api_version NUMBER := 1.0;
11117: l_err_rec CSTPALTY.cst_ae_err_rec_type;
11118: process_error EXCEPTION;
11119:
11120: BEGIN
11121: -- Initialize local variables.