DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_POPULATE_ITEM_PVT

Line 15: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

11: PROCEDURE openR12UpgradeReqTmpltsCursor
12: IS
13: l_api_name CONSTANT VARCHAR2(30) := 'openR12UpgradeReqTmpltsCursor';
14: l_err_loc PLS_INTEGER;
15: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
16: BEGIN
17: l_err_loc := 100;
18: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
19: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 267: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

263: )
264: IS
265: l_api_name CONSTANT VARCHAR2(30) := 'openReqTmpltsCursor';
266: l_err_loc PLS_INTEGER;
267: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;
268: BEGIN
269: l_err_loc := 100;
270: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
271: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,

Line 401: ( p_reqTemplate_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

397: END openReqTmpltsCursor;
398:
399: -- l_reqTemplate_csr, ICX_CAT_UTIL_PVT.g_upgrade_const
400: PROCEDURE populateReqTemplates
401: ( p_reqTemplate_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,
402: p_current_mode IN VARCHAR2
403: )
404: IS
405:

Line 414: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

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 -----
417: l_inv_item_id_tbl DBMS_SQL.NUMBER_TABLE;
418: l_req_template_name_tbl DBMS_SQL.VARCHAR2_TABLE;

Line 704: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);

700: l_current_ctx_item_rec.ctx_item_revision := l_ctx_item_revision_tbl(i);
701: l_current_ctx_item_rec.ctx_rowid := l_ctx_rowid_tbl(i);
702:
703: l_err_loc := 1200;
704: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
705:
706: l_err_loc := 1300;
707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE

Line 707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);

703: l_err_loc := 1200;
704: ICX_CAT_POPULATE_ITEM_PVT.processCurrentCtxItemRow(l_current_ctx_item_rec, null, p_current_mode);
705:
706: l_err_loc := 1300;
707: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('INLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
708: ELSE
709: IF (p_current_mode = ICX_CAT_UTIL_PVT.g_upgrade_const) THEN
710: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);

777: END;
778: END LOOP; --Cursor loop
779:
780: l_err_loc := 1700;
781: ICX_CAT_POPULATE_ITEM_PVT.populateItemCtxTables('OUTLOOP', ICX_CAT_UTIL_PVT.g_ReqTemplateCsr_const);
782:
783: l_err_loc := 1800;
784: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,