APPS.FV_YE_CLOSE dependencies on PO_REQUISITION_HEADERS_ALL

Line 2869: vl_req_num Po_Requisition_Headers_All.segment1%TYPE;

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

Line 2877: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;

2873: vl_index BINARY_INTEGER;
2874: vl_no_of_rows NUMBER;
2875: vl_last_row NUMBER;
2876: vl_lines_count NUMBER;
2877: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2878: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2879: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2880: vl_head_ctr NUMBER ;
2881:

Line 2878: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;

2874: vl_no_of_rows NUMBER;
2875: vl_last_row NUMBER;
2876: vl_lines_count NUMBER;
2877: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2878: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2879: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2880: vl_head_ctr NUMBER ;
2881:
2882: TYPE t_lines_table IS TABLE OF NUMBER

Line 2879: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;

2875: vl_last_row NUMBER;
2876: vl_lines_count NUMBER;
2877: vl_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2878: vl_prev_header_id Po_Requisition_Headers_All.requisition_header_id%TYPE ;
2879: vl_prt_hdr_id Po_Requisition_Headers_All.requisition_header_id%TYPE;
2880: vl_head_ctr NUMBER ;
2881:
2882: TYPE t_lines_table IS TABLE OF NUMBER
2883: INDEX BY BINARY_INTEGER;

Line 2943: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph

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

Line 3098: -- Update the Po_Requisition_Headers_All table

3094: TO_CHAR(vl_lines_count));
3095: END IF;
3096:
3097: IF (vl_lines_count = 0) THEN -- vl_lines_count header
3098: -- Update the Po_Requisition_Headers_All table
3099: UPDATE Po_Requisition_Headers_All
3100: SET closed_code = 'FINALLY CLOSED'
3101: WHERE requisition_header_id = vt_headers(vl_index);
3102:

Line 3099: UPDATE Po_Requisition_Headers_All

3095: END IF;
3096:
3097: IF (vl_lines_count = 0) THEN -- vl_lines_count header
3098: -- Update the Po_Requisition_Headers_All table
3099: UPDATE Po_Requisition_Headers_All
3100: SET closed_code = 'FINALLY CLOSED'
3101: WHERE requisition_header_id = vt_headers(vl_index);
3102:
3103: vl_prt_hdr_id := vt_headers(vl_index);