APPS.ICX_POR_EXT_TEST SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

    '  last_update_date		DATE) ' || xTableTS;

Line: 57

    '  last_update_date	DATE) ' || xTableTS;

Line: 71

    '  last_update_date	DATE) ' || xTableTS;

Line: 85

    '  last_update_date	DATE) ' || xTableTS;

Line: 114

    '  last_update_date		DATE, ' ||
    '  allow_price_override_flag	VARCHAR2(1), ' ||
    '  not_to_exceed_price	NUMBER, ' ||
    '  amount                   NUMBER, ' ||
    '  suggested_quantity       NUMBER) ' || xTableTS;

Line: 151

    '  last_update_date		DATE) ' || xTableTS;

Line: 185

    '  last_update_date		DATE, ' ||
    '  amount		        NUMBER, ' ||
    '  allow_price_override_flag VARCHAR2(1), ' ||
    '  not_to_exceed_price      NUMBER) ' || xTableTS;

Line: 205

    '  last_update_date		DATE) ' || xTableTS;

Line: 222

    '  last_update_date		DATE) ' || xTableTS;

Line: 240

    '  last_update_date		DATE, ' ||
    '  order_type_lookup_code   VARCHAR2(25), '||
    '  purchase_basis		VARCHAR2(30) ) ' || xTableTS;

Line: 257

    '  last_update_date		DATE) ' || xTableTS;

Line: 269

    '  last_update_date		DATE) ' || xTableTS;

Line: 289

    '  last_update_date		DATE) ' || xTableTS;

Line: 302

    '  last_update_date		DATE) ' || xTableTS;

Line: 315

    '  last_update_date		DATE) ' || xTableTS;

Line: 332

    '  last_update_date		DATE) ' || xTableTS;

Line: 357

    '  last_update_date		DATE) ' || xTableTS;

Line: 373

    '  last_update_date		DATE) ' || xTableTS;

Line: 388

    '  last_update_date		DATE) ' || xTableTS;

Line: 410

    '  last_update_date		DATE) ' || xTableTS; -- Bug# 2945205 : pcreddy

Line: 473

  SELECT category_set_id,
         validate_flag,
         structure_id
  INTO   gCategorySetId,
         gValidateFlag,
         gStructureId
  FROM   mtl_default_sets_view
  WHERE  functional_area_id = 2;

Line: 483

  SELECT language_code
  INTO   gBaseLang
  FROM   fnd_languages
  WHERE  installed_flag = 'B';

Line: 659

    'Delete test data from icx_cat_categories_tl');

Line: 662

    SELECT ROWID FROM icx_cat_categories_tl
    WHERE last_updated_by = TEST_USER_ID;

Line: 666

    xRowIds.DELETE;

Line: 675

      DELETE icx_cat_categories_tl
      WHERE  rowid = xRowIds(i);

Line: 685

    'Delete test data from icx_por_category_data_sources');

Line: 689

    SELECT ROWID FROM icx_por_category_data_sources
    WHERE last_updated_by = TEST_USER_ID;

Line: 693

    xRowIds.DELETE;

Line: 702

      DELETE icx_por_category_data_sources
      WHERE  rowid = xRowIds(i);

Line: 712

    'Delete test data from icx_por_category_order_map');

Line: 716

    SELECT ROWID FROM icx_por_category_order_map
    WHERE last_updated_by =  TEST_USER_ID;

Line: 720

    xRowIds.DELETE;

Line: 729

      DELETE icx_por_category_order_map
      WHERE  rowid = xRowIds(i);

Line: 739

    'Delete test data from icx_cat_items_b');

Line: 743

    SELECT ROWID FROM icx_cat_items_b
    WHERE last_updated_by =  TEST_USER_ID;

Line: 747

    xRowIds.DELETE;

Line: 756

      DELETE icx_cat_items_b
      WHERE  rowid = xRowIds(i);

Line: 766

    'Delete test data from icx_cat_items_tlp');

Line: 770

    SELECT ROWID FROM icx_cat_items_tlp
    WHERE last_updated_by =  TEST_USER_ID;

Line: 774

    xRowIds.DELETE;

Line: 783

      DELETE icx_cat_items_tlp
      WHERE  rowid = xRowIds(i);

Line: 793

    'Delete test data from icx_cat_category_items');

Line: 797

    SELECT ROWID FROM icx_cat_category_items
    WHERE last_updated_by =  TEST_USER_ID;

Line: 801

    xRowIds.DELETE;

Line: 810

      DELETE icx_cat_category_items
      WHERE  rowid = xRowIds(i);

Line: 820

    'Delete test data from icx_cat_ext_items_tlp');

Line: 824

    SELECT ROWID FROM icx_cat_ext_items_tlp
    WHERE last_updated_by =  TEST_USER_ID;

Line: 828

    xRowIds.DELETE;

Line: 837

      DELETE icx_cat_ext_items_tlp
      WHERE  rowid = xRowIds(i);

Line: 847

    'Delete test data from icx_cat_item_prices');

Line: 851

    SELECT ROWID FROM icx_cat_item_prices
    WHERE last_updated_by =  TEST_USER_ID;

Line: 855

    xRowIds.DELETE;

Line: 864

      DELETE icx_cat_item_prices
      WHERE  rowid = xRowIds(i);

Line: 938

    'INSERT INTO imtl_categories_kfv( ' ||
    'category_id, ' ||
    'concatenated_segments, ' ||
    'structure_id, ' ||
    'web_status, ' ||
    'start_date_active, ' ||
    'end_date_active, ' ||
    'disable_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':category_id, ' ||
    ':concatenated_segments, ' ||
    ':structure_id, ' ||
    ':web_status, ' ||
    ':start_date_active, ' ||
    ':end_date_active, ' ||
    ':disable_date, ' ||
    'SYSDATE) '
    USING p_category_id, p_concatenated_segments, gStructureId,
          p_web_status, p_start_date_active, p_end_date_active,
          p_disable_date;

Line: 962

    'INSERT INTO imtl_category_set_valid_cats( ' ||
    'category_id, ' ||
    'category_set_id, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':category_id, ' ||
    ':category_set_id, ' ||
    'SYSDATE) '
    USING p_category_id, gCategorySetId;

Line: 974

    'INSERT INTO imtl_categories_tl( ' ||
    'category_id, ' ||
    'description, ' ||
    'language, ' ||
    'source_lang, ' ||
    'last_update_date) ' ||
    'VALUES( '||
    ':category_id, ' ||
    ':description, ' ||
    ':language, ' ||
    ':language, ' ||
    'SYSDATE) '
    USING p_category_id, p_description,
          gBaseLang, gBaseLang;

Line: 1001

PROCEDURE updateCategory(p_category_id			IN NUMBER,
			 p_concatenated_segments	IN VARCHAR2,
			 p_description			IN VARCHAR2,
			 p_web_status			IN VARCHAR2,
			 p_start_date_active		IN DATE,
			 p_end_date_active		IN DATE,
			 p_disable_date			IN DATE)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1015

      'updateCategory(p_category_id: ' || p_category_id ||
      ', p_concatenated_segments: ' || p_concatenated_segments ||
      ', p_description: ' || p_description ||
      ', p_web_status: ' || p_web_status ||
      ', p_start_date_active: ' || p_start_date_active ||
      ', p_end_date_active: ' || p_end_date_active ||
      ', p_disable_date: ' || p_disable_date || ')');

Line: 1026

    'UPDATE imtl_categories_kfv ' ||
    'SET concatenated_segments = DECODE(:concatenated_segments, ' ||
    ':miss_char, concatenated_segments,:concatenated_segments), ' ||
    'web_status = DECODE(:web_status,:miss_char, ' ||
    'web_status,:web_status), ' ||
    'start_date_active = DECODE(:start_date_active,:miss_date, ' ||
    'start_date_active,:start_date_active), ' ||
    'end_date_active = DECODE(:end_date_active,:miss_date, ' ||
    'end_date_active,:end_date_active), ' ||
    'disable_date = DECODE(:disable_date,:miss_date, disable_date, ' ||
    ':disable_date), ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE category_id =:category_id '
    USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
          p_web_status, FND_API.G_MISS_CHAR, p_web_status,
          p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
          p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
          p_disable_date, FND_API.G_MISS_DATE, p_disable_date,
          p_category_id;

Line: 1049

    'UPDATE imtl_categories_tl ' ||
    'SET description = DECODE(:description,:miss_char, ' ||
    'description,:description), ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE category_id =:category_id ' ||
    'AND language =:language '
    USING p_description, FND_API.G_MISS_CHAR, p_description,
          p_category_id, gBaseLang;

Line: 1064

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateCategory-'||
      xErrLoc||' '||SQLERRM);

Line: 1067

END updateCategory;

Line: 1088

    SELECT 1
    INTO   xExist
    FROM   dual
    WHERE  EXISTS (SELECT 'installed language'
                   FROM   fnd_languages
                   WHERE  installed_flag = 'I'
                   AND    language_code = p_language);

Line: 1104

    'INSERT INTO imtl_categories_tl( ' ||
    'category_id, ' ||
    'description, ' ||
    'language, ' ||
    'source_lang, ' ||
    'last_update_date) ' ||
    'SELECT:category_id, ' ||
    ':description, ' ||
    ':language, ' ||
    ':language, ' ||
    'SYSDATE ' ||
    'FROM dual ' ||
    'WHERE NOT EXISTS (SELECT 1 ' ||
    'FROM imtl_categories_tl ' ||
    'WHERE category_id =:category_id ' ||
    'AND language =:language) '
    USING p_category_id, p_description, p_language,
          p_language, p_category_id, p_language;

Line: 1125

    'UPDATE imtl_categories_tl ' ||
    'SET description =:description, ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE category_id =:category_id ' ||
    'AND language =:language '
    USING p_description, p_category_id, p_language;

Line: 1163

    'INSERT INTO ipo_reqexpress_headers_all( ' ||
    'org_id, ' ||
    'express_name, ' ||
    'type_lookup_code, ' ||
    'inactive_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':org_id, ' ||
    ':express_name, ' ||
    ':type_lookup_code, ' ||
    ':inactive_date, ' ||
    'SYSDATE) '
    USING p_org_id, p_express_name,
          p_type_lookup_code, p_inactive_date;

Line: 1190

PROCEDURE updateTemplateHeader(p_org_id		IN NUMBER,
			       p_express_name	IN VARCHAR2,
			       p_inactive_date	IN DATE)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1200

      'updateTemplateHeader(p_org_id: ' || p_org_id ||
      ', p_express_name: ' || p_express_name ||
      ', p_inactive_date: ' || p_inactive_date || ')');

Line: 1207

    'UPDATE ipo_reqexpress_headers_all ' ||
    'SET inactive_date =:inactive_date, ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE org_id =:org_id ' ||
    'AND express_name =:express_name '
    USING p_inactive_date, p_org_id, p_express_name;

Line: 1220

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateTemplateHeader-'||
      xErrLoc||' '||SQLERRM);

Line: 1223

END updateTemplateHeader;

Line: 1237

  SELECT 1
  INTO   xResult
  FROM   icx_cat_categories_tl
  WHERE  key = p_category_key
  AND    category_name = p_category_name
  AND    ROWNUM = 1;

Line: 1248

  SELECT 2
  INTO   xResult
  FROM   icx_por_category_data_sources
  WHERE  category_key = p_category_key
  AND    external_source_key = p_category_key
  AND    ROWNUM = 1;

Line: 1260

    SELECT 3
    INTO   xResult
    FROM   icx_por_category_order_map
    WHERE  external_source_key = p_category_key
    AND    ROWNUM = 1;

Line: 1295

  SELECT 0
  INTO   xResult
  FROM   icx_cat_categories_tl
  WHERE  key = p_category_key
  AND    ROWNUM = 1;

Line: 1328

  SELECT 1
  INTO   xResult
  FROM   icx_cat_categories_tl
  WHERE  key = p_category_key
  AND    category_name = p_category_name
  AND    language = p_language
  AND    ROWNUM = 1;

Line: 1379

    'INSERT INTO igl_sets_of_books( ' ||
    'set_of_books_id, ' ||
    'currency_code) ' ||
    'VALUES( ' ||
    ':set_of_books_id, ' ||
    ':currency_code) '
    USING p_set_of_books_id, p_currency_code;

Line: 1415

    'INSERT INTO ifinancials_system_params_all( ' ||
    'org_id, ' ||
    'inventory_organization_id, ' ||
    'set_of_books_id) ' ||
    'VALUES( ' ||
    ':org_id, ' ||
    ':inventory_organization_id, ' ||
    ':set_of_books_id) '
    USING p_org_id, p_inventory_organization_id, p_set_of_books_id;

Line: 1427

    'INSERT INTO ipo_system_parameters_all( ' ||
    'org_id, ' ||
    'default_rate_type, ' ||
    'last_update_date) ' ||  -- Bug# 2945205 : pcreddy
    'VALUES( ' ||
    ':org_id, ' ||
    '''Corporate'', ' ||
    'SYSDATE) '   -- Bug# 2945205 : pcreddy
    USING p_org_id;

Line: 1487

    'INSERT INTO imtl_system_items_kfv( ' ||
    'inventory_item_id, ' ||
    'organization_id, ' ||
    'concatenated_segments, ' ||
    'purchasing_enabled_flag, ' ||
    'outside_operation_flag, ' ||
    'internal_order_enabled_flag, ' ||
    'list_price_per_unit, ' ||
    'primary_uom_code, ' ||
    'replenish_to_order_flag, ' ||
    'base_item_id, ' ||
    'auto_created_config_flag, ' ||
    'unit_of_issue, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':inventory_item_id, ' ||
    ':organization_id, ' ||
    ':concatenated_segments, ' ||
    ':purchasing_enabled_flag, ' ||
    ':outside_operation_flag, ' ||
    ':internal_order_enabled_flag, ' ||
    ':list_price_per_unit, ' ||
    ':primary_uom_code, ' ||
    ':replenish_to_order_flag, ' ||
    ':base_item_id, ' ||
    ':auto_created_config_flag, ' ||
    ':unit_of_issue, ' ||
    'SYSDATE) '
    USING p_inventory_item_id, p_organization_id,
          p_concatenated_segments, p_purchasing_enabled_flag,
          p_outside_operation_flag, p_internal_order_enabled_flag,
          p_list_price_per_unit, p_primary_uom_code,
          p_replenish_to_order_flag, p_base_item_id,
          p_auto_created_config_flag, p_unit_of_issue;

Line: 1524

    'INSERT INTO imtl_system_items_tl( ' ||
    'inventory_item_id, ' ||
    'organization_id, ' ||
    'description, ' ||
    'language, ' ||
    'source_lang, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':inventory_item_id, ' ||
    ':organization_id, ' ||
    ':description, ' ||
    ':language, ' ||
    ':language, ' ||
    'SYSDATE) '
    USING p_inventory_item_id, p_organization_id,
          p_description, gBaseLang, gBaseLang;

Line: 1543

    'INSERT INTO imtl_item_categories( ' ||
    'inventory_item_id, ' ||
    'organization_id, ' ||
    'category_id, ' ||
    'category_set_id, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':inventory_item_id, ' ||
    ':organization_id, ' ||
    ':category_id, ' ||
    ':category_set_id, ' ||
    'SYSDATE) '
    USING p_inventory_item_id, p_organization_id,
          p_category_id, gCategorySetId;

Line: 1570

PROCEDURE updateItem(p_inventory_item_id		IN NUMBER,
                     p_organization_id			IN NUMBER,
                     p_concatenated_segments		IN VARCHAR2,
		     p_purchasing_enabled_flag		IN VARCHAR2,
		     p_outside_operation_flag		IN VARCHAR2,
		     p_internal_order_enabled_flag	IN VARCHAR2,
		     p_list_price_per_unit		IN NUMBER,
		     p_primary_uom_code			IN VARCHAR2,
		     p_replenish_to_order_flag		IN VARCHAR2,
		     p_base_item_id			IN NUMBER,
		     p_auto_created_config_flag		IN VARCHAR2,
		     p_unit_of_issue			IN VARCHAR2,
		     p_description			IN VARCHAR2,
		     p_category_id			IN NUMBER)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1591

      'updateItem(p_inventory_item_id: ' || p_inventory_item_id ||
      ', p_organization_id: ' || p_organization_id ||
      ', p_concatenated_segments: ' || p_concatenated_segments ||
      ', p_purchasing_enabled_flag: ' || p_purchasing_enabled_flag ||
      ', p_outside_operation_flag: ' || p_outside_operation_flag ||
      ', p_internal_order_enabled_flag: ' || p_internal_order_enabled_flag ||
      ', p_list_price_per_unit: ' || p_list_price_per_unit ||
      ', p_primary_uom_code: ' || p_primary_uom_code ||
      ', p_replenish_to_order_flag: ' || p_replenish_to_order_flag ||
      ', p_base_item_id: ' || p_base_item_id ||
      ', p_auto_created_config_flag: ' || p_auto_created_config_flag ||
      ', p_unit_of_issue: ' || p_unit_of_issue ||
      ', p_description: ' || p_description ||
      ', p_category_id: ' || p_category_id || ')');

Line: 1609

    'UPDATE imtl_system_items_kfv SET ' ||
    'concatenated_segments = DECODE(:concatenated_segments, '||
    ':miss_char, concatenated_segments,:concatenated_segments), '||
    'purchasing_enabled_flag = DECODE(:purchasing_enabled_flag, '||
    ':miss_char, purchasing_enabled_flag,:purchasing_enabled_flag), '||
    'outside_operation_flag = DECODE(:outside_operation_flag, ' ||
    ':miss_char, outside_operation_flag,:outside_operation_flag), '||
    'internal_order_enabled_flag = DECODE(:internal_order_enabled_flag, '||
    ':miss_char, internal_order_enabled_flag,:internal_order_enabled_flag), '||
    'list_price_per_unit = DECODE(:list_price_per_unit, '||
    ':miss_num, list_price_per_unit,:list_price_per_unit), '||
    'primary_uom_code = DECODE(:primary_uom_code, '||
    ':miss_char, primary_uom_code,:primary_uom_code), '||
    'replenish_to_order_flag = DECODE(:replenish_to_order_flag, '||
    ':miss_char, replenish_to_order_flag,:replenish_to_order_flag), '||
    'base_item_id = DECODE(:base_item_id, '||
    ':miss_num, base_item_id,:base_item_id), '||
    'auto_created_config_flag = DECODE(:auto_created_config_flag, '||
    ':miss_char, auto_created_config_flag,:auto_created_config_flag), '||
    'unit_of_issue = DECODE(:unit_of_issue, '||
    ':miss_char, unit_of_issue,:unit_of_issue), '||
    'last_update_date = SYSDATE ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_concatenated_segments, FND_API.G_MISS_CHAR, p_concatenated_segments,
          p_purchasing_enabled_flag, FND_API.G_MISS_CHAR, p_purchasing_enabled_flag,
          p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
          p_internal_order_enabled_flag, FND_API.G_MISS_CHAR, p_internal_order_enabled_flag,
          p_list_price_per_unit, FND_API.G_MISS_NUM, p_list_price_per_unit,
          p_primary_uom_code, FND_API.G_MISS_CHAR, p_primary_uom_code,
          p_replenish_to_order_flag, FND_API.G_MISS_CHAR, p_replenish_to_order_flag,
          p_base_item_id, FND_API.G_MISS_NUM, p_base_item_id,
          p_auto_created_config_flag, FND_API.G_MISS_CHAR, p_auto_created_config_flag,
          p_unit_of_issue, FND_API.G_MISS_CHAR, p_unit_of_issue,
          p_inventory_item_id, p_organization_id;

Line: 1647

    'UPDATE imtl_system_items_tl SET ' ||
    'description = DECODE(:description, '||
    ':miss_char, description,:description), '||
    'last_update_date = SYSDATE ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_description, FND_API.G_MISS_CHAR, p_description,
          p_inventory_item_id, p_organization_id;

Line: 1658

    'UPDATE imtl_item_categories SET ' ||
    'category_id = DECODE(:category_id, '||
    ':miss_num, category_id,:category_id), '||
    'last_update_date = SYSDATE ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_category_id, FND_API.G_MISS_NUM, p_category_id,
          p_inventory_item_id, p_organization_id;

Line: 1673

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateItem-'||
      xErrLoc||' '||SQLERRM);

Line: 1676

END updateItem;

Line: 1699

    SELECT 1
    INTO   xExist
    FROM   dual
    WHERE  EXISTS (SELECT 'installed language'
                   FROM   fnd_languages
                   WHERE  installed_flag = 'I'
                   AND    language_code = p_language);

Line: 1715

    'INSERT INTO imtl_system_items_tl( ' ||
    'inventory_item_id, ' ||
    'organization_id, ' ||
    'description, ' ||
    'language, ' ||
    'source_lang, ' ||
    'last_update_date) ' ||
    'SELECT:inventory_item_id, ' ||
    ':organization_id, ' ||
    ':description, ' ||
    ':language, ' ||
    ':language, ' ||
    'SYSDATE ' ||
    'FROM dual ' ||
    'WHERE NOT EXISTS (SELECT 1 ' ||
    'FROM imtl_system_items_tl ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id ' ||
    'AND language =:language) '
    USING p_inventory_item_id, p_organization_id,
          p_description, p_language, p_language,
          p_inventory_item_id, p_organization_id,
          p_language;

Line: 1741

    'UPDATE imtl_system_items_tl ' ||
    'SET description =:description, ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id ' ||
    'AND language =:language '
    USING p_description, p_inventory_item_id,
          p_organization_id, p_language;

Line: 1762

PROCEDURE deleteItem(p_inventory_item_id		IN NUMBER,
                     p_organization_id			IN NUMBER)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1771

      'deleteItem(p_inventory_item_id: ' || p_inventory_item_id ||
      ', p_organization_id: ' || p_organization_id || ')');

Line: 1777

    'DELETE FROM imtl_system_items_kfv ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_inventory_item_id, p_organization_id;

Line: 1784

    'DELETE FROM imtl_system_items_tl ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_inventory_item_id, p_organization_id;

Line: 1791

    'DELETE FROM imtl_item_categories ' ||
    'WHERE inventory_item_id =:inventory_item_id ' ||
    'AND organization_id =:organization_id '
    USING p_inventory_item_id, p_organization_id;

Line: 1802

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.deleteItem-'||
      xErrLoc||' '||SQLERRM);

Line: 1805

END deleteItem;

Line: 1823

    'INSERT INTO ipo_vendors( ' ||
    'vendor_id, ' ||
    'vendor_name, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':vendor_id, ' ||
    ':vendor_name, ' ||
    'SYSDATE) '
    USING p_vendor_id, p_vendor_name;

Line: 1844

PROCEDURE updateVendor(p_vendor_id	IN NUMBER,
                       p_vendor_name	IN VARCHAR2)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1853

      'updateVendor(p_vendor_id: ' || p_vendor_id ||
      ', p_vendor_name: ' || p_vendor_name || ')');

Line: 1859

    'UPDATE ipo_vendors ' ||
    'SET vendor_name =:vendor_name, ' ||
    'last_update_date = SYSDATE ' ||
    'WHERE vendor_id =:vendor_id '
    USING p_vendor_name, p_vendor_id;

Line: 1871

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateVendor-'||
      xErrLoc||' '||SQLERRM);

Line: 1874

END updateVendor;

Line: 1894

    'INSERT INTO ipo_vendor_sites_all( ' ||
    'vendor_site_id, ' ||
    'vendor_site_code, ' ||
    'purchasing_site_flag, ' ||
    'inactive_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':vendor_site_id, ' ||
    ':vendor_site_code, ' ||
    ':purchasing_site_flag, ' ||
    'NULL, ' ||
    'SYSDATE) '
    USING p_vendor_site_id, p_vendor_site_code, p_purchasing_site_flag;

Line: 1919

PROCEDURE updateVendorSite(p_vendor_site_id		IN NUMBER,
                           p_purchasing_site_flag	IN VARCHAR2,
                           p_inactive_date		IN DATE)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 1936

    'UPDATE ipo_vendor_sites_all SET ' ||
    'purchasing_site_flag = DECODE(:purchasing_site_flag, '||
    ':miss_char, purchasing_site_flag,:purchasing_site_flag), '||
    'inactive_date = DECODE(:inactive_date, '||
    ':miss_date, inactive_date,:inactive_date), '||
    'last_update_date = SYSDATE ' ||
    'WHERE vendor_site_id =:vendor_site_id '
    USING p_purchasing_site_flag, FND_API.G_MISS_CHAR, p_purchasing_site_flag,
          p_inactive_date, FND_API.G_MISS_DATE, p_inactive_date,
          p_vendor_site_id;

Line: 1952

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateVendorSite-'||
      xErrLoc||' '||SQLERRM);

Line: 1955

END updateVendorSite;

Line: 1991

    'INSERT INTO ipo_approved_supplier_list( ' ||
    'asl_id, ' ||
    'asl_status_id, ' ||
    'owning_organization_id, ' ||
    'item_id, ' ||
    'category_id, ' ||
    'vendor_id, ' ||
    'vendor_site_id, ' ||
    'primary_vendor_item, ' ||
    'disable_flag, ' ||
    'creation_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':asl_id, ' ||
    ':asl_status_id, ' ||
    ':owning_organization_id, ' ||
    ':item_id, ' ||
    ':category_id, ' ||
    ':vendor_id, ' ||
    ':vendor_site_id, ' ||
    ':primary_vendor_item, ' ||
    ':disable_flag, ' ||
    'SYSDATE, ' ||
    'SYSDATE) '
    USING p_asl_id, p_asl_status_id,
          p_owning_organization_id, p_item_id,
          p_category_id, p_vendor_id, p_vendor_site_id,
	  p_primary_vendor_item, p_disable_flag;

Line: 2022

    'INSERT INTO ipo_asl_status_rules( ' ||
    'status_id, ' ||
    'business_rule, ' ||
    'allow_action_flag, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':status_id, ' ||
    '''2_SOURCING'', ' ||
    ':allow_action_flag, ' ||
    'SYSDATE) '
    USING p_asl_status_id, p_allow_action_flag;

Line: 2036

    'INSERT INTO ipo_asl_attributes( ' ||
    'asl_id, ' ||
    'purchasing_unit_of_measure, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':asl_id, ' ||
    ':purchasing_unit_of_measure, ' ||
    'SYSDATE) '
    USING p_asl_id, p_purchasing_unit_of_measure;

Line: 2058

PROCEDURE updateASL(p_asl_id				IN NUMBER,
                    p_asl_status_id			IN NUMBER,
		    p_vendor_site_id			IN NUMBER,
		    p_primary_vendor_item		IN VARCHAR2,
		    p_disable_flag			IN VARCHAR2,
		    p_allow_action_flag			IN VARCHAR2,
		    p_purchasing_unit_of_measure	IN VARCHAR2)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 2072

      'updateASL(p_asl_id: ' || p_asl_id ||
      ', p_asl_status_id: ' || p_asl_status_id ||
      ', p_vendor_site_id: ' || p_vendor_site_id ||
      ', p_primary_vendor_item: ' || p_primary_vendor_item ||
      ', p_disable_flag: ' || p_disable_flag ||
      ', p_allow_action_flag: ' || p_allow_action_flag ||
      ', p_purchasing_unit_of_measure: ' || p_purchasing_unit_of_measure || ')');

Line: 2083

    'UPDATE ipo_approved_supplier_list SET ' ||
    'vendor_site_id = DECODE(:vendor_site_id, '||
    ':miss_num, vendor_site_id,:vendor_site_id), '||
    'primary_vendor_item = DECODE(:primary_vendor_item, '||
    ':miss_char, primary_vendor_item,:primary_vendor_item), '||
    'disable_flag = DECODE(:disable_flag, '||
    ':miss_char, disable_flag,:disable_flag), '||
    'last_update_date = SYSDATE ' ||
    'WHERE asl_id =:asl_id '
    USING p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
          p_primary_vendor_item, FND_API.G_MISS_CHAR, p_primary_vendor_item,
          p_disable_flag, FND_API.G_MISS_CHAR, p_disable_flag,
          p_asl_id;

Line: 2099

    'UPDATE ipo_asl_status_rules SET ' ||
    'allow_action_flag = DECODE(:allow_action_flag, '||
    ':miss_char, allow_action_flag,:allow_action_flag), '||
    'last_update_date = SYSDATE ' ||
    'WHERE status_id =:status_id '
    USING p_allow_action_flag, FND_API.G_MISS_CHAR, p_allow_action_flag,
          p_asl_status_id;

Line: 2109

    'UPDATE ipo_asl_attributes SET ' ||
    'purchasing_unit_of_measure = DECODE(:purchasing_unit_of_measure, '||
    ':miss_char, purchasing_unit_of_measure,:purchasing_unit_of_measure), '||
    'last_update_date = SYSDATE ' ||
    'WHERE asl_id =:asl_id '
    USING p_purchasing_unit_of_measure, FND_API.G_MISS_CHAR,
          p_purchasing_unit_of_measure, p_asl_id;

Line: 2123

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateASL-'||
      xErrLoc||' '||SQLERRM);

Line: 2126

END updateASL;

Line: 2168

    'INSERT INTO ipo_reqexpress_lines_all( ' ||
    'org_id, ' ||
    'express_name, ' ||
    'sequence_num, ' ||
    'source_type_code, ' ||
    'po_header_id, ' ||
    'po_line_id, ' ||
    'item_id, ' ||
    'category_id, ' ||
    'item_description, ' ||
    'unit_price, ' ||
    'unit_meas_lookup_code, ' ||
    'suggested_vendor_id, ' ||
    'suggested_vendor_site_id, ' ||
    'suggested_vendor_product_code, ' ||
    'creation_date, ' ||
    'last_update_date) '||
    'VALUES( ' ||
    ':org_id, ' ||
    ':express_name, ' ||
    ':sequence_num, ' ||
    ':source_type_code, ' ||
    ':po_header_id, ' ||
    ':po_line_id, ' ||
    ':item_id, ' ||
    ':category_id, ' ||
    ':item_description, ' ||
    ':unit_price, ' ||
    ':unit_meas_lookup_code, ' ||
    ':suggested_vendor_id, ' ||
    ':suggested_vendor_site_id, ' ||
    ':suggested_vendor_product_code, ' ||
    'SYSDATE, ' ||
    'SYSDATE) '
    USING p_org_id, p_express_name,
	  p_sequence_num, p_source_type_code,
	  p_po_header_id, p_po_line_id,
	  p_item_id, p_category_id,
	  p_item_description, p_unit_price,
	  p_unit_meas_lookup_code,
	  p_suggested_vendor_id,
	  p_suggested_vendor_site_id,
	  p_vendor_product_code;

Line: 2267

    'INSERT INTO ipo_reqexpress_lines_all( ' ||
    'org_id, ' ||
    'express_name, ' ||
    'sequence_num, ' ||
    'source_type_code, ' ||
    'po_header_id, ' ||
    'po_line_id, ' ||
    'item_id, ' ||
    'category_id, ' ||
    'item_description, ' ||
    'unit_price, ' ||
    'suggested_quantity, ' ||
    'unit_meas_lookup_code, ' ||
    'suggested_vendor_id, ' ||
    'suggested_vendor_site_id, ' ||
    'suggested_vendor_product_code, ' ||
    'creation_date, ' ||
    'last_update_date) '||
    'VALUES( ' ||
   ':org_id, ' ||
    ':express_name, ' ||
    ':sequence_num, ' ||
    ':source_type_code, ' ||
    ':po_header_id, ' ||
    ':po_line_id, ' ||
    ':item_id, ' ||
    ':category_id, ' ||
    ':item_description, ' ||
    ':unit_price, ' ||
    ':suggested_quantity, ' ||
    ':unit_meas_lookup_code, ' ||
    ':suggested_vendor_id, ' ||
    ':suggested_vendor_site_id, ' ||
    ':suggested_vendor_product_code, ' ||
    'SYSDATE, ' ||
    'SYSDATE) '
    USING p_org_id, p_express_name,
          p_sequence_num, p_source_type_code,
          p_po_header_id, p_po_line_id,
          p_item_id, p_category_id,
          p_item_description, p_unit_price,
          p_suggested_quantity,
          p_unit_meas_lookup_code,
          p_suggested_vendor_id,
          p_suggested_vendor_site_id,
          p_vendor_product_code;

Line: 2326

PROCEDURE updateTemplateLine(p_org_id			IN NUMBER,
			     p_express_name		IN VARCHAR2,
			     p_sequence_num		IN NUMBER,
			     p_po_header_id		IN NUMBER,
			     p_po_line_id		IN NUMBER,
			     p_item_description		IN VARCHAR2,
			     p_unit_price		IN NUMBER,
                             -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project.
                             p_suggested_quantity       IN NUMBER,
			     p_unit_meas_lookup_code	IN VARCHAR2,
			     p_suggested_vendor_site_id	IN NUMBER,
			     p_vendor_product_code 	IN VARCHAR2)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 2345

      'updateTemplateLine(p_org_id: ' || p_org_id ||
      ', p_express_name: ' || p_express_name ||
      ', p_sequence_num: ' || p_sequence_num ||
      ', p_po_header_id: ' || p_po_header_id ||
      ', p_po_line_id: ' || p_po_line_id ||
      ', p_item_description: ' || p_item_description ||
      ', p_unit_price: ' || p_unit_price ||
      -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
      ', p_suggested_quantity: ' || p_suggested_quantity ||
      ', p_unit_meas_lookup_code: ' || p_unit_meas_lookup_code ||
      ', p_suggested_vendor_site_id: ' || p_suggested_vendor_site_id ||
      ', p_vendor_product_code: ' || p_vendor_product_code || ')');

Line: 2361

    'UPDATE ipo_reqexpress_lines_all SET ' ||
    'po_header_id = DECODE(:po_header_id, '||
    ':miss_num, po_header_id,:po_header_id), '||
    'po_line_id = DECODE(:po_line_id, '||
    ':miss_num, po_line_id,:po_line_id), '||
    'item_description = DECODE(:item_description, '||
    ':miss_char, item_description,:item_description), '||
    'unit_price = DECODE(:unit_price, '||
    ':miss_num, unit_price,:unit_price), '||
    -- FPJ Bug# 3007068 sosingha: Extractor Changes For Kit Support Project
    'suggested_quantity = DECODE(:suggested_quantity, '||
    ':miss_num, suggested_quantity,:suggested_quantity), '||
    'unit_meas_lookup_code = DECODE(:unit_meas_lookup_code, '||
    ':miss_char, unit_meas_lookup_code,:unit_meas_lookup_code), '||
    'suggested_vendor_site_id = DECODE(:suggested_vendor_site_id, '||
    ':miss_num, suggested_vendor_site_id,:suggested_vendor_site_id), '||
    'suggested_vendor_product_code = DECODE(:suggested_vendor_product_code, '||
    ':miss_char, suggested_vendor_product_code,:suggested_vendor_product_code), '||
    'last_update_date = SYSDATE ' ||
    'WHERE org_id =:org_id ' ||
    'AND express_name =:express_name ' ||
    'AND sequence_num =:sequence_num '
    USING p_po_header_id, FND_API.G_MISS_NUM, p_po_header_id,
          p_po_line_id, FND_API.G_MISS_NUM, p_po_line_id,
          p_item_description, FND_API.G_MISS_CHAR, p_item_description,
          p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
          -- FPJ Bug# 3007068 sosingha: Extractor Changes for Kit Support project
          p_suggested_quantity, FND_API.G_MISS_NUM, p_suggested_quantity,
          p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
          p_suggested_vendor_site_id, FND_API.G_MISS_NUM, p_suggested_vendor_site_id,
          p_vendor_product_code, FND_API.G_MISS_CHAR, p_vendor_product_code,
          p_org_id, p_express_name, p_sequence_num;

Line: 2400

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateTemplateLine-'||
      xErrLoc||' '||SQLERRM);

Line: 2403

END updateTemplateLine;

Line: 2455

    'INSERT INTO ipo_headers_all( ' ||
    'po_header_id, ' ||
    'org_id, ' ||
    'segment1, ' ||
    'type_lookup_code, ' ||
    'rate, ' ||
    'currency_code, ' ||
    'vendor_id, ' ||
    'vendor_site_id, ' ||
    'approved_date, ' ||
    'approved_flag, ' ||
    'approval_required_flag, ' ||
    'cancel_flag, ' ||
    'frozen_flag, ' ||
    'closed_code, ' ||
    'status_lookup_code, ' ||
    'quotation_class_code, ' ||
    'start_date, ' ||
    'end_date, ' ||
    'global_agreement_flag, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':po_header_id, ' ||
    ':org_id, ' ||
    ':segment1, ' ||
    ':type_lookup_code, ' ||
    ':rate, ' ||
    ':currency_code, ' ||
    ':vendor_id, ' ||
    ':vendor_site_id, ' ||
    ':approved_date, ' ||
    ':approved_flag, ' ||
    ':approval_required_flag, ' ||
    ':cancel_flag, ' ||
    ':frozen_flag, ' ||
    ':closed_code, ' ||
    ':status_lookup_code, ' ||
    ':quotation_class_code, ' ||
    ':start_date, ' ||
    ':end_date, ' ||
    ':global_agreement_flag, ' ||
    'SYSDATE) '
    USING p_po_header_id, p_org_id, p_segment1,
          p_type_lookup_code, p_rate, p_currency_code,
          p_vendor_id, p_vendor_site_id,
          p_approved_date, p_approved_flag,
          p_approval_required_flag, p_cancel_flag,
          p_frozen_flag, p_closed_code,
          p_status_lookup_code, p_quotation_class_code,
          p_start_date, p_end_date,
          p_global_agreement_flag;

Line: 2564

    'INSERT INTO ipo_lines_all( ' ||
    'po_header_id, ' ||
    'po_line_id, ' ||
    'org_id, ' ||
    'line_num, ' ||
    'item_id, ' ||
    'item_description, ' ||
    'vendor_product_num, ' ||
    'line_type_id, ' ||
    'category_id, ' ||
    'unit_price, ' ||
    'unit_meas_lookup_code, ' ||
    'attribute13, ' ||
    'attribute14, ' ||
    'cancel_flag, ' ||
    'closed_code, ' ||
    'expiration_date, ' ||
    'creation_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':po_header_id, ' ||
    ':po_line_id, ' ||
    ':org_id, ' ||
    ':line_num, ' ||
    ':item_id, ' ||
    ':item_description, ' ||
    ':vendor_product_num, ' ||
    ':line_type_id, ' ||
    ':category_id, ' ||
    ':unit_price, ' ||
    ':unit_meas_lookup_code, ' ||
    ':attribute13, ' ||
    ':attribute14, ' ||
    ':cancel_flag, ' ||
    ':closed_code, ' ||
    ':expiration_date, ' ||
    'SYSDATE, ' ||
    'SYSDATE) '
    USING p_po_header_id, p_po_line_id, p_org_id,
          p_line_num, p_item_id, p_item_description,
          p_vendor_product_num, p_line_type_id,
          p_category_id, p_unit_price,
          p_unit_meas_lookup_code, p_attribute13,
          p_attribute14, p_cancel_flag,
          p_closed_code, p_expiration_date;

Line: 2612

    'INSERT INTO ipo_line_types_b( ' ||
    'line_type_id, ' ||
    'outside_operation_flag, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':line_type_id, ' ||
    ':outside_operation_flag, ' ||
    'SYSDATE) '
    USING p_line_type_id, p_outside_operation_flag;

Line: 2692

    'INSERT INTO ipo_lines_all( ' ||
    'po_header_id, ' ||
    'po_line_id, ' ||
    'org_id, ' ||
    'line_num, ' ||
    'item_id, ' ||
    'item_description, ' ||
    'vendor_product_num, ' ||
    'line_type_id, ' ||
    'category_id, ' ||
    'unit_price, ' ||
    'unit_meas_lookup_code, ' ||
    'attribute13, ' ||
    'attribute14, ' ||
    'cancel_flag, ' ||
    'closed_code, ' ||
    'expiration_date, ' ||
    'creation_date, ' ||
    'last_update_date, ' ||
    'amount, ' ||
    'allow_price_override_flag, ' ||
    'not_to_exceed_price) ' ||
    'VALUES( ' ||
    ':po_header_id, ' ||
    ':po_line_id, ' ||
    ':org_id, ' ||
    ':line_num, ' ||
    ':item_id, ' ||
    ':item_description, ' ||
    ':vendor_product_num, ' ||
    ':line_type_id, ' ||
    ':category_id, ' ||
    ':unit_price, ' ||
    ':unit_meas_lookup_code, ' ||
    ':attribute13, ' ||
    ':attribute14, ' ||
    ':cancel_flag, ' ||
    ':closed_code, ' ||
    ':expiration_date, ' ||
    'SYSDATE, ' ||
    'SYSDATE, ' ||
    ':amount, ' ||
    ':allow_price_override_flag, ' ||
    ':not_to_exceed_price) '
    USING p_po_header_id, p_po_line_id, p_org_id,
          p_line_num, p_item_id, p_item_description,
          p_vendor_product_num, p_line_type_id,
          p_category_id, p_unit_price,
          p_unit_meas_lookup_code, p_attribute13,
          p_attribute14, p_cancel_flag,
          p_closed_code, p_expiration_date,
          p_amount, p_allow_price_override_flag, p_not_to_exceed_price;

Line: 2747

    'INSERT INTO ipo_line_types_b( ' ||
    'line_type_id, ' ||
    'outside_operation_flag, ' ||
    'last_update_date, ' ||
    'order_type_lookup_code, ' ||
    'purchase_basis) ' ||
    'VALUES( ' ||
    ':line_type_id, ' ||
    ':outside_operation_flag, ' ||
    'SYSDATE, ' ||
    ':order_type_lookup_code, ' ||
    ':purchase_basis ) '
    USING p_line_type_id, p_outside_operation_flag,
          p_value_basis, p_purchase_basis;

Line: 2774

PROCEDURE updateContractHeader(p_po_header_id		IN NUMBER,
			       p_rate			IN NUMBER,
			       p_currency_code		IN VARCHAR2,
			       p_vendor_site_id		IN NUMBER,
			       p_approved_date		IN DATE,
			       p_approved_flag		IN VARCHAR2,
			       p_approval_required_flag	IN VARCHAR2,
			       p_cancel_flag		IN VARCHAR2,
			       p_frozen_flag		IN VARCHAR2,
			       p_closed_code		IN VARCHAR2,
			       p_start_date		IN DATE,
			       p_end_date		IN DATE,
			       p_global_agreement_flag	IN VARCHAR2)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 2794

      'updateContractHeader(p_po_header_id: ' || p_po_header_id ||
      ', p_rate: ' || p_rate ||
      ', p_currency_code: ' || p_currency_code ||
      ', p_vendor_site_id: ' || p_vendor_site_id ||
      ', p_approved_date: ' || p_approved_date ||
      ', p_approved_flag: ' || p_approved_flag ||
      ', p_approval_required_flag: ' || p_approval_required_flag ||
      ', p_cancel_flag: ' || p_cancel_flag ||
      ', p_frozen_flag: ' || p_frozen_flag ||
      ', p_closed_code: ' || p_closed_code ||
      ', p_start_date: ' || p_start_date ||
      ', p_end_date: ' || p_end_date ||
      ', p_global_agreement_flag: ' || p_global_agreement_flag || ')');

Line: 2811

    'UPDATE ipo_headers_all SET ' ||
    'rate = DECODE(:rate, '||
    ':miss_num, rate,:rate), '||
    'currency_code = DECODE(:currency_code, '||
    ':miss_char, currency_code,:currency_code), '||
    'vendor_site_id = DECODE(:vendor_site_id, '||
    ':miss_num, vendor_site_id,:vendor_site_id), '||
    'approved_date = DECODE(:approved_date, '||
    ':miss_date, approved_date,:approved_date), '||
    'approved_flag = DECODE(:approved_flag, '||
    ':miss_char, approved_flag,:approved_flag), '||
    'approval_required_flag = DECODE(:approval_required_flag, '||
    ':miss_char, approval_required_flag,:approval_required_flag), '||
    'cancel_flag = DECODE(:cancel_flag, '||
    ':miss_char, cancel_flag,:cancel_flag), '||
    'frozen_flag = DECODE(:frozen_flag, '||
    ':miss_char, frozen_flag,:frozen_flag), '||
    'closed_code = DECODE(:closed_code, '||
    ':miss_char, closed_code,:closed_code), '||
    'start_date = DECODE(:start_date, '||
    ':miss_date, start_date,:start_date), '||
    'end_date = DECODE(:end_date, '||
    ':miss_date, end_date,:end_date), '||
    'global_agreement_flag = DECODE(:global_agreement_flag, '||
    ':miss_char, global_agreement_flag,:global_agreement_flag), '||
    'last_update_date = SYSDATE ' ||
    'WHERE po_header_id =:po_header_id '
    USING p_rate, FND_API.G_MISS_NUM, p_rate,
          p_currency_code, FND_API.G_MISS_CHAR, p_currency_code,
          p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
          p_approved_date, FND_API.G_MISS_DATE, p_approved_date,
          p_approved_flag, FND_API.G_MISS_CHAR, p_approved_flag,
          p_approval_required_flag, FND_API.G_MISS_CHAR, p_approval_required_flag,
          p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
          p_frozen_flag, FND_API.G_MISS_CHAR, p_frozen_flag,
          p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
          p_start_date, FND_API.G_MISS_DATE, p_start_date,
          p_end_date, FND_API.G_MISS_DATE, p_end_date,
          p_global_agreement_flag, FND_API.G_MISS_CHAR, p_global_agreement_flag,
          p_po_header_id;

Line: 2858

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateContractHeader-'||
      xErrLoc||' '||SQLERRM);

Line: 2861

END updateContractHeader;

Line: 2864

PROCEDURE updateContractLine(p_po_line_id		IN NUMBER,
			     p_item_description		IN VARCHAR2,
			     p_vendor_product_num	IN VARCHAR2,
			     p_line_type_id		IN NUMBER,
			     p_category_id		IN NUMBER,
			     p_unit_price		IN NUMBER,
			     p_unit_meas_lookup_code	IN VARCHAR2,
			     p_attribute13		IN VARCHAR2,
			     p_attribute14		IN VARCHAR2,
			     p_cancel_flag 		IN VARCHAR2,
			     p_closed_code		IN VARCHAR2,
			     p_creation_date		IN DATE,
			     p_expiration_date		IN DATE,
			     p_outside_operation_flag	IN VARCHAR2)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 2885

      'updateContractLine(p_po_line_id: ' || p_po_line_id ||
      ', p_item_description: ' || p_item_description ||
      ', p_vendor_product_num: ' || p_vendor_product_num ||
      ', p_line_type_id: ' || p_line_type_id ||
      ', p_unit_price: ' || p_unit_price ||
      ', p_unit_meas_lookup_code: ' || p_unit_meas_lookup_code ||
      ', p_attribute13: ' || p_attribute13 ||
      ', p_attribute14: ' || p_attribute14 ||
      ', p_cancel_flag: ' || p_cancel_flag ||
      ', p_closed_code: ' || p_closed_code ||
      ', p_creation_date: ' || p_creation_date ||
      ', p_expiration_date: ' || p_expiration_date ||
      ', p_outside_operation_flag: ' || p_outside_operation_flag || ')');

Line: 2902

    'UPDATE ipo_lines_all SET ' ||
    'item_description = DECODE(:item_description, '||
    ':miss_char, item_description,:item_description), '||
    'vendor_product_num = DECODE(:vendor_product_num, '||
    ':miss_char, vendor_product_num,:vendor_product_num), '||
    'unit_price = DECODE(:unit_price, '||
    ':miss_num, unit_price,:unit_price), '||
    'unit_meas_lookup_code = DECODE(:unit_meas_lookup_code, '||
    ':miss_char, unit_meas_lookup_code,:unit_meas_lookup_code), '||
    'attribute13 = DECODE(:attribute13, '||
    ':miss_char, attribute13,:attribute13), '||
    'attribute14 = DECODE(:attribute14, '||
    ':miss_char, attribute14,:attribute14), '||
    'cancel_flag = DECODE(:cancel_flag, '||
    ':miss_char, cancel_flag,:cancel_flag), '||
    'closed_code = DECODE(:closed_code, '||
    ':miss_char, closed_code,:closed_code), '||
    'expiration_date = DECODE(:expiration_date, '||
    ':miss_date, expiration_date,:expiration_date), '||
    'last_update_date = SYSDATE ' ||
    'WHERE po_line_id =:po_line_id '
    USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
          p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
          p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
          p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
          p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
          p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
          p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
          p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
          p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
          p_po_line_id;

Line: 2936

    'UPDATE ipo_line_types_b SET ' ||
    'outside_operation_flag = DECODE(:outside_operation_flag, '||
    ':miss_char, outside_operation_flag,:outside_operation_flag), '||
    'last_update_date = SYSDATE ' ||
    'WHERE line_type_id =:line_type_id '
    USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
          p_line_type_id;

Line: 2950

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateContractLine-'||
      xErrLoc||' '||SQLERRM);

Line: 2953

END updateContractLine;

Line: 2958

PROCEDURE updateContractLine(p_po_line_id		IN NUMBER,
			     p_item_description		IN VARCHAR2,
			     p_vendor_product_num	IN VARCHAR2,
			     p_line_type_id		IN NUMBER,
			     p_category_id		IN NUMBER,
			     p_unit_price		IN NUMBER,
			     p_unit_meas_lookup_code	IN VARCHAR2,
			     p_attribute13		IN VARCHAR2,
			     p_attribute14		IN VARCHAR2,
			     p_cancel_flag 		IN VARCHAR2,
			     p_closed_code		IN VARCHAR2,
			     p_creation_date		IN DATE,
			     p_expiration_date		IN DATE,
			     p_outside_operation_flag	IN VARCHAR2,
			     p_amount    		IN NUMBER,
			     p_allow_price_override_flag	IN VARCHAR2,
			     p_not_to_exceed_price	IN NUMBER)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 2982

      'updateContractLine(p_po_line_id: ' || p_po_line_id ||
      ', p_item_description: ' || p_item_description ||
      ', p_vendor_product_num: ' || p_vendor_product_num ||
      ', p_line_type_id: ' || p_line_type_id ||
      ', p_unit_price: ' || p_unit_price ||
      ', p_unit_meas_lookup_code: ' || p_unit_meas_lookup_code ||
      ', p_attribute13: ' || p_attribute13 ||
      ', p_attribute14: ' || p_attribute14 ||
      ', p_cancel_flag: ' || p_cancel_flag ||
      ', p_closed_code: ' || p_closed_code ||
      ', p_creation_date: ' || p_creation_date ||
      ', p_expiration_date: ' || p_expiration_date ||
      ', p_outside_operation_flag: ' || p_outside_operation_flag ||
      ', p_amount: ' || p_amount ||
      ', p_allow_price_override_flag: ' || p_allow_price_override_flag ||
      ', p_not_to_exceed_price: ' || p_not_to_exceed_price || ')');

Line: 3002

    'UPDATE ipo_lines_all SET ' ||
    'item_description = DECODE(:item_description, '||
    ':miss_char, item_description,:item_description), '||
    'vendor_product_num = DECODE(:vendor_product_num, '||
    ':miss_char, vendor_product_num,:vendor_product_num), '||
    'unit_price = DECODE(:unit_price, '||
    ':miss_num, unit_price,:unit_price), '||
    'unit_meas_lookup_code = DECODE(:unit_meas_lookup_code, '||
    ':miss_char, unit_meas_lookup_code,:unit_meas_lookup_code), '||
    'attribute13 = DECODE(:attribute13, '||
    ':miss_char, attribute13,:attribute13), '||
    'attribute14 = DECODE(:attribute14, '||
    ':miss_char, attribute14,:attribute14), '||
    'cancel_flag = DECODE(:cancel_flag, '||
    ':miss_char, cancel_flag,:cancel_flag), '||
    'closed_code = DECODE(:closed_code, '||
    ':miss_char, closed_code,:closed_code), '||
    'expiration_date = DECODE(:expiration_date, '||
    ':miss_date, expiration_date,:expiration_date), '||
    'amount = DECODE(:amount, '||
    ':miss_num, amount,:amount), '||
    'allow_price_override_flag = DECODE(:allow_price_override_flag, '||
    ':miss_char, allow_price_override_flag,:allow_price_override_flag), '||
    'not_to_exceed_price = DECODE(:not_to_exceed_price, '||
    ':miss_num, not_to_exceed_price,:not_to_exceed_price), '||
    'last_update_date = SYSDATE ' ||
    'WHERE po_line_id =:po_line_id '
    USING p_item_description, FND_API.G_MISS_CHAR, p_item_description,
          p_vendor_product_num, FND_API.G_MISS_CHAR, p_vendor_product_num,
          p_unit_price, FND_API.G_MISS_NUM, p_unit_price,
          p_unit_meas_lookup_code, FND_API.G_MISS_CHAR, p_unit_meas_lookup_code,
          p_attribute13, FND_API.G_MISS_CHAR, p_attribute13,
          p_attribute14, FND_API.G_MISS_CHAR, p_attribute14,
          p_cancel_flag, FND_API.G_MISS_CHAR, p_cancel_flag,
          p_closed_code, FND_API.G_MISS_CHAR, p_closed_code,
          p_expiration_date, FND_API.G_MISS_DATE, p_expiration_date,
          p_amount, FND_API.G_MISS_NUM, p_amount,
          p_allow_price_override_flag, FND_API.G_MISS_CHAR, p_allow_price_override_flag,
          p_not_to_exceed_price, FND_API.G_MISS_NUM, p_not_to_exceed_price,
          p_po_line_id;

Line: 3045

    'UPDATE ipo_line_types_b SET ' ||
    'outside_operation_flag = DECODE(:outside_operation_flag, '||
    ':miss_char, outside_operation_flag,:outside_operation_flag), '||
    'last_update_date = SYSDATE ' ||
    'WHERE line_type_id =:line_type_id '
    USING p_outside_operation_flag, FND_API.G_MISS_CHAR, p_outside_operation_flag,
          p_line_type_id;

Line: 3059

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateContractLine-'||
      xErrLoc||' '||SQLERRM);

Line: 3062

END updateContractLine;

Line: 3090

    'INSERT INTO ipo_line_locations_all( ' ||
    'line_location_id, ' ||
    'po_line_id, ' ||
    'start_date, ' ||
    'end_date, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':line_location_id, ' ||
    ':po_line_id, ' ||
    ':start_date, ' ||
    ':end_date, ' ||
    'SYSDATE) '
    USING p_line_location_id, p_po_line_id,
          p_start_date, p_end_date;

Line: 3107

    'INSERT INTO ipo_quotation_approvals_all( ' ||
    'line_location_id, ' ||
    'approval_type, ' ||
    'start_date_active, ' ||
    'end_date_active, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':line_location_id, ' ||
    ':approval_type, ' ||
    ':start_date_active, ' ||
    ':end_date_active, ' ||
    'SYSDATE) '
    USING p_line_location_id, p_approval_type,
          p_start_date_active, p_end_date_active;

Line: 3134

PROCEDURE updateQuoteLL(p_line_location_id	IN NUMBER,
			p_start_date		IN DATE,
			p_end_date		IN DATE,
			p_approval_type		IN VARCHAR2,
			p_start_date_active	IN DATE,
			p_end_date_active	IN DATE)
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 3147

      'updateQuoteLL(p_line_location_id: ' || p_line_location_id ||
      ', p_start_date: ' || p_start_date ||
      ', p_end_date: ' || p_end_date ||
      ', p_approval_type: ' || p_approval_type ||
      ', p_start_date_active: ' || p_start_date_active ||
      ', p_end_date_active: ' || p_end_date_active || ')');

Line: 3157

    'UPDATE ipo_line_locations_all SET ' ||
    'start_date = DECODE(:start_date, '||
    ':miss_date, start_date,:start_date), '||
    'end_date = DECODE(:end_date, '||
    ':miss_date, end_date,:end_date), '||
    'last_update_date = SYSDATE ' ||
    'WHERE line_location_id =:line_location_id '
    USING p_start_date, FND_API.G_MISS_DATE, p_start_date,
          p_end_date, FND_API.G_MISS_DATE, p_end_date,
          p_line_location_id;

Line: 3170

    'UPDATE ipo_quotation_approvals_all SET ' ||
    'approval_type = DECODE(:approval_type, '||
    ':miss_char, approval_type,:approval_type), '||
    'approval_type, ' ||
    'start_date_active = DECODE(:start_date_active, '||
    ':miss_date, start_date_active,:start_date_active), '||
    'end_date_active = DECODE(:end_date_active, '||
    ':miss_date, end_date_active,:end_date_active), '||
    'last_update_date = SYSDATE ' ||
    'WHERE line_location_id =:line_location_id '
    USING p_approval_type, FND_API.G_MISS_CHAR, p_approval_type,
          p_start_date_active, FND_API.G_MISS_DATE, p_start_date_active,
          p_end_date_active, FND_API.G_MISS_DATE, p_end_date_active,
          p_line_location_id;

Line: 3191

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateQuoteLL-'||
      xErrLoc||' '||SQLERRM);

Line: 3194

END updateQuoteLL;

Line: 3219

    'INSERT INTO ipo_ga_org_assignments( ' ||
    'po_header_id, ' ||
    'organization_id, ' ||
    'enabled_flag, ' ||
    'vendor_site_id, ' ||
    'purchasing_org_id, ' ||
    'last_update_date) ' ||
    'VALUES( ' ||
    ':po_header_id, ' ||
    ':organization_id, ' ||
    ':enabled_flag, ' ||
    ':vendor_site_id, ' ||
    ':purchasing_org_id, ' ||
    'SYSDATE) '
    USING p_po_header_id, p_organization_id,
          p_enabled_flag, p_vendor_site_id, p_purchasing_org_id;

Line: 3248

PROCEDURE updateGlobalA(p_po_header_id		IN NUMBER,
		        p_organization_id	IN NUMBER,
			p_enabled_flag		IN VARCHAR2,
			p_vendor_site_id	IN NUMBER,
                        p_purchasing_org_id     IN NUMBER)  -- Centralized Proc Impacts
IS
  xErrLoc	PLS_INTEGER:= 100;

Line: 3260

      'updateGlobalA(p_po_header_id: ' || p_po_header_id ||
      ', p_organization_id: ' || p_organization_id ||
      ', p_enabled_flag: ' || p_enabled_flag ||
      ', p_vendor_site_id: ' || p_vendor_site_id ||
      ', p_purchasing_org_id: ' || p_purchasing_org_id || ')');

Line: 3269

    'UPDATE ipo_ga_org_assignments SET ' ||
    'enabled_flag = DECODE(:enabled_flag, '||
    ':miss_char, enabled_flag,:enabled_flag), '||
    'vendor_site_id = DECODE(:vendor_site_id, '||
    ':miss_num, vendor_site_id,:vendor_site_id), '||
    'purchasing_org_id = DECODE(:purchasing_org_id, '|| -- Centralized Proc Impacts
    ':miss_num, purchasing_org_id,:purchasing_org_id), '||
    'last_update_date = SYSDATE ' ||
    'WHERE po_header_id =:po_header_id ' ||
    'AND organization_id =:organization_id '
    USING p_enabled_flag, FND_API.G_MISS_CHAR, p_enabled_flag,
          p_vendor_site_id, FND_API.G_MISS_NUM, p_vendor_site_id,
          p_purchasing_org_id, FND_API.G_MISS_NUM, p_purchasing_org_id,
          p_po_header_id, p_organization_id;

Line: 3290

    ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_TEST.updateGlobalA-'||
      xErrLoc||' '||SQLERRM);

Line: 3293

END updateGlobalA;

Line: 3305

		     p_extractor_updated_flag	IN VARCHAR2,
		     p_internal_flag		IN VARCHAR2)
  RETURN BOOLEAN
IS
  xErrLoc	PLS_INTEGER;

Line: 3320

  SELECT rt_item_id
  INTO   p_rt_item_id
  FROM   icx_cat_items_b i
  WHERE  (org_id IS NULL AND p_org_id IS NULL OR
          org_id = p_org_id)
  AND    (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
          NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
            ICX_POR_EXT_ITEM.NULL_NUMBER OR
          supplier_id = p_supplier_id)
  AND    (supplier IS NULL AND p_supplier IS NULL OR
          supplier = p_supplier)
  AND    (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR
          supplier_part_num = p_supplier_part_num)
  AND    (internal_item_id IS NULL AND p_internal_item_id IS NULL OR
          internal_item_id = p_internal_item_id)
  AND    (internal_item_num IS NULL AND p_internal_item_num IS NULL OR
          internal_item_num = p_internal_item_num)
  AND    extractor_updated_flag = p_extractor_updated_flag
  AND    EXISTS (SELECT NULL
                 FROM   icx_cat_item_prices p
                 WHERE  p.rt_item_id = i.rt_item_id
                 AND    p.search_type = xSearchType);

Line: 3350

    ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
    ', INTERNAL_FLAG: ' || p_internal_flag ||
    '] exists in ICX_CAT_ITEMS_B with RT_ITEM_ID: ' || p_rt_item_id);

Line: 3366

      ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
      ', INTERNAL_FLAG: ' || p_internal_flag ||
      '] does not exist in ICX_CAT_ITEMS_B');

Line: 3376

      ', EXTRACTOR_UPDATED_FLAG: ' || p_extractor_updated_flag ||
      ', INTERNAL_FLAG: ' || p_internal_flag ||
      '] does not exist in ICX_CAT_ITEMS_B');

Line: 3404

  SELECT 0
  INTO   xResult
  FROM   icx_cat_items_b i
  WHERE  (org_id IS NULL AND p_org_id IS NULL OR
          org_id = p_org_id)
  AND    (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
          NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
            ICX_POR_EXT_ITEM.NULL_NUMBER OR
          supplier_id = p_supplier_id)
  AND    (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR
          supplier_part_num = p_supplier_part_num)
  AND    (internal_item_id IS NULL AND p_internal_item_id IS NULL OR
          internal_item_id = p_internal_item_id)
  AND    EXISTS (SELECT NULL
                 FROM   icx_cat_item_prices p
                 WHERE  p.rt_item_id = i.rt_item_id
                 AND    p.search_type = xSearchType);

Line: 3476

  SELECT primary_category_id
  INTO   p_primary_category_id
  FROM   icx_cat_items_tlp
  WHERE  rt_item_id = p_rt_item_id
  AND    language = p_language
  AND    item_source_type = p_item_source_type
  AND    search_type = p_search_type
  AND    primary_category_name = p_primary_category_name
  AND    (supplier_id = ICX_POR_EXT_ITEM.NULL_NUMBER AND
          NVL(p_supplier_id, ICX_POR_EXT_ITEM.NULL_NUMBER) =
            ICX_POR_EXT_ITEM.NULL_NUMBER OR
          supplier_id = p_supplier_id)
  AND    (supplier IS NULL AND p_supplier IS NULL OR
          supplier = p_supplier)
  AND    (supplier_part_num IS NULL AND p_supplier_part_num IS NULL OR
          supplier_part_num = p_supplier_part_num)
  AND    (internal_item_id IS NULL AND p_internal_item_id IS NULL OR
          internal_item_id = p_internal_item_id)
  AND    (internal_item_num IS NULL AND p_internal_item_num IS NULL OR
          internal_item_num = p_internal_item_num)
  AND    (description IS NULL AND p_description IS NULL OR
          description = p_description);

Line: 3574

  SELECT 0
  INTO   xResult
  FROM   icx_cat_items_tlp
  WHERE  rt_item_id = p_rt_item_id
  AND    language = p_language;

Line: 3613

  SELECT 0
  INTO   xResult
  FROM   icx_cat_category_items
  WHERE  rt_item_id = p_rt_item_id
  AND    rt_category_id = p_rt_category_id;

Line: 3652

  SELECT 0
  INTO   xResult
  FROM   icx_cat_category_items
  WHERE  rt_item_id = p_rt_item_id
  AND    rt_category_id = p_rt_category_id;

Line: 3691

  SELECT 0
  INTO   xResult
  FROM   icx_cat_ext_items_tlp
  WHERE  rt_item_id = p_rt_item_id
  AND    rt_category_id = p_rt_category_id
  AND    ROWNUM = 1;

Line: 3731

  SELECT 0
  INTO   xResult
  FROM   icx_cat_ext_items_tlp
  WHERE  rt_item_id = p_rt_item_id
  AND    rt_category_id = p_rt_category_id
  AND    ROWNUM = 1;

Line: 3791

    SELECT local_rt_item_id
    INTO   xRtItemId
    FROM   icx_cat_item_prices
    WHERE  rt_item_id = p_rt_item_id
    AND    org_id = p_org_id
    AND    price_type = p_price_type
    AND    active_flag = p_active_flag
    AND    asl_id = p_asl_id
    AND    contract_id = p_contract_id
    AND    contract_line_id = p_contract_line_id
    AND    template_id = p_template_id
    AND    template_line_id = p_template_line_id
    AND    inventory_item_id = p_inventory_item_id
    AND    mtl_category_id = p_mtl_category_id
    AND    search_type = p_search_type
    AND    (unit_price IS NULL AND p_unit_price IS NULL OR
            unit_price = p_unit_price)
    AND    (currency IS NULL AND p_currency IS NULL OR
            currency = p_currency)
    AND    (unit_of_measure IS NULL AND p_unit_of_measure IS NULL OR
            unit_of_measure = p_unit_of_measure)
    AND    supplier_site_id = p_supplier_site_id
    AND    (supplier_site_code IS NULL AND p_supplier_site_code IS NULL OR
            supplier_site_code = p_supplier_site_code)
    AND    (contract_num IS NULL AND p_contract_num IS NULL OR
            contract_num = p_contract_num)
    AND    (contract_line_num IS NULL AND p_contract_line_num IS NULL OR
            contract_line_num = p_contract_line_num);

Line: 3928

  SELECT 0
  INTO   xResult
  FROM   icx_cat_item_prices
  WHERE  rt_item_id = p_rt_item_id
  AND    org_id = p_org_id
  AND    price_type = p_price_type
  AND    active_flag = p_active_flag
  AND    asl_id = p_asl_id
  AND    contract_id = p_contract_id
  AND    contract_line_id = p_contract_line_id
  AND    template_id = p_template_id
  AND    template_line_id = p_template_line_id
  AND    inventory_item_id = p_inventory_item_id;

Line: 4013

    SELECT local_rt_item_id
    INTO   xRtItemId
    FROM   icx_cat_item_prices
    WHERE  rt_item_id = p_rt_item_id
    AND    org_id = p_org_id
    AND    price_type = p_price_type
    AND    active_flag = p_active_flag
    AND    template_id = p_template_id
    AND    template_line_id = p_template_line_id
    AND    inventory_item_id = p_inventory_item_id
    AND    mtl_category_id = p_mtl_category_id
    AND    suggested_quantity = p_suggested_quantity;