APPS.PO_HEADERS_SV1 dependencies on PO_TBL_NUMBER

Line 214: l_deleted_line_list PO_TBL_NUMBER;

210:
211: X_progress VARCHAR2(3) := NULL;
212: X_deleted boolean;
213:
214: l_deleted_line_list PO_TBL_NUMBER;
215: l_deleted_dist_list PO_TBL_NUMBER;
216: d_pos NUMBER := 10;
217: l_api_name CONSTANT VARCHAR2(30) := 'delete_children';
218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';

Line 215: l_deleted_dist_list PO_TBL_NUMBER;

211: X_progress VARCHAR2(3) := NULL;
212: X_deleted boolean;
213:
214: l_deleted_line_list PO_TBL_NUMBER;
215: l_deleted_dist_list PO_TBL_NUMBER;
216: d_pos NUMBER := 10;
217: l_api_name CONSTANT VARCHAR2(30) := 'delete_children';
218: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_HEADERS_SV1.delete_children';
219: BEGIN

Line 235: l_deleted_line_list := PO_TBL_NUMBER();

231: -- This should be called only for CLM Standard document.
232: IF (PO_CLM_INTG_GRP.IS_CLM_DOCUMENT(p_doc_type => 'PO',p_document_id => X_po_header_id) = 'Y'
233: AND X_type_lookup_code = 'STANDARD') THEN
234:
235: l_deleted_line_list := PO_TBL_NUMBER();
236: l_deleted_dist_list := PO_TBL_NUMBER();
237:
238: -- Collect all deleted lines
239: SELECT po_line_id

Line 236: l_deleted_dist_list := PO_TBL_NUMBER();

232: IF (PO_CLM_INTG_GRP.IS_CLM_DOCUMENT(p_doc_type => 'PO',p_document_id => X_po_header_id) = 'Y'
233: AND X_type_lookup_code = 'STANDARD') THEN
234:
235: l_deleted_line_list := PO_TBL_NUMBER();
236: l_deleted_dist_list := PO_TBL_NUMBER();
237:
238: -- Collect all deleted lines
239: SELECT po_line_id
240: BULK COLLECT INTO l_deleted_line_list

Line 356: po_header_id_tbl PO_TBL_NUMBER;

352: X_allow_delete boolean;
353: X_rowid varchar2(30);
354: x_item_type varchar2(8);
355: x_item_key varchar2(240);
356: po_header_id_tbl PO_TBL_NUMBER;
357: l_return_status VARCHAR2(1);
358:
359: BEGIN
360: X_progress := '010';