430: pLanguage IN VARCHAR2 DEFAULT NULL,
431: pSourceType IN VARCHAR2 DEFAULT 'ROWID',
432: p_log_type IN VARCHAR2 DEFAULT 'LOADER') IS
433: xErrLoc INTEGER := 0; -- execution location for error trapping
434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
436: vRowidTab DBMS_SQL.UROWID_TABLE;
437: vItemIdTab DBMS_SQL.NUMBER_TABLE;
438: vLangTab DBMS_SQL.VARCHAR2_TABLE;
431: pSourceType IN VARCHAR2 DEFAULT 'ROWID',
432: p_log_type IN VARCHAR2 DEFAULT 'LOADER') IS
433: xErrLoc INTEGER := 0; -- execution location for error trapping
434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
436: vRowidTab DBMS_SQL.UROWID_TABLE;
437: vItemIdTab DBMS_SQL.NUMBER_TABLE;
438: vLangTab DBMS_SQL.VARCHAR2_TABLE;
439: c_handle NUMBER ;
447: --Debugging
448: icx_por_ext_utl.debug('start to process populateCtxDescBaseAtt');
449: xErrLoc := 10;
450: IF (pSourceType = 'ROWID') THEN
451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
452: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
453: ElSE
454: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
455: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
448: icx_por_ext_utl.debug('start to process populateCtxDescBaseAtt');
449: xErrLoc := 10;
450: IF (pSourceType = 'ROWID') THEN
451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
452: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
453: ElSE
454: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
455: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
456: END IF;
450: IF (pSourceType = 'ROWID') THEN
451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
452: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
453: ElSE
454: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
455: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
456: END IF;
457:
458: xErrLoc := 15;
451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
452: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
453: ElSE
454: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,
455: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);
456: END IF;
457:
458: xErrLoc := 15;
459: --Debugging
564: pSourceType IN VARCHAR2 DEFAULT 'ROWID',
565: p_log_type IN VARCHAR2 DEFAULT 'LOADER')
566: IS
567: p_lang VARCHAR2(10) := NULL;
568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
570: vCRowidTab DBMS_SQL.UROWID_TABLE;
571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;
572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;
565: p_log_type IN VARCHAR2 DEFAULT 'LOADER')
566: IS
567: p_lang VARCHAR2(10) := NULL;
568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;
570: vCRowidTab DBMS_SQL.UROWID_TABLE;
571: vCLangTab DBMS_SQL.VARCHAR2_TABLE;
572: vCItemIdTab DBMS_SQL.NUMBER_TABLE;
573: c_handle NUMBER;
588:
589: xErrLoc := 110;
590: IF(pSourceType = 'ROWID') THEN
591: xErrLoc := 120;
592: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,
593: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage,
594: vCInsertSqlTab, vCUpdateSqlTab);
595: xErrLoc := 140;
596: ELSE
589: xErrLoc := 110;
590: IF(pSourceType = 'ROWID') THEN
591: xErrLoc := 120;
592: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,
593: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage,
594: vCInsertSqlTab, vCUpdateSqlTab);
595: xErrLoc := 140;
596: ELSE
597: xErrLoc := 160;
594: vCInsertSqlTab, vCUpdateSqlTab);
595: xErrLoc := 140;
596: ELSE
597: xErrLoc := 160;
598: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,
599: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage,
600: vCInsertSqlTab, vCUpdateSqlTab);
601: xErrLoc := 180;
602: END IF;
595: xErrLoc := 140;
596: ELSE
597: xErrLoc := 160;
598: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,
599: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage,
600: vCInsertSqlTab, vCUpdateSqlTab);
601: xErrLoc := 180;
602: END IF;
603: