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_CLAUSES_PVT dependencies on OKC_XPRT_CZ_INT_PVT

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

122: l_cz_imp_devl_project_rec.INVENTORY_ITEM_ID:= NULL;
123: l_cz_imp_devl_project_rec.PRODUCT_KEY:= NULL;
124: l_cz_imp_devl_project_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.LOGIN_ID;
125: l_cz_imp_devl_project_rec.BOM_CAPTION_RULE_ID:= NULL;
126: l_cz_imp_devl_project_rec.NONBOM_CAPTION_RULE_ID:= OKC_XPRT_CZ_INT_PVT.G_CAPTION_RULE_DESC; -- display desc in runtime UIs
127: l_cz_imp_devl_project_rec.SEEDED_FLAG:= '1'; -- '0' unseeded , '1' seeded
128:
129: --
130:

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

423: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
424: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
425: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
426: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
427: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
428: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
429: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
430: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
431: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

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

424: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
425: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
426: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
427: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
428: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
429: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
430: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
431: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
432: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

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

851: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
852: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
853: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
854: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
855: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
856: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
857: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
858: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
859: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

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

852: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
853: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
854: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= NULL;
855: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
856: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
857: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
858: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
859: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
860: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

Line 1435: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM

1431: NULL, --MUTUALLY_EXCLUSIVE_OPTIONS,
1432: NULL, --OPTIONAL,
1433: NULL, --FSK_EXPLNODE_1_1,
1434: NULL, --FSK_PSNODE_6_1,
1435: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
1436: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
1437: NULL, --EFFECTIVE_USAGE_MASK,
1438: NULL, --EFFECTIVITY_SET_ID,
1439: NULL, --FSK_EFFSET_7_1,

Line 1436: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL

1432: NULL, --OPTIONAL,
1433: NULL, --FSK_EXPLNODE_1_1,
1434: NULL, --FSK_PSNODE_6_1,
1435: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN, --EFFECTIVE_FROM
1436: OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END, --EFFECTIVE_UNTIL
1437: NULL, --EFFECTIVE_USAGE_MASK,
1438: NULL, --EFFECTIVITY_SET_ID,
1439: NULL, --FSK_EFFSET_7_1,
1440: '0', --DECIMAL_QTY_FLAG -- 0 for all nodes

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

1671: l_cz_imp_ps_nodes_rec.MUTUALLY_EXCLUSIVE_OPTIONS:= NULL;
1672: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
1673: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
1674: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
1675: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
1676: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
1677: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
1678: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
1679: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;

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

1672: l_cz_imp_ps_nodes_rec.OPTIONAL:= NULL;
1673: l_cz_imp_ps_nodes_rec.FSK_EXPLNODE_1_1:= NULL;
1674: l_cz_imp_ps_nodes_rec.FSK_PSNODE_6_1:= G_VARIABLE_MODEL_TOPNODE_OSR||p_intent;
1675: l_cz_imp_ps_nodes_rec.EFFECTIVE_FROM:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_BEGIN;
1676: l_cz_imp_ps_nodes_rec.EFFECTIVE_UNTIL:= OKC_XPRT_CZ_INT_PVT.G_CZ_EPOCH_END;
1677: l_cz_imp_ps_nodes_rec.EFFECTIVE_USAGE_MASK:= NULL;
1678: l_cz_imp_ps_nodes_rec.EFFECTIVITY_SET_ID:= NULL;
1679: l_cz_imp_ps_nodes_rec.FSK_EFFSET_7_1:= NULL;
1680: l_cz_imp_ps_nodes_rec.DECIMAL_QTY_FLAG:= 0; -- 0 for all nodes

Line 1968: WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID

1964:
1965: CURSOR csr_clause_folder(p_folder_name IN VARCHAR2) IS
1966: SELECT object_id
1967: FROM cz_rp_entries
1968: WHERE enclosing_folder= OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID
1969: AND object_type = 'FLD'
1970: AND deleted_flag=0
1971: AND name = p_folder_name ;
1972: -- AND name = G_CLAUSE_FOLDER_OSR||p_org_id;

Line 2033: OKC_XPRT_CZ_INT_PVT.create_rp_folder(

2029: FND_MESSAGE.set_token('ORG_NAME',G_ORGANIZATION_NAME);
2030: l_folder_desc := FND_MESSAGE.get;
2031:
2032: -- folder does not exits so create the folder
2033: OKC_XPRT_CZ_INT_PVT.create_rp_folder(
2034: p_api_version => l_api_version,
2035: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID,
2036: p_new_folder_name => G_CLAUSE_FOLDER_OSR||p_org_id,
2037: p_folder_desc => l_folder_desc,

Line 2035: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID,

2031:
2032: -- folder does not exits so create the folder
2033: OKC_XPRT_CZ_INT_PVT.create_rp_folder(
2034: p_api_version => l_api_version,
2035: p_encl_folder_id => OKC_XPRT_CZ_INT_PVT.G_CLAUSE_FOLDER_ID,
2036: p_new_folder_name => G_CLAUSE_FOLDER_OSR||p_org_id,
2037: p_folder_desc => l_folder_desc,
2038: p_folder_notes => l_folder_desc,
2039: x_new_folder_id => l_clause_folder_id,

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

2044: -- debug log
2045: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2047: G_MODULE||l_api_name,
2048: '111: After Calling OKC_XPRT_CZ_INT_PVT.create_rp_folder x_return_status : '||x_return_status);
2049: END IF;
2050:
2051: --- If any errors happen abort API
2052: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2238: OKC_XPRT_CZ_INT_PVT.import_generic

2234: -- END LOOP;
2235: --CLOSE csr_intent;
2236:
2237: -- Call the CZ Generic Import to push data to CZ
2238: OKC_XPRT_CZ_INT_PVT.import_generic
2239: (
2240: p_api_version => l_api_version,
2241: p_run_id => G_RUN_ID,
2242: p_rp_folder_id => l_clause_folder_id,

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

2248: -- debug log
2249: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2250: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
2251: G_MODULE||l_api_name,
2252: '700: After Calling OKC_XPRT_CZ_INT_PVT.import_generic x_return_status : '||
2253: l_import_status);
2254: END IF;
2255:
2256: -- Log the Import Status and check if any records in the import tables have status not 'OK'