APPS.PO_REQ_TEMPLATE_SV dependencies on PO_REQEXPRESS_LINES

Line 66: FROM PO_REQEXPRESS_LINES

62: l_ip_category_id PO_LINES_ALL.ip_category_id%TYPE; --
63:
64: CURSOR C IS
65: SELECT rowid
66: FROM PO_REQEXPRESS_LINES
67: WHERE express_name = x_express_name
68: AND sequence_num = x_sequence_num;
69: BEGIN
70:

Line 90: INSERT INTO PO_REQEXPRESS_LINES (

86: --dbms_output.put_line('Before insert');
87:
88: --
89: -- Added Amount to the INSERT statement
90: INSERT INTO PO_REQEXPRESS_LINES (
91: express_name,
92: sequence_num,
93: last_update_date,
94: last_updated_by,

Line 292: UPDATE PO_REQEXPRESS_LINES

288: --
289:
290: --
291: -- Added Amount to the UPDATE statement
292: UPDATE PO_REQEXPRESS_LINES
293: SET express_name = x_express_name,
294: sequence_num = x_sequence_num,
295: last_update_date = x_last_update_date,
296: last_updated_by = x_last_updated_by,

Line 413: FROM PO_REQEXPRESS_LINES

409: x_amount NUMBER) --
410: IS
411: CURSOR C IS
412: SELECT *
413: FROM PO_REQEXPRESS_LINES
414: WHERE rowid = x_rowid
415: FOR UPDATE of express_name NOWAIT;
416: Recinfo C%ROWTYPE;
417: l_api_name CONSTANT VARCHAR2(30) := 'lock_line';

Line 683: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;

679:
680: PROCEDURE delete_line (x_rowid VARCHAR2)
681: IS
682: --
683: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
684: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
685: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
686: --
687: BEGIN

Line 684: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;

680: PROCEDURE delete_line (x_rowid VARCHAR2)
681: IS
682: --
683: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
684: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
685: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
686: --
687: BEGIN
688:

Line 685: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;

681: IS
682: --
683: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
684: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
685: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
686: --
687: BEGIN
688:
689: DELETE FROM PO_REQEXPRESS_LINES

Line 689: DELETE FROM PO_REQEXPRESS_LINES

685: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
686: --
687: BEGIN
688:
689: DELETE FROM PO_REQEXPRESS_LINES
690: WHERE rowid = X_Rowid
691: --
692: RETURNING
693: express_name,