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 2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;

2863: vl_dist_select VARCHAR2(2000);
2864:
2865: vl_rec_found_flag VARCHAR2(1) ;
2866: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2871: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

Line 2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;

2864:
2865: vl_rec_found_flag VARCHAR2(1) ;
2866: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2871: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2872: vl_ctr NUMBER ;

Line 2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

2866: vl_close_req Fv_Fund_Parameters.close_requisitions%TYPE;
2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2871: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2872: vl_ctr NUMBER ;
2873: vl_index BINARY_INTEGER;
2874: vl_no_of_rows NUMBER;

Line 2871: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;

2867: vl_distr_id Po_Req_Distributions_All.distribution_id%TYPE;
2868: vl_line_id Po_Req_Distributions_All.requisition_line_id%TYPE;
2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;
2870: vl_prev_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2871: vl_prt_line_id Po_Req_Distributions_All.requisition_line_id%TYPE ;
2872: vl_ctr NUMBER ;
2873: vl_index BINARY_INTEGER;
2874: vl_no_of_rows NUMBER;
2875: vl_last_row NUMBER;

Line 2892: FROM Po_Req_Distributions_All

2888: vt_headers t_headers_table;
2889:
2890: CURSOR get_lcount_cur IS
2891: SELECT COUNT(*)
2892: FROM Po_Req_Distributions_All
2893: WHERE requisition_line_id = vt_lines(vl_index)
2894: AND gl_closed_date IS NULL;
2895:
2896: CURSOR get_header_cur IS

Line 2942: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,

2938:
2939: -- Build the select statement to get the distribution details
2940: vl_dist_select := 'SELECT po.distribution_id,
2941: po.requisition_line_id, ph.segment1
2942: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2943: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2944: WHERE po.gl_closed_date IS NULL
2945: AND gcc.code_combination_id = po.code_combination_id
2946: AND gcc.chart_of_accounts_id = :coa

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

2969: vl_rec_found_flag := 'Y';
2970:
2971: -- If vl_prev_line_id = vl_line_id, then this is the scenario
2972: -- when for the same requisition line we have multiple distributions.
2973: -- In this case,just go ahead and update the Po_Req_Distributions_All table
2974: -- for the new distribution_id,without inseritng into the table.
2975: IF (vl_prev_line_id <> vl_line_id) THEN -- vl_prev_line_id
2976: -- insert into vt_lines table
2977: vt_lines(vl_ctr) := vl_line_id;

Line 2985: -- Update the Po_Req_Distributions_All table

2981: vl_prev_line_id := vl_line_id;
2982:
2983: END IF; -- vl_prev_line_id
2984:
2985: -- Update the Po_Req_Distributions_All table
2986: UPDATE Po_Req_Distributions_All
2987: SET gl_closed_date = vg_end_date
2988: WHERE distribution_id = vl_distr_id;
2989: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2986: UPDATE Po_Req_Distributions_All

2982:
2983: END IF; -- vl_prev_line_id
2984:
2985: -- Update the Po_Req_Distributions_All table
2986: UPDATE Po_Req_Distributions_All
2987: SET gl_closed_date = vg_end_date
2988: WHERE distribution_id = vl_distr_id;
2989: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2990: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CLOSED THE DISTRIBUTION WITH '||