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 573: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

569: | lines in the form of PL/SQL table and returns to the main procedure. |
570: |============================================================================*/
571:
572: PROCEDURE create_inv_ae_lines(
573: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

Line 574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

570: |============================================================================*/
571:
572: PROCEDURE create_inv_ae_lines(
573: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

571:
572: PROCEDURE create_inv_ae_lines(
573: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
579: l_err_rec CSTPALTY.cst_ae_err_rec_type;

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

573: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
579: l_err_rec CSTPALTY.cst_ae_err_rec_type;
580: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
581:

Line 578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

574: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
579: l_err_rec CSTPALTY.cst_ae_err_rec_type;
580: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
581:
582: /* Drop Ship/Global Proc changes */

Line 579: l_err_rec CSTPALTY.cst_ae_err_rec_type;

575: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
579: l_err_rec CSTPALTY.cst_ae_err_rec_type;
580: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
581:
582: /* Drop Ship/Global Proc changes */
583: l_logical_transaction NUMBER;

Line 580: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;

576: ) IS
577: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
578: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
579: l_err_rec CSTPALTY.cst_ae_err_rec_type;
580: l_ae_txn_rec1 CSTPALTY.CST_AE_TXN_REC_TYPE;
581:
582: /* Drop Ship/Global Proc changes */
583: l_logical_transaction NUMBER;
584:

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

605: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
606: || ' transaction_id: ' || i_ae_txn_rec.transaction_id);
607: END IF;
608:
609: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
610: --l_ae_line_tbl := CSTPALBR.cst_ae_line_tbl_type();
611:
612: -- Initialize local variables.
613: -- ---------------------------

Line 991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

987: -- ===================================================================
988: -- WIP transactions.
989: -- ===================================================================
990: procedure wip_cost_txn(
991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
993: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
994: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
995: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

Line 992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

988: -- WIP transactions.
989: -- ===================================================================
990: procedure wip_cost_txn(
991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
993: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
994: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
995: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
996: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

Line 993: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

989: -- ===================================================================
990: procedure wip_cost_txn(
991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
993: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
994: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
995: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
996: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
997: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 994: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

990: procedure wip_cost_txn(
991: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
992: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
993: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
994: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
995: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
996: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
997: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
998: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 1007: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1003: l_ovhd_absp NUMBER;
1004: l_mat_ovhd_exists NUMBER;
1005: l_rep_sched_id NUMBER;
1006: l_cost NUMBER;
1007: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1008: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1009: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
1010: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
1011: l_acct_class VARCHAR2(10);

Line 1008: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1004: l_mat_ovhd_exists NUMBER;
1005: l_rep_sched_id NUMBER;
1006: l_cost NUMBER;
1007: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1008: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1009: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
1010: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
1011: l_acct_class VARCHAR2(10);
1012: l_acct_line_type NUMBER;

Line 1357: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

1353: -- ===================================================================
1354: -- Subinventory transfer transactions.
1355: -- ===================================================================
1356: procedure sub_cost_txn(
1357: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1358: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1359: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1360: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1361: ) IS

Line 1358: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

1354: -- Subinventory transfer transactions.
1355: -- ===================================================================
1356: procedure sub_cost_txn(
1357: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1358: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1359: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1360: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1361: ) IS
1362: l_subinv VARCHAR2(10);

Line 1359: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

1355: -- ===================================================================
1356: procedure sub_cost_txn(
1357: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1358: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1359: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1360: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1361: ) IS
1362: l_subinv VARCHAR2(10);
1363: l_exp_sub1 NUMBER;

Line 1360: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

1356: procedure sub_cost_txn(
1357: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1358: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1359: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1360: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1361: ) IS
1362: l_subinv VARCHAR2(10);
1363: l_exp_sub1 NUMBER;
1364: l_exp_acct1 NUMBER;

Line 1373: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1369: l_stmt_num NUMBER;
1370: process_error EXCEPTION;
1371: l_dr_flag BOOLEAN;
1372: l_exp_flag BOOLEAN;
1373: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1374: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1375: BEGIN
1376:
1377: IF g_debug_flag = 'Y' THEN

Line 1374: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1370: process_error EXCEPTION;
1371: l_dr_flag BOOLEAN;
1372: l_exp_flag BOOLEAN;
1373: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1374: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1375: BEGIN
1376:
1377: IF g_debug_flag = 'Y' THEN
1378: fnd_file.put_line(fnd_file.log,'Sub_cost_txn <<');

Line 1611: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

1607: ===================================================================
1608: =================================================================== */
1609:
1610: procedure interorg_cost_txn(
1611: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1612: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1613: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1614: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1615: ) IS

Line 1612: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

1608: =================================================================== */
1609:
1610: procedure interorg_cost_txn(
1611: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1612: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1613: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1614: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1615: ) IS
1616: l_exp_sub1 NUMBER;

Line 1613: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

1609:
1610: procedure interorg_cost_txn(
1611: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1612: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1613: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1614: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1615: ) IS
1616: l_exp_sub1 NUMBER;
1617: l_exp_sub2 NUMBER;

Line 1614: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

1610: procedure interorg_cost_txn(
1611: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
1612: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
1613: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
1614: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
1615: ) IS
1616: l_exp_sub1 NUMBER;
1617: l_exp_sub2 NUMBER;
1618: l_exp_sub NUMBER;

Line 1622: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

1618: l_exp_sub NUMBER;
1619: l_dr_flag BOOLEAN;
1620: l_acct_exist NUMBER;
1621: l_stmt_num NUMBER := 0;
1622: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1623: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1624: l_txn_cost_group_id NUMBER;
1625: l_txfr_txn_cost_group_id NUMBER;
1626:

Line 1623: l_err_rec CSTPALTY.cst_ae_err_rec_type;

1619: l_dr_flag BOOLEAN;
1620: l_acct_exist NUMBER;
1621: l_stmt_num NUMBER := 0;
1622: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
1623: l_err_rec CSTPALTY.cst_ae_err_rec_type;
1624: l_txn_cost_group_id NUMBER;
1625: l_txfr_txn_cost_group_id NUMBER;
1626:
1627: process_error EXCEPTION;

Line 1676: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

1672: l_mat_ovhd_cost NUMBER;
1673: l_ovhd_absp NUMBER;
1674: l_mptcd_cost NUMBER;
1675:
1676: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
1677:
1678: -- INVCONV sikhanna, Variables added for OPM Convergence project
1679: l_pwac_cost NUMBER;
1680: l_profit_or_loss NUMBER;

Line 5703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

5699: -- ===================================================================
5700: -- Cost Update Transactions.
5701: -- ===================================================================
5702: procedure pcu_cost_txn(
5703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5705: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5706: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5707: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

Line 5704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

5700: -- Cost Update Transactions.
5701: -- ===================================================================
5702: procedure pcu_cost_txn(
5703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5705: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5706: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5707: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5708: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

Line 5705: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

5701: -- ===================================================================
5702: procedure pcu_cost_txn(
5703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5705: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5706: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5707: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5708: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
5709: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 5706: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

5702: procedure pcu_cost_txn(
5703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
5704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
5705: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
5706: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
5707: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
5708: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
5709: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
5710: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 5719: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

5715: l_acct_exist NUMBER;
5716: l_ele_exist NUMBER;
5717: l_dr_flag BOOLEAN;
5718: l_loop_count NUMBER := 0;
5719: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
5720: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
5721: l_err_rec CSTPALTY.cst_ae_err_rec_type;
5722: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
5723: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;

Line 5720: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

5716: l_ele_exist NUMBER;
5717: l_dr_flag BOOLEAN;
5718: l_loop_count NUMBER := 0;
5719: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
5720: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
5721: l_err_rec CSTPALTY.cst_ae_err_rec_type;
5722: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
5723: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
5724: --l_err_rec CSTPALBR.cst_ae_err_rec_type;

Line 5721: l_err_rec CSTPALTY.cst_ae_err_rec_type;

5717: l_dr_flag BOOLEAN;
5718: l_loop_count NUMBER := 0;
5719: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
5720: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
5721: l_err_rec CSTPALTY.cst_ae_err_rec_type;
5722: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
5723: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
5724: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
5725: l_txn_ce_bal_account NUMBER; -- Bug 4586534

Line 6188: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6184: -- ===================================================================
6185: -- Rest of inventory transactions.
6186: -- ===================================================================
6187: procedure inv_cost_txn(
6188: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6189: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6190: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6191: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6192: ) IS

Line 6189: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6185: -- Rest of inventory transactions.
6186: -- ===================================================================
6187: procedure inv_cost_txn(
6188: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6189: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6190: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6191: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6192: ) IS
6193: l_exp_sub NUMBER;

Line 6190: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6186: -- ===================================================================
6187: procedure inv_cost_txn(
6188: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6189: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6190: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6191: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6192: ) IS
6193: l_exp_sub NUMBER;
6194: l_dropship_type_code NUMBER;

Line 6191: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6187: procedure inv_cost_txn(
6188: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6189: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6190: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6191: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6192: ) IS
6193: l_exp_sub NUMBER;
6194: l_dropship_type_code NUMBER;
6195: l_elemental NUMBER;

Line 6203: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6199: l_stmt_num NUMBER;
6200: l_dr_flag BOOLEAN;
6201: l_exp_flag BOOLEAN;
6202: process_error EXCEPTION;
6203: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6204: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6205:
6206: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6207: BEGIN

Line 6204: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

6200: l_dr_flag BOOLEAN;
6201: l_exp_flag BOOLEAN;
6202: process_error EXCEPTION;
6203: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6204: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6205:
6206: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6207: BEGIN
6208:

Line 6556: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6552: --
6553: -- 20-Jul-03 Anju Creation
6554: -- ===================================================================
6555: procedure cost_logical_txn(
6556: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6557: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6558: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6559: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6560: ) IS

Line 6557: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6553: -- 20-Jul-03 Anju Creation
6554: -- ===================================================================
6555: procedure cost_logical_txn(
6556: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6557: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6558: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6559: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6560: ) IS
6561: l_exp_sub NUMBER;

Line 6558: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6554: -- ===================================================================
6555: procedure cost_logical_txn(
6556: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6557: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6558: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6559: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6560: ) IS
6561: l_exp_sub NUMBER;
6562: l_exp_acct NUMBER;

Line 6559: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6555: procedure cost_logical_txn(
6556: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6557: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6558: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6559: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6560: ) IS
6561: l_exp_sub NUMBER;
6562: l_exp_acct NUMBER;
6563: l_elemental NUMBER;

Line 6570: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6566: l_stmt_num NUMBER;
6567: l_dr_flag BOOLEAN;
6568: l_exp_flag BOOLEAN;
6569: process_error EXCEPTION;
6570: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6571: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6572:
6573: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6574:

Line 6571: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

6567: l_dr_flag BOOLEAN;
6568: l_exp_flag BOOLEAN;
6569: process_error EXCEPTION;
6570: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6571: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6572:
6573: l_ref_om_line_id NUMBER; -- Revenue / COGS Matching
6574:
6575: BEGIN

Line 6823: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6819: --
6820: -- 20-Jul-03 Anju Creation
6821: -- ===================================================================
6822: procedure cost_consigned_update_txn(
6823: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6824: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6825: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6826: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6827: ) IS

Line 6824: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6820: -- 20-Jul-03 Anju Creation
6821: -- ===================================================================
6822: procedure cost_consigned_update_txn(
6823: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6824: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6825: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6826: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6827: ) IS
6828: l_exp_sub NUMBER;

Line 6825: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6821: -- ===================================================================
6822: procedure cost_consigned_update_txn(
6823: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6824: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6825: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6826: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6827: ) IS
6828: l_exp_sub NUMBER;
6829: l_qty NUMBER;

Line 6826: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6822: procedure cost_consigned_update_txn(
6823: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6824: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6825: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6826: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6827: ) IS
6828: l_exp_sub NUMBER;
6829: l_qty NUMBER;
6830: l_exp_acct NUMBER;

Line 6840: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6836: l_ele_exist NUMBER;
6837: l_cost NUMBER;
6838: process_error EXCEPTION;
6839: no_txn_det_error EXCEPTION;
6840: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6841: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6842: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6843:
6844: BEGIN

Line 6841: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

6837: l_cost NUMBER;
6838: process_error EXCEPTION;
6839: no_txn_det_error EXCEPTION;
6840: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6841: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6842: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6843:
6844: BEGIN
6845:

Line 6842: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

6838: process_error EXCEPTION;
6839: no_txn_det_error EXCEPTION;
6840: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6841: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
6842: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6843:
6844: BEGIN
6845:
6846: IF g_debug_flag = 'Y' THEN

Line 6986: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

6982:
6983:
6984:
6985: procedure encumbrance_account(
6986: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6987: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6988: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6990: ) IS

Line 6987: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

6983:
6984:
6985: procedure encumbrance_account(
6986: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6987: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6988: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6990: ) IS
6991: l_acct NUMBER;

Line 6988: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

6984:
6985: procedure encumbrance_account(
6986: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6987: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6988: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6990: ) IS
6991: l_acct NUMBER;
6992: l_acct_line_type NUMBER;

Line 6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

6985: procedure encumbrance_account(
6986: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
6987: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
6988: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6990: ) IS
6991: l_acct NUMBER;
6992: l_acct_line_type NUMBER;
6993: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 6993: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

6989: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
6990: ) IS
6991: l_acct NUMBER;
6992: l_acct_line_type NUMBER;
6993: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6994: l_stmt_num NUMBER;
6995: l_dr_flag BOOLEAN;
6996: process_error exception;
6997: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 6997: l_err_rec CSTPALTY.cst_ae_err_rec_type;

6993: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
6994: l_stmt_num NUMBER;
6995: l_dr_flag BOOLEAN;
6996: process_error exception;
6997: l_err_rec CSTPALTY.cst_ae_err_rec_type;
6998: BEGIN
6999: IF g_debug_flag = 'Y' THEN
7000: fnd_file.put_line(fnd_file.log,'Encumbrance_account <<');
7001: END IF;

Line 7065: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7061: -- Legal Entity-CG-CT and Item Category. Ignore the account passed
7062: -- since this used to be from Subinventory
7063:
7064: procedure inventory_accounts(
7065: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7066: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7067: i_exp_flag IN BOOLEAN,
7068: i_exp_account IN NUMBER,
7069: i_dr_flag IN BOOLEAN,

Line 7066: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7062: -- since this used to be from Subinventory
7063:
7064: procedure inventory_accounts(
7065: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7066: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7067: i_exp_flag IN BOOLEAN,
7068: i_exp_account IN NUMBER,
7069: i_dr_flag IN BOOLEAN,
7070: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

Line 7070: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7066: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7067: i_exp_flag IN BOOLEAN,
7068: i_exp_account IN NUMBER,
7069: i_dr_flag IN BOOLEAN,
7070: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7071: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7072: i_intransit_flag IN NUMBER
7073: ) IS
7074: l_cost NUMBER;

Line 7071: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,

7067: i_exp_flag IN BOOLEAN,
7068: i_exp_account IN NUMBER,
7069: i_dr_flag IN BOOLEAN,
7070: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7071: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7072: i_intransit_flag IN NUMBER
7073: ) IS
7074: l_cost NUMBER;
7075: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 7075: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7071: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
7072: i_intransit_flag IN NUMBER
7073: ) IS
7074: l_cost NUMBER;
7075: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7076: l_ele_exist NUMBER;
7077: l_acct_exist NUMBER;
7078: l_stmt_num NUMBER := 0;
7079: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.inventory_accounts';

Line 7083: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7079: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.inventory_accounts';
7080:
7081: l_expense_account NUMBER;
7082:
7083: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7084: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7085:
7086: /* Bug 3123936: Propogation of 2896193 */
7087: l_dr_flag BOOLEAN;

Line 7084: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

7080:
7081: l_expense_account NUMBER;
7082:
7083: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7084: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7085:
7086: /* Bug 3123936: Propogation of 2896193 */
7087: l_dr_flag BOOLEAN;
7088: l_var NUMBER;

Line 7346: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7342: -- ===================================================================
7343: -- Offset Accounts.
7344: -- ===================================================================
7345: procedure offset_accounts(
7346: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7347: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7348: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7349: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7350: i_acct_line_type IN NUMBER,

Line 7347: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7343: -- Offset Accounts.
7344: -- ===================================================================
7345: procedure offset_accounts(
7346: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7347: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7348: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7349: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7350: i_acct_line_type IN NUMBER,
7351: i_elemental IN NUMBER,

Line 7354: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

7350: i_acct_line_type IN NUMBER,
7351: i_elemental IN NUMBER,
7352: i_ovhd_absp IN NUMBER,
7353: i_dr_flag IN BOOLEAN,
7354: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7355: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7356: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7357: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7358: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 7355: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7351: i_elemental IN NUMBER,
7352: i_ovhd_absp IN NUMBER,
7353: i_dr_flag IN BOOLEAN,
7354: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7355: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7356: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7357: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7358: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7359: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

Line 7356: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7352: i_ovhd_absp IN NUMBER,
7353: i_dr_flag IN BOOLEAN,
7354: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
7355: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7356: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7357: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7358: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7359: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
7360: )IS

Line 7361: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7357: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,
7358: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7359: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
7360: )IS
7361: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7362: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
7363: l_ele_exist NUMBER;
7364: l_cost NUMBER;
7365: l_stmt_num NUMBER := 0;

Line 7366: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7362: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
7363: l_ele_exist NUMBER;
7364: l_cost NUMBER;
7365: l_stmt_num NUMBER := 0;
7366: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7367: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7368: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
7369: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
7370: process_error EXCEPTION;

Line 7367: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

7363: l_ele_exist NUMBER;
7364: l_cost NUMBER;
7365: l_stmt_num NUMBER := 0;
7366: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7367: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
7368: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
7369: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;
7370: process_error EXCEPTION;
7371: no_txn_det_error EXCEPTION;

Line 7579: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7575: -- ===================================================================
7576: -- Overhead.
7577: -- ===================================================================
7578: procedure ovhd_accounts(
7579: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7580: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7581: i_dr_flag IN BOOLEAN,
7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

Line 7580: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7576: -- Overhead.
7577: -- ===================================================================
7578: procedure ovhd_accounts(
7579: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7580: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7581: i_dr_flag IN BOOLEAN,
7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7584: )IS

Line 7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7578: procedure ovhd_accounts(
7579: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7580: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7581: i_dr_flag IN BOOLEAN,
7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7584: )IS
7585: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7586: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

7579: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7580: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7581: i_dr_flag IN BOOLEAN,
7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7584: )IS
7585: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7586: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7587: l_res_id NUMBER;

Line 7585: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

7581: i_dr_flag IN BOOLEAN,
7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7584: )IS
7585: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7586: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7587: l_res_id NUMBER;
7588: l_cost NUMBER;
7589: l_stmt_num NUMBER;

Line 7586: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7582: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7583: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
7584: )IS
7585: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7586: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7587: l_res_id NUMBER;
7588: l_cost NUMBER;
7589: l_stmt_num NUMBER;
7590: l_txn_cost_group_id NUMBER;

Line 7719: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

7715: -- ===================================================================
7716: -- Insert Account.
7717: -- ===================================================================
7718: PROCEDURE insert_account(
7719: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7720: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7721: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7722: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7723: i_dr_flag IN BOOLEAN,

Line 7720: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

7716: -- Insert Account.
7717: -- ===================================================================
7718: PROCEDURE insert_account(
7719: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
7720: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7721: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7722: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7723: i_dr_flag IN BOOLEAN,
7724: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

Line 7724: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

7720: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
7721: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7722: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7723: i_dr_flag IN BOOLEAN,
7724: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
7725: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7726: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
7727: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
7728: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 7725: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7721: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
7722: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7723: i_dr_flag IN BOOLEAN,
7724: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
7725: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7726: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
7727: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
7728: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7729: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)

Line 7726: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

7722: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,
7723: i_dr_flag IN BOOLEAN,
7724: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
7725: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7726: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
7727: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
7728: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7729: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
7730: IS

Line 7731: l_err_rec CSTPALTY.cst_ae_err_rec_type;

7727: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
7728: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7729: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
7730: IS
7731: l_err_rec CSTPALTY.cst_ae_err_rec_type;
7732: --l_err_rec CSTPALBR.cst_ae_err_rec_type;
7733: l_entered_value NUMBER;
7734: l_accounted_value NUMBER;
7735: l_exp_sub1 NUMBER;

Line 7962: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

7958: -- ===================================================================
7959: -- Balance Account.
7960: -- ===================================================================
7961: procedure balance_account (
7962: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7963: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
7964: --(l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7965: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
7966: IS

Line 7963: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

7959: -- Balance Account.
7960: -- ===================================================================
7961: procedure balance_account (
7962: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
7963: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
7964: --(l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
7965: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)
7966: IS
7967: l_ent_value NUMBER := 0;

Line 8036: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8032: procedure create_wip_ae_lines(
8033: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8034: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8035: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8036: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();

Line 8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8033: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8034: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8035: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8036: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

8034: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,
8035: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8036: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

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

8036: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8043: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8044: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();

Line 8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;

8037: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8043: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8044: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();
8045: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;

Line 8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

8038: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8043: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8044: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();
8045: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;
8046: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;

Line 8043: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;

8039: ) IS
8040: l_ae_line_tbl CSTPALTY.cst_ae_line_tbl_type := CSTPALTY.cst_ae_line_tbl_type();
8041: l_ae_curr_rec CSTPALTY.cst_ae_curr_rec_type;
8042: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8043: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8044: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();
8045: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;
8046: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;
8047: --l_ae_err_rec CSTPALBR.cst_ae_err_rec_type;

Line 8475: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8471: -- ===================================================================
8472: -- Get Account from the entities (Used in WIP transactions).
8473: -- ===================================================================
8474: procedure get_accts(
8475: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8476: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8477: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8478: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8479: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,

Line 8476: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

8472: -- Get Account from the entities (Used in WIP transactions).
8473: -- ===================================================================
8474: procedure get_accts(
8475: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8476: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8477: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8478: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8479: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8480: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

Line 8477: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8473: -- ===================================================================
8474: procedure get_accts(
8475: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8476: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
8477: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8478: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,
8479: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8480: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8481: o_acct_id1 OUT NOCOPY NUMBER,

Line 8483: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

8479: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,
8480: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,
8481: o_acct_id1 OUT NOCOPY NUMBER,
8482: o_acct_id2 OUT NOCOPY NUMBER,
8483: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8484: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type
8485: ) IS
8486: l_stmt_num NUMBER;
8487: l_entity_type NUMBER;

Line 8492: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;

8488: l_wip_entity_id NUMBER;
8489: l_line_id NUMBER;
8490: l_res_id NUMBER;
8491: l_acct_exist NUMBER;
8492: l_ae_err_rec CSTPALTY.cst_ae_err_rec_type;
8493: --l_ae_err_rec CSTPALBR.cst_ae_err_rec_type;
8494: no_dj_acct_error EXCEPTION;
8495: no_abs_acct_error EXCEPTION;
8496: no_wrs_acct_error EXCEPTION;

Line 8703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8699: -- ===================================================================
8700: -- WIP Accounts.
8701: -- ===================================================================
8702: procedure WIP_accounts(
8703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8705: i_acct_line_type IN NUMBER,
8706: i_ovhd_absp IN NUMBER,
8707: i_dr_flag IN BOOLEAN,

Line 8704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

8700: -- WIP Accounts.
8701: -- ===================================================================
8702: procedure WIP_accounts(
8703: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8705: i_acct_line_type IN NUMBER,
8706: i_ovhd_absp IN NUMBER,
8707: i_dr_flag IN BOOLEAN,
8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

Line 8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,

8704: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
8705: i_acct_line_type IN NUMBER,
8706: i_ovhd_absp IN NUMBER,
8707: i_dr_flag IN BOOLEAN,
8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
8709: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8710: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8711: )IS
8712: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 8709: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

8705: i_acct_line_type IN NUMBER,
8706: i_ovhd_absp IN NUMBER,
8707: i_dr_flag IN BOOLEAN,
8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
8709: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8710: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8711: )IS
8712: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8713: l_ele_exist NUMBER;

Line 8710: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

8706: i_ovhd_absp IN NUMBER,
8707: i_dr_flag IN BOOLEAN,
8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
8709: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8710: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8711: )IS
8712: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8713: l_ele_exist NUMBER;
8714: l_cost NUMBER;

Line 8712: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

8708: i_ae_acct_rec IN CSTPALTY.cst_ae_acct_rec_type,
8709: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
8710: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
8711: )IS
8712: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
8713: l_ele_exist NUMBER;
8714: l_cost NUMBER;
8715: l_dr_flag BOOLEAN;
8716: l_wip_variance NUMBER;

Line 8718: l_err_rec CSTPALTY.cst_ae_err_rec_type;

8714: l_cost NUMBER;
8715: l_dr_flag BOOLEAN;
8716: l_wip_variance NUMBER;
8717: l_stmt_num NUMBER;
8718: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8719: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
8720: process_error EXCEPTION;
8721: no_txn_det_error EXCEPTION;
8722: BEGIN

Line 8719: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

8715: l_dr_flag BOOLEAN;
8716: l_wip_variance NUMBER;
8717: l_stmt_num NUMBER;
8718: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8719: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
8720: process_error EXCEPTION;
8721: no_txn_det_error EXCEPTION;
8722: BEGIN
8723: IF g_debug_flag = 'Y' THEN

Line 8958: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

8954: -- This Procedure uses the same logic as in CST_TPRICE_PVT.Adjust_acct
8955: -- to get the intercompany accrual account id
8956: -- ========================================================================
8957: Function Get_Intercompany_account(
8958: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8959: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
8960: IS
8961: l_snd_sob_id NUMBER;
8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;

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

8955: -- to get the intercompany accrual account id
8956: -- ========================================================================
8957: Function Get_Intercompany_account(
8958: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
8959: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type) RETURN NUMBER
8960: IS
8961: l_snd_sob_id NUMBER;
8962: l_snd_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8963: l_rcv_sob_id NUMBER;

Line 8969: l_err_rec CSTPALTY.cst_ae_err_rec_type;

8965: l_rcv_curr GL_SETS_OF_BOOKS.CURRENCY_CODE%TYPE;
8966: l_curr_type MTL_MATERIAL_TRANSACTIONS.CURRENCY_CONVERSION_TYPE%TYPE;
8967: l_conv_rate NUMBER;
8968: l_conv_date DATE;
8969: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8970: l_from_org NUMBER;
8971: l_to_org NUMBER;
8972: l_from_ou NUMBER;
8973: l_to_ou NUMBER;

Line 9284: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

9280: -- Cr. Payables @ Transfer price
9281:
9282: -- =======================================================================*/
9283: PROCEDURE cost_internal_order_exp_txn(
9284: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9285: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9286: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9287: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9288: )

Line 9285: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

9281:
9282: -- =======================================================================*/
9283: PROCEDURE cost_internal_order_exp_txn(
9284: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9285: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9286: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9287: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9288: )
9289: IS

Line 9286: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

9282: -- =======================================================================*/
9283: PROCEDURE cost_internal_order_exp_txn(
9284: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9285: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9286: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9287: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9288: )
9289: IS
9290: l_exp_sub NUMBER;

Line 9287: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

9283: PROCEDURE cost_internal_order_exp_txn(
9284: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
9285: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
9286: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
9287: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
9288: )
9289: IS
9290: l_exp_sub NUMBER;
9291: l_exp_flag BOOLEAN;

Line 9294: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;

9290: l_exp_sub NUMBER;
9291: l_exp_flag BOOLEAN;
9292: l_dr_flag BOOLEAN;
9293: l_stmt_num NUMBER := 0;
9294: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9295: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9296: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9297: l_txn_cost_group_id NUMBER;
9298: l_txfr_txn_cost_group_id NUMBER;

Line 9295: l_err_rec CSTPALTY.cst_ae_err_rec_type;

9291: l_exp_flag BOOLEAN;
9292: l_dr_flag BOOLEAN;
9293: l_stmt_num NUMBER := 0;
9294: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9295: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9296: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9297: l_txn_cost_group_id NUMBER;
9298: l_txfr_txn_cost_group_id NUMBER;
9299:

Line 9296: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

9292: l_dr_flag BOOLEAN;
9293: l_stmt_num NUMBER := 0;
9294: l_acct_rec CSTPALTY.cst_ae_acct_rec_type;
9295: l_err_rec CSTPALTY.cst_ae_err_rec_type;
9296: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
9297: l_txn_cost_group_id NUMBER;
9298: l_txfr_txn_cost_group_id NUMBER;
9299:
9300: l_mfa_exp_account NUMBER;

Line 10185: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

10181: -- distributions for Logical Expense Destination Receipt trxn.
10182: -- ======================================================================*/
10183:
10184: Procedure get_pacp_priorPrd_mta_cost (
10185: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10186: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10187: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10188: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10189: o_pacp_flag OUT NOCOPY NUMBER,

Line 10186: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

10182: -- ======================================================================*/
10183:
10184: Procedure get_pacp_priorPrd_mta_cost (
10185: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10186: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10187: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10188: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10189: o_pacp_flag OUT NOCOPY NUMBER,
10190: o_pacp_pwac_cost OUT NOCOPY NUMBER,

Line 10187: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

10183:
10184: Procedure get_pacp_priorPrd_mta_cost (
10185: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10186: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10187: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10188: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10189: o_pacp_flag OUT NOCOPY NUMBER,
10190: o_pacp_pwac_cost OUT NOCOPY NUMBER,
10191: o_prev_period_flag OUT NOCOPY NUMBER,

Line 10188: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,

10184: Procedure get_pacp_priorPrd_mta_cost (
10185: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
10186: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
10187: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
10188: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type,
10189: o_pacp_flag OUT NOCOPY NUMBER,
10190: o_pacp_pwac_cost OUT NOCOPY NUMBER,
10191: o_prev_period_flag OUT NOCOPY NUMBER,
10192: o_prev_period_pwac_cost OUT NOCOPY NUMBER,

Line 10208: l_err_rec CSTPALTY.cst_ae_err_rec_type;

10204: l_txfr_cost NUMBER;
10205: l_use_prev_period_cost NUMBER;
10206: l_transfer_cost_flag VARCHAR2(1);
10207:
10208: l_err_rec CSTPALTY.cst_ae_err_rec_type;
10209:
10210: l_api_name CONSTANT VARCHAR2(240) := 'CSTPAPBR.get_pacp_priorPrd_mta_cost';
10211:
10212: BEGIN

Line 10481: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

10477: p_primary_qty IN MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE,
10478: p_total_primary_qty IN NUMBER,
10479: x_encumbrance_amount OUT NOCOPY NUMBER,
10480: x_encumbrance_account OUT NOCOPY NUMBER,
10481: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10482: ) IS
10483:
10484: l_doc_line_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
10485: l_doc_unit_price PO_REQUISITION_LINES_ALL.UNIT_PRICE%TYPE;

Line 10506: l_err_rec CSTPALTY.cst_ae_err_rec_type;

10502: l_stmt_num NUMBER;
10503: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';
10504: l_api_version NUMBER := 1.0;
10505:
10506: l_err_rec CSTPALTY.cst_ae_err_rec_type;
10507:
10508:
10509: BEGIN
10510: -- Initialize local variables.

Line 10615: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

10611: p_api_version IN NUMBER,
10612: p_transaction_id IN MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID%TYPE,
10613: x_encumbrance_amount OUT NOCOPY NUMBER,
10614: x_encumbrance_account OUT NOCOPY NUMBER,
10615: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
10616: ) IS
10617:
10618: l_total_primary_qty NUMBER;
10619: l_primary_qty MTL_MATERIAL_TRANSACTIONS.PRIMARY_QUANTITY%TYPE;

Line 10633: l_err_rec CSTPALTY.cst_ae_err_rec_type;

10629:
10630: l_stmt_num NUMBER;
10631: l_api_name VARCHAR2(100) := 'CompEncumbrance_IntOrdersExp';
10632: l_api_version NUMBER := 1.0;
10633: l_err_rec CSTPALTY.cst_ae_err_rec_type;
10634: process_error EXCEPTION;
10635:
10636: BEGIN
10637: -- Initialize local variables.