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

APPS.CSTPAPBR dependencies on CSTPALBR

Line 545: CSTPALBR.insert_ae_lines(

541: -----------------------------------------------------------------------------
542:
543: IF (l_ae_err_rec.l_err_num IS NULL OR l_ae_err_rec.l_err_num = 0) THEN
544: IF (l_ae_line_rec_tbl.EXISTS(1)) THEN
545: CSTPALBR.insert_ae_lines(
546: l_ae_txn_rec,
547: l_ae_line_rec_tbl,
548: l_ae_err_rec);
549: END IF;

Line 635: --l_ae_line_tbl := CSTPALBR.cst_ae_line_tbl_type();

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: -- ---------------------------
639: l_err_rec.l_err_num := 0;

Line 1213: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

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
1217: ) IS

Line 1214: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_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
1217: ) IS
1218: l_exp_sub NUMBER;

Line 1215: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_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
1217: ) IS
1218: l_exp_sub NUMBER;
1219: l_exp_acct NUMBER;

Line 1216: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_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
1217: ) IS
1218: l_exp_sub NUMBER;
1219: l_exp_acct NUMBER;
1220: l_exp_job NUMBER;

Line 1227: --l_err_rec CSTPALBR.cst_ae_err_rec_type;

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;
1231: l_elemental NUMBER;

Line 1228: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;

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;
1231: l_elemental NUMBER;
1232: l_dr_flag BOOLEAN;

Line 5989: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

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
5993: ) IS

Line 5990: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_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
5993: ) IS
5994: l_cost NUMBER;

Line 5991: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_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
5993: ) IS
5994: l_cost NUMBER;
5995: l_var NUMBER;

Line 5992: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_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
5993: ) IS
5994: l_cost NUMBER;
5995: l_var NUMBER;
5996: l_var_total NUMBER;

Line 6004: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;

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
6008: l_stmt_num NUMBER;

Line 6005: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;

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
6008: l_stmt_num NUMBER;
6009: l_value_change_flag NUMBER;

Line 6006: --l_err_rec CSTPALBR.cst_ae_err_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
6008: l_stmt_num NUMBER;
6009: l_value_change_flag NUMBER;
6010: l_onhand_var NUMBER;

Line 7731: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

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,
7735: i_ovhd_absp IN NUMBER,

Line 7732: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

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,
7735: i_ovhd_absp IN NUMBER,
7736: i_dr_flag IN BOOLEAN,

Line 7740: --i_ae_acct_rec IN CSTPALBR.cst_ae_acct_rec_type,

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
7744: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;

Line 7741: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

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
7744: l_ae_line_rec CSTPALTY.cst_ae_line_rec_type;
7745: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;

Line 7742: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_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
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;

Line 7745: --l_ae_line_rec CSTPALBR.cst_ae_line_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;
7749: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 7751: --l_err_rec CSTPALBR.cst_ae_err_rec_type;

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;
7755: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.offset_accounts';

Line 7752: --l_acct_rec CSTPALBR.cst_ae_acct_rec_type;

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;
7755: l_api_name CONSTANT VARCHAR2(30) := 'CSTPAPBR.offset_accounts';
7756: BEGIN

Line 8104: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

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,
8108: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

Line 8105: --i_ae_curr_rec IN CSTPALBR.cst_ae_curr_rec_type,

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,
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)

Line 8110: --i_ae_line_rec IN CSTPALBR.cst_ae_line_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
8114: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 8111: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

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
8114: l_err_rec CSTPALTY.cst_ae_err_rec_type;
8115: --l_err_rec CSTPALBR.cst_ae_err_rec_type;

Line 8112: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_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
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;

Line 8115: --l_err_rec CSTPALBR.cst_ae_err_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;
8119: l_stmt_num NUMBER := 0;

Line 8347: --(l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_type,

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;
8351: l_acc_value NUMBER := 0;

Line 8348: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type)

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;
8351: l_acc_value NUMBER := 0;
8352: l_last_rec NUMBER;

Line 8416: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

8412: -- ===================================================================
8413: -- Controls line creation for WIP transactions.
8414: -- ===================================================================
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,

Line 8417: --o_ae_line_rec_tbl OUT CSTPALBR.cst_ae_line_tbl_type,

8413: -- Controls line creation for WIP transactions.
8414: -- ===================================================================
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

Line 8418: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_rec_type

8414: -- ===================================================================
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

Line 8430: --l_ae_line_tbl CSTPALBR.cst_ae_line_tbl_type := CSTPALBR.cst_ae_line_tbl_type();

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;
8434: l_acct_id1 NUMBER;

Line 8431: --l_ae_curr_rec CSTPALBR.cst_ae_curr_rec_type;

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;
8434: l_acct_id1 NUMBER;
8435: l_acct_id2 NUMBER;

Line 8432: --l_ae_line_rec CSTPALBR.cst_ae_line_rec_type;

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;
8434: l_acct_id1 NUMBER;
8435: l_acct_id2 NUMBER;
8436: l_dr_flag BOOLEAN;

Line 8433: --l_ae_err_rec CSTPALBR.cst_ae_err_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;
8434: l_acct_id1 NUMBER;
8435: l_acct_id2 NUMBER;
8436: l_dr_flag BOOLEAN;
8437: l_stmt_num NUMBER;

Line 8919: --i_ae_txn_rec IN CSTPALBR.cst_ae_txn_rec_type,

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,
8923: o_acct_id2 OUT NOCOPY NUMBER,

Line 8920: --i_ae_line_rec IN CSTPALBR.cst_ae_line_rec_type,

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,
8923: o_acct_id2 OUT NOCOPY NUMBER,
8924: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

Line 8921: --l_ae_line_tbl IN OUT CSTPALBR.cst_ae_line_tbl_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,
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

Line 8925: --o_ae_err_rec OUT CSTPALBR.cst_ae_err_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;
8929: l_wip_entity_id NUMBER;

Line 8934: --l_ae_err_rec CSTPALBR.cst_ae_err_rec_type;

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;
8938: no_wfs_acct_error EXCEPTION;