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.ICX_CAT_POPULATE_ITEM_PVT dependencies on ICX_CAT_BUILD_CTX_SQL_PVT

Line 2071: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

2067: IS
2068: l_api_name CONSTANT VARCHAR2(30) := 'populateItemCtxTables';
2069: l_err_loc PLS_INTEGER;
2070: l_action_mode VARCHAR2(80);
2071: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2072: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2073: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
2074: l_csr_handle NUMBER;
2075: l_status PLS_INTEGER;

Line 2072: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

2068: l_api_name CONSTANT VARCHAR2(30) := 'populateItemCtxTables';
2069: l_err_loc PLS_INTEGER;
2070: l_action_mode VARCHAR2(80);
2071: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2072: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2073: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
2074: l_csr_handle NUMBER;
2075: l_status PLS_INTEGER;
2076: l_start_sequence NUMBER;

Line 2073: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

2069: l_err_loc PLS_INTEGER;
2070: l_action_mode VARCHAR2(80);
2071: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2072: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
2073: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
2074: l_csr_handle NUMBER;
2075: l_status PLS_INTEGER;
2076: l_start_sequence NUMBER;
2077: l_end_sequence NUMBER;

Line 2994: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;

2990: AND req_template_name = gDMDReqTemplateNameTbl(i)
2991: AND req_template_line_num = gDMDReqTemplateLineNumTbl(i)
2992: AND org_id = gDMDOrgIdTbl(i)
2993: AND language = gDMDLanguageTbl(i)
2994: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow;
2995:
2996: IF (gDMDInventoryItemIdTbl.COUNT > 0) THEN
2997: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2998: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3016: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;

3012: AND req_template_name = gDSDReqTemplateNameTbl(i)
3013: AND req_template_line_num = gDSDReqTemplateLineNumTbl(i)
3014: AND org_id = gDSDOrgIdTbl(i)
3015: AND language = gDSDLanguageTbl(i)
3016: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3017:
3018: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3019: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3020: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3038: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;

3034: AND req_template_name = gDIRDReqTemplateNameTbl(i)
3035: AND req_template_line_num = gDIRDReqTemplateLineNumTbl(i)
3036: AND org_id = gDIRDOrgIdTbl(i)
3037: AND language = gDIRDLanguageTbl(i)
3038: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3039:
3040: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3041: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3042: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3060: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;

3056: AND req_template_name = gDSCDReqTemplateNameTbl(i)
3057: AND req_template_line_num = gDSCDReqTemplateLineNumTbl(i)
3058: AND org_id = gDSCDOrgIdTbl(i)
3059: AND language = gDSCDLanguageTbl(i)
3060: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3061:
3062: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3063: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3064: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3082: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForPurchasingOrgIdRow;

3078: AND req_template_name = gDPODReqTemplateNameTbl(i)
3079: AND req_template_line_num = gDPODReqTemplateLineNumTbl(i)
3080: AND org_id = gDPODOrgIdTbl(i)
3081: AND language = gDPODLanguageTbl(i)
3082: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForPurchasingOrgIdRow;
3083:
3084: IF (gDPODInventoryItemIdTbl.COUNT > 0) THEN
3085: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3086: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3516: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;

3512: AND req_template_name = gDSDReqTemplateNameTbl(i)
3513: AND req_template_line_num = gDSDReqTemplateLineNumTbl(i)
3514: AND org_id = gDSDOwningOrgIdTbl(i)
3515: AND language = gDSDLanguageTbl(i)
3516: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow;
3517:
3518: IF (gDSDInventoryItemIdTbl.COUNT > 0) THEN
3519: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 3555: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;

3551: AND req_template_name = gDIRDReqTemplateNameTbl(i)
3552: AND req_template_line_num = gDIRDReqTemplateLineNumTbl(i)
3553: AND org_id = gDIRDOwningOrgIdTbl(i)
3554: AND language = gDIRDLanguageTbl(i)
3555: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForItemRevisionRow;
3556:
3557: l_err_loc := 2800;
3558: IF (gDIRDInventoryItemIdTbl.COUNT > 0) THEN
3559: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3594: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;

3590: AND req_template_name = gDSCDReqTemplateNameTbl(i)
3591: AND req_template_line_num = gDSCDReqTemplateLineNumTbl(i)
3592: AND org_id = gDSCDOwningOrgIdTbl(i)
3593: AND language = gDSCDLanguageTbl(i)
3594: AND sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForShoppingCategoryRow;
3595:
3596: l_err_loc := 2900;
3597: IF (gDSCDInventoryItemIdTbl.COUNT > 0) THEN
3598: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3707: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble

3703: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3704: l_row_count PLS_INTEGER;
3705: BEGIN
3706: l_err_loc := 100;
3707: ICX_CAT_BUILD_CTX_SQL_PVT.checkIfAttributeIsSrchble
3708: ('SUPPLIER', l_searchable, l_section_tag);
3709:
3710: l_err_loc := 200;
3711: -- Set the batch_size if supplier needs to be updated

Line 3769: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow

3765: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
3766: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3767: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3768: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
3769: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow
3770: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs
3771: WHERE hdrs.po_line_id = dtls.po_line_id
3772: AND hdrs.req_template_name = dtls.req_template_name
3773: AND hdrs.req_template_line_num = dtls.req_template_line_num

Line 3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

3902: l_continue BOOLEAN := TRUE;
3903: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3904: l_rows_updated BOOLEAN := TRUE;
3905: l_metadataTblFormed BOOLEAN := FALSE;
3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

3903: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3904: l_rows_updated BOOLEAN := TRUE;
3905: l_metadataTblFormed BOOLEAN := FALSE;
3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

Line 3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

3904: l_rows_updated BOOLEAN := TRUE;
3905: l_metadataTblFormed BOOLEAN := FALSE;
3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

Line 3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

3905: l_metadataTblFormed BOOLEAN := FALSE;
3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
3913: l_csr_handle NUMBER;

Line 3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

3906: l_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
3913: l_csr_handle NUMBER;
3914: l_status PLS_INTEGER;

Line 3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;

3907: l_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
3913: l_csr_handle NUMBER;
3914: l_status PLS_INTEGER;
3915: l_searchable VARCHAR2(1) := NULL;

Line 3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;

3908: l_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
3909: l_all_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3910: l_special_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3911: l_regular_ctx_sql_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_tbl_type;
3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
3913: l_csr_handle NUMBER;
3914: l_status PLS_INTEGER;
3915: l_searchable VARCHAR2(1) := NULL;
3916: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

Line 3916: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;

3912: l_ctx_sqlstring_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_ctx_sql_rec_type;
3913: l_csr_handle NUMBER;
3914: l_status PLS_INTEGER;
3915: l_searchable VARCHAR2(1) := NULL;
3916: l_metadata_rec ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_rec_type;
3917: l_row_count PLS_INTEGER;
3918: BEGIN
3919: l_err_loc := 100;
3920: -- Set the batch_size if supplier needs to be updated

Line 3990: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow

3986: l_err_loc := 1300;
3987: -- delete the mandatory row in icx_cat_items_ctx_dtls_tlp i.e. the row with sequence = 1
3988: FORALL i IN 1..l_rowid_tbl.COUNT
3989: DELETE FROM icx_cat_items_ctx_dtls_tlp dtls
3990: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqMandatoryBaseRow
3991: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs
3992: WHERE hdrs.po_line_id = dtls.po_line_id
3993: AND hdrs.req_template_name = dtls.req_template_name
3994: AND hdrs.req_template_line_num = dtls.req_template_line_num

Line 4016: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo

4012: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4013: 'populateVendorMerge: about to call buildMetaDataInfo and buildCtxSql');
4014: END IF;
4015:
4016: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
4017: (0, l_special_metadata_tbl, l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl);
4018: l_metadataTblFormed := TRUE;
4019:
4020: l_err_loc := 1600;

Line 4022: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql

4018: l_metadataTblFormed := TRUE;
4019:
4020: l_err_loc := 1600;
4021:
4022: ICX_CAT_BUILD_CTX_SQL_PVT.buildCtxSql
4023: (0, 'ALL', 'ROWID', l_special_metadata_tbl,
4024: l_regular_nontl_metadata_tbl, l_regular_tl_metadata_tbl,
4025: l_all_ctx_sql_tbl, l_special_ctx_sql_tbl, l_regular_ctx_sql_tbl);
4026:

Line 4058: ICX_CAT_BUILD_CTX_SQL_PVT.getAttributeDetails

4054: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
4055: 'about to call the getAttributeDetails for supplier');
4056: END IF;
4057:
4058: ICX_CAT_BUILD_CTX_SQL_PVT.getAttributeDetails
4059: (l_special_metadata_tbl, 'SUPPLIER', l_searchable, l_metadata_rec);
4060: END IF;
4061:
4062: l_err_loc := 2300;

Line 4078: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow

4074: request_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.request_id,
4075: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
4076: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
4077: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
4078: WHERE sequence = ICX_CAT_BUILD_CTX_SQL_PVT.g_seqForSupplierRow
4079: AND EXISTS ( SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs
4080: WHERE hdrs.po_line_id = dtls.po_line_id
4081: AND hdrs.req_template_name = dtls.req_template_name
4082: AND hdrs.req_template_line_num = dtls.req_template_line_num