APPS.POR_AMENDMENT_PKG dependencies on DBMS_SQL

Line 2699: l_distribution_ids Dbms_Sql.number_table;

2695: v_progress VARCHAR2(10);
2696: l_procedure_name VARCHAR2(100) := 'merge_amendment_distribution';
2697: l_log_msg VARCHAR2(2000);
2698:
2699: l_distribution_ids Dbms_Sql.number_table;
2700: l_conformed_dist_ids Dbms_Sql.number_table;
2701: l_req_line_id Dbms_Sql.number_table;
2702: l_info_line_id Dbms_Sql.number_table;
2703: l_new_dist_id NUMBER;

Line 2700: l_conformed_dist_ids Dbms_Sql.number_table;

2696: l_procedure_name VARCHAR2(100) := 'merge_amendment_distribution';
2697: l_log_msg VARCHAR2(2000);
2698:
2699: l_distribution_ids Dbms_Sql.number_table;
2700: l_conformed_dist_ids Dbms_Sql.number_table;
2701: l_req_line_id Dbms_Sql.number_table;
2702: l_info_line_id Dbms_Sql.number_table;
2703: l_new_dist_id NUMBER;
2704:

Line 2701: l_req_line_id Dbms_Sql.number_table;

2697: l_log_msg VARCHAR2(2000);
2698:
2699: l_distribution_ids Dbms_Sql.number_table;
2700: l_conformed_dist_ids Dbms_Sql.number_table;
2701: l_req_line_id Dbms_Sql.number_table;
2702: l_info_line_id Dbms_Sql.number_table;
2703: l_new_dist_id NUMBER;
2704:
2705: l_info_line_temp_id NUMBER;

Line 2702: l_info_line_id Dbms_Sql.number_table;

2698:
2699: l_distribution_ids Dbms_Sql.number_table;
2700: l_conformed_dist_ids Dbms_Sql.number_table;
2701: l_req_line_id Dbms_Sql.number_table;
2702: l_info_line_id Dbms_Sql.number_table;
2703: l_new_dist_id NUMBER;
2704:
2705: l_info_line_temp_id NUMBER;
2706:

Line 3453: l_line_ids Dbms_Sql.number_table;

3449: l_log_msg VARCHAR2(2000);
3450:
3451: line_map g_line_id_map;
3452:
3453: l_line_ids Dbms_Sql.number_table;
3454: l_conformed_line_ids Dbms_Sql.number_table;
3455: l_clm_base_line_num Dbms_Sql.number_table;
3456: l_group_line_id Dbms_Sql.number_table;
3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;

Line 3454: l_conformed_line_ids Dbms_Sql.number_table;

3450:
3451: line_map g_line_id_map;
3452:
3453: l_line_ids Dbms_Sql.number_table;
3454: l_conformed_line_ids Dbms_Sql.number_table;
3455: l_clm_base_line_num Dbms_Sql.number_table;
3456: l_group_line_id Dbms_Sql.number_table;
3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;
3458: l_new_line_id NUMBER;

Line 3455: l_clm_base_line_num Dbms_Sql.number_table;

3451: line_map g_line_id_map;
3452:
3453: l_line_ids Dbms_Sql.number_table;
3454: l_conformed_line_ids Dbms_Sql.number_table;
3455: l_clm_base_line_num Dbms_Sql.number_table;
3456: l_group_line_id Dbms_Sql.number_table;
3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;
3458: l_new_line_id NUMBER;
3459:

Line 3456: l_group_line_id Dbms_Sql.number_table;

3452:
3453: l_line_ids Dbms_Sql.number_table;
3454: l_conformed_line_ids Dbms_Sql.number_table;
3455: l_clm_base_line_num Dbms_Sql.number_table;
3456: l_group_line_id Dbms_Sql.number_table;
3457: l_req_header_id po_requisition_headers_all.requisition_header_id%TYPE;
3458: l_new_line_id NUMBER;
3459:
3460: BEGIN