eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_IMPORT_TEMPLATE_PVT dependencies on OKC_XPRT_CZ_INT_PVT

Line 148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs

144: p_intent||':'||
145: p_template_id;
146: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
147: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
148: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
149: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
150:
151: --
152:

Line 460: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

456: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
457: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
458: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
459: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
460: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
461: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
462: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
463: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
464: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

Line 461: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

457: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
458: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
459: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
460: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
461: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
462: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
463: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
464: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
465: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

Line 1024: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

1020: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
1021: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
1022: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
1023: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
1024: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
1025: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
1026: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
1027: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
1028: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

Line 1025: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

1021: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
1022: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
1023: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
1024: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
1025: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
1026: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
1027: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
1028: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
1029: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

Line 1876: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM

1872: NULL, --MUTUALLY_EXCLUSIVE_OPTIONS,
1873: NULL, --OPTIONAL,
1874: NULL, --FSK_EXPLNODE_1_1,
1875: NULL, --FSK_PSNODE_6_1,
1876: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
1877: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
1878: NULL, --EFFECTIVE_USAGE_MASK,
1879: NULL, --EFFECTIVITY_SET_ID,
1880: NULL, --FSK_EFFSET_7_1,

Line 1877: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL

1873: NULL, --OPTIONAL,
1874: NULL, --FSK_EXPLNODE_1_1,
1875: NULL, --FSK_PSNODE_6_1,
1876: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
1877: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
1878: NULL, --EFFECTIVE_USAGE_MASK,
1879: NULL, --EFFECTIVITY_SET_ID,
1880: NULL, --FSK_EFFSET_7_1,
1881: '0', --DECIMAL_QTY_FLAG -- 0 for all nodes

Line 2156: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;

2152: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
2153: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
2154: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
2155: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
2156: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2157: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2158: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
2159: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
2160: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

Line 2157: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;

2153: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
2154: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
2155: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= G_CLAUSE_MODEL_TOPNODE_OSR||p_org_id||':'||p_intent;
2156: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
2157: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
2158: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
2159: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
2160: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
2161: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

Line 2456: WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID

2452: */
2453: CURSOR csr_template_folder(p_name IN VARCHAR2) IS
2454: SELECT object_id
2455: FROM cz_rp_entries
2456: WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID
2457: AND object_type = 'FLD'
2458: AND deleted_flag=0
2459: AND name = p_name;
2460: -- AND name = G_TEMPLATE_FOLDER_OSR||p_org_id||':'||p_intent;

Line 2592: OKC_XPRT_CZ_INT_PVT.create_rp_folder(

2588: FND_MESSAGE.set_token('INTENT',okc_util.decode_lookup('OKC_ARTICLE_INTENT',l_intent));
2589: l_folder_desc := FND_MESSAGE.get;
2590:
2591: -- folder does not exits so create the folder
2592: OKC_XPRT_CZ_INT_PVT.create_rp_folder(
2593: p_api_version => l_api_version,
2594: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID,
2595: p_new_folder_name => G_TEMPLATE_FOLDER_OSR||l_org_id||':'||l_intent,
2596: p_folder_desc => l_folder_desc,

Line 2594: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID,

2590:
2591: -- folder does not exits so create the folder
2592: OKC_XPRT_CZ_INT_PVT.create_rp_folder(
2593: p_api_version => l_api_version,
2594: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_TEMPLATE_FOLDER_ID,
2595: p_new_folder_name => G_TEMPLATE_FOLDER_OSR||l_org_id||':'||l_intent,
2596: p_folder_desc => l_folder_desc,
2597: p_folder_notes => l_folder_desc,
2598: x_new_folder_id => l_template_folder_id,

Line 2607: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);

2603: -- debug log
2604: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2606: G_MODULE||l_api_name,
2607: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2608: END IF;
2609:
2610: --- If any errors happen abort API
2611: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2778: OKC_XPRT_CZ_INT_PVT.import_generic

2774: RAISE FND_API.G_EXC_ERROR;
2775: END IF;
2776:
2777: -- Call the CZ Generic Import to push data to CZ
2778: OKC_XPRT_CZ_INT_PVT.import_generic
2779: (
2780: p_api_version => l_api_version,
2781: p_run_id => G_RUN_ID,
2782: p_rp_folder_id => l_template_folder_id,

Line 2792: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||

2788: -- debug log
2789: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2791: G_MODULE||l_api_name,
2792: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2793: l_import_status);
2794: END IF;
2795:
2796: -- Log the Import Status and check if any records in the import tables have status not 'OK'