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 269: l_reqTemplate_csr ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type;

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

Line 404: ( p_reqTemplate_csr IN ICX_CAT_POPULATE_ITEM_PVT.g_item_csr_type ,

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

Line 417: l_current_ctx_item_rec ICX_CAT_POPULATE_ITEM_PVT.g_ctx_item_rec_type;

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

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

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

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

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

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

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