67:
68: PROCEDURE default_group_line_id
69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
74: );
75:
68: PROCEDURE default_group_line_id
69: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
70: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
73: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
74: );
75:
76: PROCEDURE validate_line_num_display
75:
76: PROCEDURE validate_line_num_display
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
82: p_po_line_id_tbl IN PO_TBL_NUMBER
83: );
76: PROCEDURE validate_line_num_display
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
82: p_po_line_id_tbl IN PO_TBL_NUMBER
83: );
84: --CLM PDOI Integration Ends
77: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
78: p_intf_line_id_tbl IN PO_TBL_NUMBER,
79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
82: p_po_line_id_tbl IN PO_TBL_NUMBER
83: );
84: --CLM PDOI Integration Ends
85:
208: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
209: d_position NUMBER;
210:
211: l_intf_line_id_tbl PO_TBL_NUMBER;
212: l_price_chg_accept_flag_tbl PO_TBL_VARCHAR1;
213: l_price_break_flag_tbl PO_TBL_VARCHAR1;
214:
215: l_current_flag VARCHAR2(1);
216:
209: d_position NUMBER;
210:
211: l_intf_line_id_tbl PO_TBL_NUMBER;
212: l_price_chg_accept_flag_tbl PO_TBL_VARCHAR1;
213: l_price_break_flag_tbl PO_TBL_VARCHAR1;
214:
215: l_current_flag VARCHAR2(1);
216:
217: l_update_flag_value_idx_tbl PO_PDOI_UTL.pls_integer_tbl_type :=
953: l_vendor_doc_num_tbl PO_TBL_VARCHAR25;
954:
955: l_orig_po_header_id_tbl PO_TBL_NUMBER;
956: l_orig_closed_code_tbl PO_TBL_VARCHAR25;
957: l_orig_cancel_flag_tbl PO_TBL_VARCHAR1;
958: l_orig_ga_tbl PO_TBL_VARCHAR1;
959:
960: l_doc_active BOOLEAN;
961:
954:
955: l_orig_po_header_id_tbl PO_TBL_NUMBER;
956: l_orig_closed_code_tbl PO_TBL_VARCHAR25;
957: l_orig_cancel_flag_tbl PO_TBL_VARCHAR1;
958: l_orig_ga_tbl PO_TBL_VARCHAR1;
959:
960: l_doc_active BOOLEAN;
961:
962: l_index_for_replacement NUMBER;
1366: l_status_rec PO_STATUS_REC_TYPE;
1367: l_return_status VARCHAR2(1);
1368:
1369: l_orig_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1371:
1372: l_consigned_consumption_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
1373:
1374: l_final_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3122: d_position NUMBER;
3123:
3124: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3124: l_intf_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3125: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3127: l_line_num NUMBER := 1;
3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3129: l_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3130: l_group_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3132: l_header_id NUMBER;
3133: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3134: l_max_line_num_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3135: -- table used to save the index of the each row
3264:
3265: PROCEDURE default_group_line_id
3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
3271: )
3272: IS
3265: PROCEDURE default_group_line_id
3266: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3267: p_intf_line_id_tbl IN PO_TBL_NUMBER ,
3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,
3270: p_group_line_id_tbl OUT NOCOPY PO_TBL_NUMBER
3271: )
3272: IS
3273:
3362:
3363: PROCEDURE validate_line_num_display
3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
3369: p_po_line_id_tbl IN PO_TBL_NUMBER
3370: )
3363: PROCEDURE validate_line_num_display
3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
3369: p_po_line_id_tbl IN PO_TBL_NUMBER
3370: )
3371: IS
3364: ( p_intf_header_id_tbl IN PO_TBL_NUMBER,
3365: p_intf_line_id_tbl IN PO_TBL_NUMBER,
3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,
3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,
3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,
3369: p_po_line_id_tbl IN PO_TBL_NUMBER
3370: )
3371: IS
3372:
3373: d_api_name CONSTANT VARCHAR2(30) := 'validate_line_num_display';
3374: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
3375: d_position NUMBER;
3376: l_index_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3377: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
3378: -- table used to save the index of the each row
3379: l_num_list DBMS_SQL.NUMBER_TABLE;
3380: -- key of temp table used to identify the derived result
3381: l_key po_session_gt.key%TYPE;
3381: l_key po_session_gt.key%TYPE;
3382: l_index NUMBER;
3383: BEGIN
3384:
3385: p_is_line_num_disp_valid := PO_TBL_VARCHAR1();
3386: d_position := 0;
3387:
3388: IF (PO_LOG.d_proc) THEN
3389: PO_LOG.proc_begin (d_module);