DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_POPULATE_STATUS_PVT

Line 415: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;

411: l_err_string VARCHAR2(4000);
412: l_batch_count PLS_INTEGER;
413: l_row_count PLS_INTEGER;
414: l_count PLS_INTEGER;
415: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;
416: l_ReqTmplt_line_status PLS_INTEGER;
417: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;
418:
419: ----- Start of declaring columns selected in the cursor -----

Line 642: l_ReqTmplt_line_status := ICX_CAT_POPULATE_STATUS_PVT.getTemplateLineStatus

638: l_BPA_line_status_rec.expiration_date := l_expiration_date_tbl(i);
639: l_BPA_line_status_rec.system_date := l_system_date_tbl(i);
640:
641: l_err_loc := 900;
642: l_ReqTmplt_line_status := ICX_CAT_POPULATE_STATUS_PVT.getTemplateLineStatus
643: (l_inactive_date_tbl(i), l_po_line_id_tbl(i), l_BPA_line_status_rec);
644:
645: l_err_loc := 1000;
646: IF (l_ctx_rowid_tbl(i) IS NOT NULL OR

Line 647: l_ReqTmplt_line_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE)

643: (l_inactive_date_tbl(i), l_po_line_id_tbl(i), l_BPA_line_status_rec);
644:
645: l_err_loc := 1000;
646: IF (l_ctx_rowid_tbl(i) IS NOT NULL OR
647: l_ReqTmplt_line_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE)
648: THEN
649: l_err_loc := 1100;
650: l_current_ctx_item_rec.inventory_item_id := l_inv_item_id_tbl(i);
651: l_current_ctx_item_rec.po_line_id := TO_NUMBER(ICX_CAT_UTIL_PVT.g_NULL_NUMBER);