DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_POPULATE_STATUS_PVT

Line 412: l_BPA_line_status_rec ICX_CAT_POPULATE_STATUS_PVT.g_BPA_line_status_rec_type;

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

Line 639: l_ReqTmplt_line_status := ICX_CAT_POPULATE_STATUS_PVT.getTemplateLineStatus

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

Line 644: l_ReqTmplt_line_status = ICX_CAT_POPULATE_STATUS_PVT.VALID_FOR_POPULATE)

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