APPS.PO_REQ_TEMPLATE_SV dependencies on PO_REQEXPRESS_LINES

Line 64: FROM PO_REQEXPRESS_LINES

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

Line 88: INSERT INTO PO_REQEXPRESS_LINES (

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

Line 290: UPDATE PO_REQEXPRESS_LINES

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

Line 411: FROM PO_REQEXPRESS_LINES

407: x_amount NUMBER) --
408: IS
409: CURSOR C IS
410: SELECT *
411: FROM PO_REQEXPRESS_LINES
412: WHERE rowid = x_rowid
413: FOR UPDATE of express_name NOWAIT;
414: Recinfo C%ROWTYPE;
415:

Line 562: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;

558:
559: PROCEDURE delete_line (x_rowid VARCHAR2)
560: IS
561: --
562: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
563: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
564: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
565: --
566: BEGIN

Line 563: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;

559: PROCEDURE delete_line (x_rowid VARCHAR2)
560: IS
561: --
562: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
563: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
564: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
565: --
566: BEGIN
567:

Line 564: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;

560: IS
561: --
562: l_req_template_name PO_REQEXPRESS_LINES_ALL.express_name%TYPE;
563: l_req_template_line_num PO_REQEXPRESS_LINES_ALL.sequence_num%TYPE;
564: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
565: --
566: BEGIN
567:
568: DELETE FROM PO_REQEXPRESS_LINES

Line 568: DELETE FROM PO_REQEXPRESS_LINES

564: l_org_id PO_REQEXPRESS_LINES_ALL.org_id%TYPE;
565: --
566: BEGIN
567:
568: DELETE FROM PO_REQEXPRESS_LINES
569: WHERE rowid = X_Rowid
570: --
571: RETURNING
572: express_name,