DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_TBL_VARCHAR1

Line 17: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

13: d_position NUMBER;
14:
15: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
16: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
17: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
19:
20: begin
21: d_position := 0;

Line 18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

14:
15: l_po_header_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
16: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
17: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
18: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
19:
20: begin
21: d_position := 0;
22: IF (PO_LOG.d_proc) THEN

Line 93: l_item_key_tbl po_tbl_varchar100;

89: l_contract_document_type VARCHAR2(30);
90: x_return_status VARCHAR2 (1) ;
91: x_msg_count NUMBER;
92: x_msg_data VARCHAR2(100) ;
93: l_item_key_tbl po_tbl_varchar100;
94: l_mod_number po_drafts.modification_number%TYPE;
95: l_item_status varchar2(10);
96: l_result VARCHAR2(10);
97: --bug 15905347 start

Line 328: l_item_key_tbl po_tbl_varchar100;

324:
325: l_return_status VARCHAR2(1);
326: l_msg_data VARCHAR2(2000);
327: l_msg_count NUMBER;
328: l_item_key_tbl po_tbl_varchar100;
329: l_mod_number po_drafts.modification_number%TYPE;
330: l_item_status varchar2(10);
331: l_result varchar2(10);
332:

Line 683: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

679: d_position NUMBER;
680:
681: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
682: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
683: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
685:
686: begin
687: d_position := 0;

Line 684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

680:
681: l_po_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
682: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
683: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
684: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
685:
686: begin
687: d_position := 0;
688: IF (PO_LOG.d_proc) THEN

Line 796: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

792: d_position NUMBER;
793:
794: l_po_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
795: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
796: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
798:
799: begin
800: d_position := 0;

Line 797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

793:
794: l_po_line_loc_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
795: l_po_draft_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
796: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
797: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
798:
799: begin
800: d_position := 0;
801: IF (PO_LOG.d_proc) THEN

Line 1118: l_item_key_tbl PO_TBL_VARCHAR100;

1114: l_error_message VARCHAR2(2000);
1115: l_req_header_id NUMBER;
1116: l_req_authorization_status po_requisition_headers_all.authorization_status%TYPE;
1117: l_approval_id NUMBER;
1118: l_item_key_tbl PO_TBL_VARCHAR100;
1119: l_item_status VARCHAR2(10);
1120: l_result VARCHAR2(10);
1121: d_api_name CONSTANT VARCHAR2(30) := 'process_par_withdraw_action';
1122: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';