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.INVIDIT1 dependencies on DBMS_SQL

Line 1301: p_xref_type IN dbms_sql.Varchar2_Table,

1297: p_default_assignment IN VARCHAR2 DEFAULT NULL,
1298: p_vendor_product_num IN VARCHAR2 DEFAULT NULL,
1299: p_contract IN VARCHAR2 DEFAULT NULL,
1300: p_blanket_agreement IN VARCHAR2 DEFAULT NULL,
1301: p_xref_type IN dbms_sql.Varchar2_Table,
1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,

Line 1302: p_xref_val IN dbms_sql.Varchar2_Table,

1298: p_vendor_product_num IN VARCHAR2 DEFAULT NULL,
1299: p_contract IN VARCHAR2 DEFAULT NULL,
1300: p_blanket_agreement IN VARCHAR2 DEFAULT NULL,
1301: p_xref_type IN dbms_sql.Varchar2_Table,
1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,

Line 1303: p_relationship_type IN dbms_sql.Number_Table,

1299: p_contract IN VARCHAR2 DEFAULT NULL,
1300: p_blanket_agreement IN VARCHAR2 DEFAULT NULL,
1301: p_xref_type IN dbms_sql.Varchar2_Table,
1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,

Line 1304: p_related_item IN dbms_sql.Number_Table,

1300: p_blanket_agreement IN VARCHAR2 DEFAULT NULL,
1301: p_xref_type IN dbms_sql.Varchar2_Table,
1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,
1308: p_element_val IN dbms_sql.Varchar2_Table) IS

Line 1305: p_category_set IN dbms_sql.Number_Table,

1301: p_xref_type IN dbms_sql.Varchar2_Table,
1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,
1308: p_element_val IN dbms_sql.Varchar2_Table) IS
1309:

Line 1306: p_category_id IN dbms_sql.Number_Table,

1302: p_xref_val IN dbms_sql.Varchar2_Table,
1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,
1308: p_element_val IN dbms_sql.Varchar2_Table) IS
1309:
1310: l_cursor NUMBER;

Line 1307: p_element_name IN dbms_sql.Varchar2_Table,

1303: p_relationship_type IN dbms_sql.Number_Table,
1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,
1308: p_element_val IN dbms_sql.Varchar2_Table) IS
1309:
1310: l_cursor NUMBER;
1311: l_rowcount NUMBER;

Line 1308: p_element_val IN dbms_sql.Varchar2_Table) IS

1304: p_related_item IN dbms_sql.Number_Table,
1305: p_category_set IN dbms_sql.Number_Table,
1306: p_category_id IN dbms_sql.Number_Table,
1307: p_element_name IN dbms_sql.Varchar2_Table,
1308: p_element_val IN dbms_sql.Varchar2_Table) IS
1309:
1310: l_cursor NUMBER;
1311: l_rowcount NUMBER;
1312: sql_stmt VARCHAR2(30000);

Line 1335: l_cursor := DBMS_SQL.OPEN_CURSOR;

1331: l_element_row_stmt VARCHAR2(2000);
1332: l_element_bind NUMBER := 1;
1333: BEGIN
1334:
1335: l_cursor := DBMS_SQL.OPEN_CURSOR;
1336: sql_stmt := 'INSERT INTO MTL_CATALOG_SEARCH_ITEMS ( ' ||
1337: ' SELECT :handle, MSI.INVENTORY_ITEM_ID, '||
1338: ' MSI.ORGANIZATION_ID,MSI.DESCRIPTION, '||
1339: ' MSI.PRIMARY_UOM_CODE, MSI.RESERVABLE_TYPE '||

Line 1517: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);

1513: END IF;
1514:
1515: sql_stmt := sql_stmt || ')';
1516:
1517: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1518: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1519:
1520: IF p_org_id IS NOT NULL THEN
1521: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);

Line 1518: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);

1514:
1515: sql_stmt := sql_stmt || ')';
1516:
1517: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1518: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1519:
1520: IF p_org_id IS NOT NULL THEN
1521: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1522: END IF;

Line 1521: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);

1517: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1518: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1519:
1520: IF p_org_id IS NOT NULL THEN
1521: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1522: END IF;
1523:
1524: IF p_item_mask IS NOT NULL THEN
1525: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);

Line 1525: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);

1521: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1522: END IF;
1523:
1524: IF p_item_mask IS NOT NULL THEN
1525: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);
1526: END IF;
1527:
1528: IF p_item_description IS NOT NULL THEN
1529: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);

Line 1529: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);

1525: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);
1526: END IF;
1527:
1528: IF p_item_description IS NOT NULL THEN
1529: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);
1530: END IF;
1531:
1532: IF p_base_item_id IS NOT NULL THEN
1533: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);

Line 1533: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);

1529: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);
1530: END IF;
1531:
1532: IF p_base_item_id IS NOT NULL THEN
1533: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);
1534: END IF;
1535:
1536: IF p_status IS NOT NULL THEN
1537: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);

Line 1537: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);

1533: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);
1534: END IF;
1535:
1536: IF p_status IS NOT NULL THEN
1537: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);
1538: END IF;
1539:
1540: IF p_catalog_grp_id IS NOT NULL THEN
1541: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);

Line 1541: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);

1537: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);
1538: END IF;
1539:
1540: IF p_catalog_grp_id IS NOT NULL THEN
1541: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);
1542: END IF;
1543:
1544: IF p_catalog_complete IS NOT NULL THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);

Line 1545: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);

1541: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);
1542: END IF;
1543:
1544: IF p_catalog_complete IS NOT NULL THEN
1545: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);
1546: END IF;
1547:
1548: IF p_manufacturer_id IS NOT NULL THEN
1549: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);

Line 1549: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);

1545: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);
1546: END IF;
1547:
1548: IF p_manufacturer_id IS NOT NULL THEN
1549: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);
1550: IF p_mfg_part_num IS NOT NULL THEN
1551: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_mfg_part_num' , p_mfg_part_num);
1552: END IF;
1553: END IF;

Line 1551: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_mfg_part_num' , p_mfg_part_num);

1547:
1548: IF p_manufacturer_id IS NOT NULL THEN
1549: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);
1550: IF p_mfg_part_num IS NOT NULL THEN
1551: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_mfg_part_num' , p_mfg_part_num);
1552: END IF;
1553: END IF;
1554:
1555: IF p_vendor_id IS NOT NULL THEN

Line 1556: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_id', p_vendor_id);

1552: END IF;
1553: END IF;
1554:
1555: IF p_vendor_id IS NOT NULL THEN
1556: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_id', p_vendor_id);
1557: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);
1558: END IF;
1559:
1560: IF p_vendor_product_num IS NOT NULL THEN

Line 1557: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);

1553: END IF;
1554:
1555: IF p_vendor_id IS NOT NULL THEN
1556: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_id', p_vendor_id);
1557: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);
1558: END IF;
1559:
1560: IF p_vendor_product_num IS NOT NULL THEN
1561: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);

Line 1561: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);

1557: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);
1558: END IF;
1559:
1560: IF p_vendor_product_num IS NOT NULL THEN
1561: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);
1562: END IF;
1563:
1564: IF p_contract IS NOT NULL THEN
1565: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);

Line 1565: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);

1561: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);
1562: END IF;
1563:
1564: IF p_contract IS NOT NULL THEN
1565: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);
1566: END IF;
1567:
1568: IF p_blanket_agreement IS NOT NULL THEN
1569: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_blanket_agreement', p_blanket_agreement);

Line 1569: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_blanket_agreement', p_blanket_agreement);

1565: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);
1566: END IF;
1567:
1568: IF p_blanket_agreement IS NOT NULL THEN
1569: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_blanket_agreement', p_blanket_agreement);
1570: END IF;
1571:
1572: IF p_xref_type.COUNT <> 0 THEN
1573: l_xref_bind := 1;

Line 1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_type' || l_xref_bind , p_xref_type(i));

1571:
1572: IF p_xref_type.COUNT <> 0 THEN
1573: l_xref_bind := 1;
1574: FOR i IN p_xref_type.FIRST .. p_xref_type.LAST LOOP
1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_type' || l_xref_bind , p_xref_type(i));
1576: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_val' || l_xref_bind , p_xref_val(i));
1577: l_xref_bind := l_xref_bind + 1;
1578: END LOOP;
1579: END IF;

Line 1576: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_val' || l_xref_bind , p_xref_val(i));

1572: IF p_xref_type.COUNT <> 0 THEN
1573: l_xref_bind := 1;
1574: FOR i IN p_xref_type.FIRST .. p_xref_type.LAST LOOP
1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_type' || l_xref_bind , p_xref_type(i));
1576: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_val' || l_xref_bind , p_xref_val(i));
1577: l_xref_bind := l_xref_bind + 1;
1578: END LOOP;
1579: END IF;
1580:

Line 1584: DBMS_SQL.BIND_VARIABLE(l_cursor, 'relation_type' || l_relation_bind, p_relationship_type(i));

1580:
1581: IF p_relationship_type.COUNT <> 0 THEN
1582: l_relation_bind := 1;
1583: FOR i IN p_relationship_type.FIRST .. p_relationship_type.LAST LOOP
1584: DBMS_SQL.BIND_VARIABLE(l_cursor, 'relation_type' || l_relation_bind, p_relationship_type(i));
1585: DBMS_SQL.BIND_VARIABLE(l_cursor, 'related_item' || l_relation_bind, p_related_item(i));
1586: l_relation_bind := l_relation_bind + 1;
1587: END LOOP;
1588: END IF;

Line 1585: DBMS_SQL.BIND_VARIABLE(l_cursor, 'related_item' || l_relation_bind, p_related_item(i));

1581: IF p_relationship_type.COUNT <> 0 THEN
1582: l_relation_bind := 1;
1583: FOR i IN p_relationship_type.FIRST .. p_relationship_type.LAST LOOP
1584: DBMS_SQL.BIND_VARIABLE(l_cursor, 'relation_type' || l_relation_bind, p_relationship_type(i));
1585: DBMS_SQL.BIND_VARIABLE(l_cursor, 'related_item' || l_relation_bind, p_related_item(i));
1586: l_relation_bind := l_relation_bind + 1;
1587: END LOOP;
1588: END IF;
1589:

Line 1593: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_set' || l_category_bind, p_category_set(i));

1589:
1590: IF p_category_set.COUNT <> 0 THEN
1591: l_category_bind := 1;
1592: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1593: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_set' || l_category_bind, p_category_set(i));
1594: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_id' || l_category_bind, p_category_id(i));
1595: l_category_bind := l_category_bind + 1;
1596: END LOOP;
1597: END IF;

Line 1594: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_id' || l_category_bind, p_category_id(i));

1590: IF p_category_set.COUNT <> 0 THEN
1591: l_category_bind := 1;
1592: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1593: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_set' || l_category_bind, p_category_set(i));
1594: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_id' || l_category_bind, p_category_id(i));
1595: l_category_bind := l_category_bind + 1;
1596: END LOOP;
1597: END IF;
1598:

Line 1603: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_name' || l_element_bind, p_element_name(i));

1599: IF p_element_name.COUNT <> 0 THEN
1600: l_element_bind := 1;
1601: FOR i IN p_element_name.FIRST .. p_element_name.LAST LOOP
1602: IF(p_element_val(i) IS NOT NULL) THEN
1603: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_name' || l_element_bind, p_element_name(i));
1604: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_val' || l_element_bind, p_element_val(i));
1605: l_element_bind := l_element_bind + 1;
1606: END IF;
1607: END LOOP;

Line 1604: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_val' || l_element_bind, p_element_val(i));

1600: l_element_bind := 1;
1601: FOR i IN p_element_name.FIRST .. p_element_name.LAST LOOP
1602: IF(p_element_val(i) IS NOT NULL) THEN
1603: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_name' || l_element_bind, p_element_name(i));
1604: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_val' || l_element_bind, p_element_val(i));
1605: l_element_bind := l_element_bind + 1;
1606: END IF;
1607: END LOOP;
1608: END IF;

Line 1610: l_rowcount := DBMS_SQL.EXECUTE(l_cursor);

1606: END IF;
1607: END LOOP;
1608: END IF;
1609:
1610: l_rowcount := DBMS_SQL.EXECUTE(l_cursor);
1611:
1612: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1613:
1614: END;

Line 1612: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1608: END IF;
1609:
1610: l_rowcount := DBMS_SQL.EXECUTE(l_cursor);
1611:
1612: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1613:
1614: END;
1615:
1616: END INVIDIT1;