APPS.POR_WITHDRAW_REQ_SV dependencies on PO_REQUISITION_LINES_ALL

Line 34: CURSOR findEncCursor(requisition_id VARCHAR2) IS select ENCUMBERED_FLAG,LAST_UPDATED_BY from PO_REQUISITION_LINES_ALL where REQUISITION_HEADER_ID = requisition_id;

30: l_req_encumber varchar2(20);
31: l_gl_period varchar2(20);
32: l_sob_id number;
33:
34: CURSOR findEncCursor(requisition_id VARCHAR2) IS select ENCUMBERED_FLAG,LAST_UPDATED_BY from PO_REQUISITION_LINES_ALL where REQUISITION_HEADER_ID = requisition_id;
35:
36:
37: begin
38:

Line 71: from PO_REQUISITION_LINES_ALL

67:
68: delete PO_REQ_DISTRIBUTIONS_ALL
69: where REQUISITION_LINE_ID in
70: ( select requisition_line_id
71: from PO_REQUISITION_LINES_ALL
72: where REQUISITION_HEADER_ID = p_existing_requisition_id);
73:
74: delete PO_REQUISITION_LINES_ALL
75: where REQUISITION_HEADER_ID = p_existing_requisition_id;

Line 74: delete PO_REQUISITION_LINES_ALL

70: ( select requisition_line_id
71: from PO_REQUISITION_LINES_ALL
72: where REQUISITION_HEADER_ID = p_existing_requisition_id);
73:
74: delete PO_REQUISITION_LINES_ALL
75: where REQUISITION_HEADER_ID = p_existing_requisition_id;
76:
77: delete PO_REQUISITION_HEADERS_ALL
78: where REQUISITION_HEADER_ID = p_existing_requisition_id;

Line 91: update PO_REQUISITION_LINES_ALL

87: delete po_approval_list_headers
88: where document_id = p_existing_requisition_id
89: and document_type = 'REQUISITION';
90:
91: update PO_REQUISITION_LINES_ALL
92: set REQUISITION_HEADER_ID = p_existing_requisition_id
93: where REQUISITION_HEADER_ID = p_new_requisition_id;
94:
95: update PO_REQUISITION_HEADERS_ALL

Line 125: from PO_REQUISITION_LINES_ALL

121: GL_ENCUMBERED_PERIOD_NAME = l_gl_period
122: where nvl(encumbered_flag,'N') = 'N' and
123: REQUISITION_LINE_ID in
124: ( select requisition_line_id
125: from PO_REQUISITION_LINES_ALL
126: where REQUISITION_HEADER_ID = p_existing_requisition_id);
127: end if;
128:
129: exception