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.CSTPAPPR dependencies on CSTPALTY

Line 112: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;

108: o_err_num OUT NOCOPY NUMBER,
109: o_err_code OUT NOCOPY VARCHAR2,
110: o_err_msg OUT NOCOPY VARCHAR2
111: )IS
112: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
113: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
114: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
115: l_cost_type_name VARCHAR2(10);
116: l_cost_group_name VARCHAR2(10);

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

109: o_err_code OUT NOCOPY VARCHAR2,
110: o_err_msg OUT NOCOPY VARCHAR2
111: )IS
112: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
113: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
114: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
115: l_cost_type_name VARCHAR2(10);
116: l_cost_group_name VARCHAR2(10);
117: l_period_name VARCHAR2(15);

Line 114: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;

110: o_err_msg OUT NOCOPY VARCHAR2
111: )IS
112: l_ae_txn_rec CSTPALTY.CST_AE_TXN_REC_TYPE;
113: l_ae_line_rec_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE := CSTPALTY.CST_AE_LINE_TBL_TYPE();
114: l_ae_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
115: l_cost_type_name VARCHAR2(10);
116: l_cost_group_name VARCHAR2(10);
117: l_period_name VARCHAR2(15);
118: l_period_end_date DATE;

Line 677: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

673: | 20-Jul-03 Anju Creation |
674: |============================================================================*/
675:
676: PROCEDURE create_rae_ae_lines(
677: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

674: |============================================================================*/
675:
676: PROCEDURE create_rae_ae_lines(
677: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

675:
676: PROCEDURE create_rae_ae_lines(
677: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

677: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
684: l_err_rec CSTPALTY.cst_ae_err_rec_type;
685:

Line 682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

678: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
684: l_err_rec CSTPALTY.cst_ae_err_rec_type;
685:
686: l_dr_flag BOOLEAN;

Line 683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

679: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
684: l_err_rec CSTPALTY.cst_ae_err_rec_type;
685:
686: l_dr_flag BOOLEAN;
687: l_hook NUMBER;

Line 684: l_err_rec CSTPALTY.cst_ae_err_rec_type;

680: ) IS
681: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
682: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
683: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
684: l_err_rec CSTPALTY.cst_ae_err_rec_type;
685:
686: l_dr_flag BOOLEAN;
687: l_hook NUMBER;
688: l_stmt_num NUMBER;

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

701: if (l_debug_flag = 'Y') then
702: fnd_file.put_line(fnd_file.log,'Create_Rae_Ae_Lines <<< ');
703: end if;
704:
705: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
706:
707: -- Initialize local variables.
708: -- ---------------------------
709: l_err_rec.l_err_num := 0;

Line 886: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

882: | accruals) |
883: |============================================================================*/
884:
885: PROCEDURE create_rcv_ae_lines(
886: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

883: |============================================================================*/
884:
885: PROCEDURE create_rcv_ae_lines(
886: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

884:
885: PROCEDURE create_rcv_ae_lines(
886: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

886: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
893: l_err_rec CSTPALTY.cst_ae_err_rec_type;
894: l_par_rcv_txn NUMBER;

Line 891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

887: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
893: l_err_rec CSTPALTY.cst_ae_err_rec_type;
894: l_par_rcv_txn NUMBER;
895: l_stage NUMBER;

Line 892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

888: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
893: l_err_rec CSTPALTY.cst_ae_err_rec_type;
894: l_par_rcv_txn NUMBER;
895: l_stage NUMBER;
896: l_par_txn_type VARCHAR2(20);

Line 893: l_err_rec CSTPALTY.cst_ae_err_rec_type;

889: ) IS
890: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
891: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
892: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
893: l_err_rec CSTPALTY.cst_ae_err_rec_type;
894: l_par_rcv_txn NUMBER;
895: l_stage NUMBER;
896: l_par_txn_type VARCHAR2(20);
897: l_par_txn NUMBER;

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

948:
949: IF l_debug_flag = 'Y' THEN
950: fnd_file.put_line(fnd_file.log,'Create_Rcv_Ae_Lines <<< ');
951: END IF;
952: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
953:
954: -- Initialize local variables.
955: -- ---------------------------
956: l_err_rec.l_err_num := 0;

Line 2989: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

2985: END create_rcv_ae_lines;
2986:
2987: -- Retro Changes--------------------------------------------------------------
2988: PROCEDURE create_adj_ae_lines(
2989: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

2986:
2987: -- Retro Changes--------------------------------------------------------------
2988: PROCEDURE create_adj_ae_lines(
2989: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

2987: -- Retro Changes--------------------------------------------------------------
2988: PROCEDURE create_adj_ae_lines(
2989: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

2989: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2996: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2997: l_dr_flag BOOLEAN;

Line 2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

2990: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2996: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2997: l_dr_flag BOOLEAN;
2998:

Line 2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

2991: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2996: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2997: l_dr_flag BOOLEAN;
2998:
2999: -- Retroactive Pricing --

Line 2996: l_err_rec CSTPALTY.cst_ae_err_rec_type;

2992: ) IS
2993: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2994: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2995: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2996: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2997: l_dr_flag BOOLEAN;
2998:
2999: -- Retroactive Pricing --
3000: l_current_transaction_value NUMBER;

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

3019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Adj_Ae_Lines <<<');
3020: END IF;
3021:
3022: -- Initialize the collection
3023: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
3024:
3025: -- Populate the Currency Structure
3026: l_stmt_num := 10;
3027:

Line 3221: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

3217:
3218: /*LCM CHANGES */
3219:
3220: PROCEDURE create_lc_adj_ae_lines(
3221: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3218: /*LCM CHANGES */
3219:
3220: PROCEDURE create_lc_adj_ae_lines(
3221: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

3219:
3220: PROCEDURE create_lc_adj_ae_lines(
3221: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

3221: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3228: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3229: l_dr_flag BOOLEAN;

Line 3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

3222: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3228: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3229: l_dr_flag BOOLEAN;
3230:

Line 3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

3223: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3228: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3229: l_dr_flag BOOLEAN;
3230:
3231:

Line 3228: l_err_rec CSTPALTY.cst_ae_err_rec_type;

3224: ) IS
3225: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3226: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3227: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3228: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3229: l_dr_flag BOOLEAN;
3230:
3231:
3232: l_current_transaction_value NUMBER;

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

3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_LC_Adj_Ae_Lines <<<');
3242: END IF;
3243:
3244: -- Initialize the collection
3245: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
3246:
3247: -- Populate the Currency Structure
3248: l_stmt_num := 10;
3249:

Line 3397: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

3393: | This is called during the period close process |
3394: |============================================================================*/
3395:
3396: PROCEDURE create_per_end_ae_lines(
3397: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3394: |============================================================================*/
3395:
3396: PROCEDURE create_per_end_ae_lines(
3397: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

3395:
3396: PROCEDURE create_per_end_ae_lines(
3397: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

3397: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3404: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3405:

Line 3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

3398: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3404: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3405:
3406: l_doc_level VARCHAR2(1);

Line 3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

3399: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3404: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3405:
3406: l_doc_level VARCHAR2(1);
3407: l_doc_id NUMBER;

Line 3404: l_err_rec CSTPALTY.cst_ae_err_rec_type;

3400: ) IS
3401: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3402: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3403: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3404: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3405:
3406: l_doc_level VARCHAR2(1);
3407: l_doc_id NUMBER;
3408: l_dist_count NUMBER;

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

3435:
3436: -- Initialize API return status to success
3437: l_return_status := FND_API.G_RET_STS_SUCCESS;
3438:
3439: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
3440:
3441: -- Initialize local variables.
3442: -- ---------------------------
3443: l_err_rec.l_err_num := 0;

Line 3790: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

3786: i_encumbrance_account_id IN NUMBER,
3787: o_enc_flag OUT NOCOPY VARCHAR2,
3788: o_purch_encumbrance_type_id OUT NOCOPY NUMBER,
3789: o_purch_encumbrance_flag OUT NOCOPY VARCHAR2,
3790: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3791: )
3792: IS
3793: l_application_id NUMBER;
3794: l_functional_currency_code VARCHAR2(5);

Line 3893: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

3889: -- ===================================================================
3890: -- Insert Account.
3891: -- ===================================================================
3892: PROCEDURE insert_account(
3893: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3895: i_dr_flag IN BOOLEAN,
3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

Line 3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

3890: -- Insert Account.
3891: -- ===================================================================
3892: PROCEDURE insert_account(
3893: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3895: i_dr_flag IN BOOLEAN,
3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

Line 3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

3892: PROCEDURE insert_account(
3893: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3895: i_dr_flag IN BOOLEAN,
3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3899: IS
3900: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3893: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3895: i_dr_flag IN BOOLEAN,
3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3899: IS
3900: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3901: l_entered_value NUMBER;

Line 3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

3894: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3895: i_dr_flag IN BOOLEAN,
3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3899: IS
3900: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3901: l_entered_value NUMBER;
3902: l_accounted_value NUMBER;

Line 3900: l_err_rec CSTPALTY.cst_ae_err_rec_type;

3896: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3897: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3898: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3899: IS
3900: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3901: l_entered_value NUMBER;
3902: l_accounted_value NUMBER;
3903: l_stmt_num NUMBER;
3904: next_record_avail NUMBER;

Line 4220: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

4216: -- ===================================================================
4217: -- Balance Account.
4218: -- ===================================================================
4219: procedure balance_account (
4220: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
4221: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
4222: IS
4223: l_ent_value NUMBER := 0;
4224: l_acc_value NUMBER := 0;

Line 4221: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

4217: -- Balance Account.
4218: -- ===================================================================
4219: procedure balance_account (
4220: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
4221: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
4222: IS
4223: l_ent_value NUMBER := 0;
4224: l_acc_value NUMBER := 0;
4225: l_last_rec NUMBER;