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_REQUISITION_HEADERS_ALL

Line 2819: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;

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 ;
2823: vl_index BINARY_INTEGER;

Line 2827: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;

2823: vl_index BINARY_INTEGER;
2824: vl_no_of_rows NUMBER;
2825: vl_last_row NUMBER;
2826: vl_lines_count NUMBER;
2827: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2828: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2829: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2830: vl_head_ctr NUMBER ;
2831:

Line 2828: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;

2824: vl_no_of_rows NUMBER;
2825: vl_last_row NUMBER;
2826: vl_lines_count NUMBER;
2827: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2828: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2829: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2830: vl_head_ctr NUMBER ;
2831:
2832: TYPE t_lines_table IS TABLE OF NUMBER

Line 2829: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;

2825: vl_last_row NUMBER;
2826: vl_lines_count NUMBER;
2827: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2828: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2829: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2830: vl_head_ctr NUMBER ;
2831:
2832: TYPE t_lines_table IS TABLE OF NUMBER
2833: INDEX BY BINARY_INTEGER;

Line 2890: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph

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
2894: AND po.set_of_books_id = :sob

Line 3045: -- Update the Po_Requisition_Headers_All table

3041: TO_CHAR(vl_lines_count));
3042: END IF;
3043:
3044: IF (vl_lines_count = 0) THEN -- vl_lines_count header
3045: -- Update the Po_Requisition_Headers_All table
3046: UPDATE Po_Requisition_Headers_All
3047: SET closed_code = 'FINALLY CLOSED'
3048: WHERE requisition_header_id = vt_headers(vl_index);
3049:

Line 3046: UPDATE Po_Requisition_Headers_All

3042: END IF;
3043:
3044: IF (vl_lines_count = 0) THEN -- vl_lines_count header
3045: -- Update the Po_Requisition_Headers_All table
3046: UPDATE Po_Requisition_Headers_All
3047: SET closed_code = 'FINALLY CLOSED'
3048: WHERE requisition_header_id = vt_headers(vl_index);
3049:
3050: vl_prt_hdr_id := vt_headers(vl_index);