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.FV_YE_CLOSE dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;

2813: vl_dist_select VARCHAR2(2000);
2814:
2815: vl_rec_found_flag VARCHAR2(1) ;
2816: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2821: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

Line 2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;

2814:
2815: vl_rec_found_flag VARCHAR2(1) ;
2816: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2821: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2822: vl_ctr NUMBER ;

Line 2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

2816: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2821: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2822: vl_ctr NUMBER ;
2823: vl_index BINARY_INTEGER;
2824: vl_no_of_rows NUMBER;

Line 2821: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

2817: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2818: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2820: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2821: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2822: vl_ctr NUMBER ;
2823: vl_index BINARY_INTEGER;
2824: vl_no_of_rows NUMBER;
2825: vl_last_row NUMBER;

Line 2842: FROM Po_Req_Distributions_All

2838: vt_headers t_headers_table;
2839:
2840: CURSOR get_lcount_cur IS
2841: SELECT COUNT(*)
2842: FROM Po_Req_Distributions_All
2843: WHERE requisition_line_id = vt_lines(vl_index)
2844: AND gl_closed_date IS NULL;
2845:
2846: CURSOR get_header_cur IS

Line 2889: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,

2885:
2886: -- Build the select statement to get the distribution details
2887: vl_dist_select := 'SELECT po.distribution_id,
2888: po.requisition_line_id, ph.segment1
2889: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2890: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2891: WHERE po.gl_closed_date IS NULL
2892: AND gcc.code_combination_id = po.code_combination_id
2893: AND gcc.chart_of_accounts_id = :coa

Line 2920: -- In this case,just go ahead and update the Po_Req_Distributions_All table

2916: vl_rec_found_flag := 'Y';
2917:
2918: -- If vl_prev_line_id = vl_line_id, then this is the scenario
2919: -- when for the same requisition line we have multiple distributions.
2920: -- In this case,just go ahead and update the Po_Req_Distributions_All table
2921: -- for the new distribution_id,without inseritng into the table.
2922: IF (vl_prev_line_id <> vl_line_id) THEN -- vl_prev_line_id
2923: -- insert into vt_lines table
2924: vt_lines(vl_ctr) := vl_line_id;

Line 2932: -- Update the Po_Req_Distributions_All table

2928: vl_prev_line_id := vl_line_id;
2929:
2930: END IF; -- vl_prev_line_id
2931:
2932: -- Update the Po_Req_Distributions_All table
2933: UPDATE Po_Req_Distributions_All
2934: SET gl_closed_date = vg_end_date
2935: WHERE distribution_id = vl_distr_id;
2936: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2933: UPDATE Po_Req_Distributions_All

2929:
2930: END IF; -- vl_prev_line_id
2931:
2932: -- Update the Po_Req_Distributions_All table
2933: UPDATE Po_Req_Distributions_All
2934: SET gl_closed_date = vg_end_date
2935: WHERE distribution_id = vl_distr_id;
2936: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2937: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CLOSED THE DISTRIBUTION WITH '||