DBA Data[Home] [Help]

APPS.ICX_POR_CTX_DESC dependencies on ICX_POR_CTX_SQL_PKG

Line 434: vInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;

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;

Line 435: vUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;

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 ;

Line 451: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,

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);

Line 452: ICX_POR_CTX_SQL_PKG.ROWID_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;

Line 454: ICX_POR_CTX_SQL_PKG.build_ctx_sql(0,

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;

Line 455: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage, vInsertSqlTab, vUpdateSqlTab);

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

Line 568: vCInsertSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;

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;

Line 569: vCUpdateSqlTab ICX_POR_CTX_SQL_PKG.SQLTab;

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;

Line 592: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,

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

Line 593: ICX_POR_CTX_SQL_PKG.ROWID_WHERE_CLAUSE, pLanguage,

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;

Line 598: ICX_POR_CTX_SQL_PKG.build_ctx_sql(pCategoryId,

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;

Line 599: ICX_POR_CTX_SQL_PKG.ITEMID_WHERE_CLAUSE, pLanguage,

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: