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 950: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();

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

Line 2629: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

2625: END create_rcv_ae_lines;
2626:
2627: -- Retro Changes--------------------------------------------------------------
2628: PROCEDURE create_adj_ae_lines(
2629: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

2626:
2627: -- Retro Changes--------------------------------------------------------------
2628: PROCEDURE create_adj_ae_lines(
2629: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

2627: -- Retro Changes--------------------------------------------------------------
2628: PROCEDURE create_adj_ae_lines(
2629: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

2629: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2636: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2637: l_dr_flag BOOLEAN;

Line 2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

2630: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2636: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2637: l_dr_flag BOOLEAN;
2638:

Line 2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

2631: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2636: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2637: l_dr_flag BOOLEAN;
2638:
2639: -- Retroactive Pricing --

Line 2636: l_err_rec CSTPALTY.cst_ae_err_rec_type;

2632: ) IS
2633: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2634: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2635: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2636: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2637: l_dr_flag BOOLEAN;
2638:
2639: -- Retroactive Pricing --
2640: l_current_transaction_value NUMBER;

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

2659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Adj_Ae_Lines <<<');
2660: END IF;
2661:
2662: -- Initialize the collection
2663: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
2664:
2665: -- Populate the Currency Structure
2666: l_stmt_num := 10;
2667:

Line 2861: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

2857:
2858: /*LCM CHANGES */
2859:
2860: PROCEDURE create_lc_adj_ae_lines(
2861: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

2858: /*LCM CHANGES */
2859:
2860: PROCEDURE create_lc_adj_ae_lines(
2861: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

2859:
2860: PROCEDURE create_lc_adj_ae_lines(
2861: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

2861: p_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2868: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2869: l_dr_flag BOOLEAN;

Line 2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

2862: x_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2868: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2869: l_dr_flag BOOLEAN;
2870:

Line 2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

2863: x_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2868: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2869: l_dr_flag BOOLEAN;
2870:
2871:

Line 2868: l_err_rec CSTPALTY.cst_ae_err_rec_type;

2864: ) IS
2865: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
2866: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
2867: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
2868: l_err_rec CSTPALTY.cst_ae_err_rec_type;
2869: l_dr_flag BOOLEAN;
2870:
2871:
2872: l_current_transaction_value NUMBER;

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

2881: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_LC_Adj_Ae_Lines <<<');
2882: END IF;
2883:
2884: -- Initialize the collection
2885: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
2886:
2887: -- Populate the Currency Structure
2888: l_stmt_num := 10;
2889:

Line 3037: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

3033: | This is called during the period close process |
3034: |============================================================================*/
3035:
3036: PROCEDURE create_per_end_ae_lines(
3037: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

Line 3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3034: |============================================================================*/
3035:
3036: PROCEDURE create_per_end_ae_lines(
3037: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

Line 3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

3035:
3036: PROCEDURE create_per_end_ae_lines(
3037: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

Line 3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;

3037: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3044: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3045:

Line 3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;

3038: o_ae_line_rec_tbl OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3044: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3045:
3046: l_doc_level VARCHAR2(1);

Line 3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;

3039: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3044: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3045:
3046: l_doc_level VARCHAR2(1);
3047: l_doc_id NUMBER;

Line 3044: l_err_rec CSTPALTY.cst_ae_err_rec_type;

3040: ) IS
3041: l_ae_line_tbl CSTPALTY.CST_AE_LINE_TBL_TYPE;
3042: l_ae_line_rec CSTPALTY.CST_AE_LINE_REC_TYPE;
3043: l_curr_rec CSTPALTY.cst_ae_curr_rec_type;
3044: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3045:
3046: l_doc_level VARCHAR2(1);
3047: l_doc_id NUMBER;
3048: l_dist_count NUMBER;

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

3075:
3076: -- Initialize API return status to success
3077: l_return_status := FND_API.G_RET_STS_SUCCESS;
3078:
3079: l_ae_line_tbl := CSTPALTY.cst_ae_line_tbl_type();
3080:
3081: -- Initialize local variables.
3082: -- ---------------------------
3083: l_err_rec.l_err_num := 0;

Line 3422: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type

3418: i_encumbrance_account_id IN NUMBER,
3419: o_enc_flag OUT NOCOPY VARCHAR2,
3420: o_purch_encumbrance_type_id OUT NOCOPY NUMBER,
3421: o_purch_encumbrance_flag OUT NOCOPY VARCHAR2,
3422: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
3423: )
3424: IS
3425: l_application_id NUMBER;
3426: l_functional_currency_code VARCHAR2(5);

Line 3523: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,

3519: -- ===================================================================
3520: -- Insert Account.
3521: -- ===================================================================
3522: PROCEDURE insert_account(
3523: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3525: i_dr_flag IN BOOLEAN,
3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

Line 3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,

3520: -- Insert Account.
3521: -- ===================================================================
3522: PROCEDURE insert_account(
3523: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3525: i_dr_flag IN BOOLEAN,
3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

Line 3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,

3522: PROCEDURE insert_account(
3523: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3525: i_dr_flag IN BOOLEAN,
3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3529: IS
3530: l_err_rec CSTPALTY.cst_ae_err_rec_type;

Line 3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3523: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3525: i_dr_flag IN BOOLEAN,
3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3529: IS
3530: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3531: l_entered_value NUMBER;

Line 3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

3524: i_ae_curr_rec IN CSTPALTY.cst_ae_curr_rec_type,
3525: i_dr_flag IN BOOLEAN,
3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3529: IS
3530: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3531: l_entered_value NUMBER;
3532: l_accounted_value NUMBER;

Line 3530: l_err_rec CSTPALTY.cst_ae_err_rec_type;

3526: i_ae_line_rec IN CSTPALTY.cst_ae_line_rec_type,
3527: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3528: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3529: IS
3530: l_err_rec CSTPALTY.cst_ae_err_rec_type;
3531: l_entered_value NUMBER;
3532: l_accounted_value NUMBER;
3533: l_stmt_num NUMBER;
3534: next_record_avail NUMBER;

Line 3838: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,

3834: -- ===================================================================
3835: -- Balance Account.
3836: -- ===================================================================
3837: procedure balance_account (
3838: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3839: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3840: IS
3841: l_ent_value NUMBER := 0;
3842: l_acc_value NUMBER := 0;

Line 3839: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)

3835: -- Balance Account.
3836: -- ===================================================================
3837: procedure balance_account (
3838: l_ae_line_tbl IN OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
3839: o_ae_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type)
3840: IS
3841: l_ent_value NUMBER := 0;
3842: l_acc_value NUMBER := 0;
3843: l_last_rec NUMBER;