DBA Data[Home] [Help]

APPS.PO_PDOI_PREPROC_PVT dependencies on PO_TBL_VARCHAR1

Line 71: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,

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:

Line 72: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,

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

Line 79: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,

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: );

Line 80: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,

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

Line 81: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,

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:

Line 212: l_price_chg_accept_flag_tbl PO_TBL_VARCHAR1;

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:

Line 213: l_price_break_flag_tbl PO_TBL_VARCHAR1;

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 :=

Line 957: l_orig_cancel_flag_tbl PO_TBL_VARCHAR1;

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:

Line 958: l_orig_ga_tbl PO_TBL_VARCHAR1;

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;

Line 1370: l_orig_consumption_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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();

Line 3126: l_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();

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();

Line 3128: l_clm_info_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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;

Line 3131: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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

Line 3268: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,

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

Line 3269: p_is_line_num_disp_valid IN PO_TBL_VARCHAR1,

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:

Line 3366: p_line_num_disp_tbl IN PO_TBL_VARCHAR100,

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: )

Line 3367: p_clm_info_flag_tbl IN PO_TBL_VARCHAR1,

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

Line 3368: p_is_line_num_disp_valid OUT NOCOPY PO_TBL_VARCHAR1,

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:

Line 3377: l_is_line_num_disp_valid PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

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;

Line 3385: p_is_line_num_disp_valid := PO_TBL_VARCHAR1();

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);