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 1303: p_xref_type IN dbms_sql.Varchar2_Table,

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

Line 1304: p_xref_val IN dbms_sql.Varchar2_Table,

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

Line 1305: p_relationship_type IN dbms_sql.Number_Table,

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

Line 1306: p_related_item IN dbms_sql.Number_Table,

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

Line 1307: p_category_set IN dbms_sql.Number_Table,

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

Line 1308: p_category_id IN dbms_sql.Number_Table,

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

Line 1309: p_element_name IN dbms_sql.Varchar2_Table,

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

Line 1310: p_element_val IN dbms_sql.Varchar2_Table) IS

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

Line 1337: l_cursor := DBMS_SQL.OPEN_CURSOR;

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

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

1523: END IF;
1524:
1525: sql_stmt := sql_stmt || ')';
1526:
1527: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1528: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1529:
1530: IF p_org_id IS NOT NULL THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);

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

1524:
1525: sql_stmt := sql_stmt || ')';
1526:
1527: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1528: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1529:
1530: IF p_org_id IS NOT NULL THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1532: END IF;

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

1527: DBMS_SQL.PARSE(l_cursor, sql_stmt, dbms_sql.native);
1528: DBMS_SQL.BIND_VARIABLE(l_cursor, 'handle', p_grp_handle_id);
1529:
1530: IF p_org_id IS NOT NULL THEN
1531: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1532: END IF;
1533:
1534: IF p_item_mask IS NOT NULL THEN
1535: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);

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

1531: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_org_id', p_org_id);
1532: END IF;
1533:
1534: IF p_item_mask IS NOT NULL THEN
1535: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);
1536: END IF;
1537:
1538: IF p_item_description IS NOT NULL THEN
1539: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);

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

1535: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_mask', p_item_mask);
1536: END IF;
1537:
1538: IF p_item_description IS NOT NULL THEN
1539: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);
1540: END IF;
1541:
1542: IF p_base_item_id IS NOT NULL THEN
1543: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);

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

1539: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_item_description', p_item_description);
1540: END IF;
1541:
1542: IF p_base_item_id IS NOT NULL THEN
1543: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);
1544: END IF;
1545:
1546: IF p_status IS NOT NULL THEN
1547: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);

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

1543: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_base_item_id', p_base_item_id);
1544: END IF;
1545:
1546: IF p_status IS NOT NULL THEN
1547: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_status', p_status);
1548: END IF;
1549:
1550: IF p_catalog_grp_id IS NOT NULL THEN
1551: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);

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

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

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

1551: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_grp_id', p_catalog_grp_id);
1552: END IF;
1553:
1554: IF p_catalog_complete IS NOT NULL THEN
1555: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);
1556: END IF;
1557:
1558: IF p_manufacturer_id IS NOT NULL THEN
1559: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);

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

1555: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_catalog_complete', p_catalog_complete);
1556: END IF;
1557:
1558: IF p_manufacturer_id IS NOT NULL THEN
1559: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_manufacturer_id', p_manufacturer_id);
1560: IF p_mfg_part_num IS NOT NULL THEN
1561: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_mfg_part_num' , p_mfg_part_num);
1562: END IF;
1563: END IF;

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

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

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

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

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

1563: END IF;
1564:
1565: IF p_vendor_id IS NOT NULL THEN
1566: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_id', p_vendor_id);
1567: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);
1568: END IF;
1569:
1570: IF p_vendor_product_num IS NOT NULL THEN
1571: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);

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

1567: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_default_assignment', p_default_assignment);
1568: END IF;
1569:
1570: IF p_vendor_product_num IS NOT NULL THEN
1571: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);
1572: END IF;
1573:
1574: IF p_contract IS NOT NULL THEN
1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);

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

1571: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_vendor_product_num', p_vendor_product_num);
1572: END IF;
1573:
1574: IF p_contract IS NOT NULL THEN
1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);
1576: END IF;
1577:
1578: IF p_blanket_agreement IS NOT NULL THEN
1579: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_blanket_agreement', p_blanket_agreement);

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

1575: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_contract', p_contract);
1576: END IF;
1577:
1578: IF p_blanket_agreement IS NOT NULL THEN
1579: DBMS_SQL.BIND_VARIABLE(l_cursor, 'p_blanket_agreement', p_blanket_agreement);
1580: END IF;
1581:
1582: IF p_xref_type.COUNT <> 0 THEN
1583: l_xref_bind := 1;

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

1581:
1582: IF p_xref_type.COUNT <> 0 THEN
1583: l_xref_bind := 1;
1584: FOR i IN p_xref_type.FIRST .. p_xref_type.LAST LOOP
1585: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_type' || l_xref_bind , p_xref_type(i));
1586: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_val' || l_xref_bind , p_xref_val(i));
1587: l_xref_bind := l_xref_bind + 1;
1588: END LOOP;
1589: END IF;

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

1582: IF p_xref_type.COUNT <> 0 THEN
1583: l_xref_bind := 1;
1584: FOR i IN p_xref_type.FIRST .. p_xref_type.LAST LOOP
1585: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_type' || l_xref_bind , p_xref_type(i));
1586: DBMS_SQL.BIND_VARIABLE(l_cursor, 'xref_val' || l_xref_bind , p_xref_val(i));
1587: l_xref_bind := l_xref_bind + 1;
1588: END LOOP;
1589: END IF;
1590:

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

1590:
1591: IF p_relationship_type.COUNT <> 0 THEN
1592: l_relation_bind := 1;
1593: FOR i IN p_relationship_type.FIRST .. p_relationship_type.LAST LOOP
1594: DBMS_SQL.BIND_VARIABLE(l_cursor, 'relation_type' || l_relation_bind, p_relationship_type(i));
1595: DBMS_SQL.BIND_VARIABLE(l_cursor, 'related_item' || l_relation_bind, p_related_item(i));
1596: l_relation_bind := l_relation_bind + 1;
1597: END LOOP;
1598: END IF;

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

1591: IF p_relationship_type.COUNT <> 0 THEN
1592: l_relation_bind := 1;
1593: FOR i IN p_relationship_type.FIRST .. p_relationship_type.LAST LOOP
1594: DBMS_SQL.BIND_VARIABLE(l_cursor, 'relation_type' || l_relation_bind, p_relationship_type(i));
1595: DBMS_SQL.BIND_VARIABLE(l_cursor, 'related_item' || l_relation_bind, p_related_item(i));
1596: l_relation_bind := l_relation_bind + 1;
1597: END LOOP;
1598: END IF;
1599:

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

1599:
1600: IF p_category_set.COUNT <> 0 THEN
1601: l_category_bind := 1;
1602: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1603: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_set' || l_category_bind, p_category_set(i));
1604: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_id' || l_category_bind, p_category_id(i));
1605: l_category_bind := l_category_bind + 1;
1606: END LOOP;
1607: END IF;

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

1600: IF p_category_set.COUNT <> 0 THEN
1601: l_category_bind := 1;
1602: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1603: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_set' || l_category_bind, p_category_set(i));
1604: DBMS_SQL.BIND_VARIABLE(l_cursor, 'category_id' || l_category_bind, p_category_id(i));
1605: l_category_bind := l_category_bind + 1;
1606: END LOOP;
1607: END IF;
1608:

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

1609: IF p_element_name.COUNT <> 0 THEN
1610: l_element_bind := 1;
1611: FOR i IN p_element_name.FIRST .. p_element_name.LAST LOOP
1612: IF(p_element_val(i) IS NOT NULL) THEN
1613: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_name' || l_element_bind, p_element_name(i));
1614: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_val' || l_element_bind, p_element_val(i));
1615: l_element_bind := l_element_bind + 1;
1616: END IF;
1617: END LOOP;

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

1610: l_element_bind := 1;
1611: FOR i IN p_element_name.FIRST .. p_element_name.LAST LOOP
1612: IF(p_element_val(i) IS NOT NULL) THEN
1613: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_name' || l_element_bind, p_element_name(i));
1614: DBMS_SQL.BIND_VARIABLE(l_cursor, 'element_val' || l_element_bind, p_element_val(i));
1615: l_element_bind := l_element_bind + 1;
1616: END IF;
1617: END LOOP;
1618: END IF;

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

1616: END IF;
1617: END LOOP;
1618: END IF;
1619:
1620: l_rowcount := DBMS_SQL.EXECUTE(l_cursor);
1621:
1622: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1623:
1624: END;

Line 1622: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1618: END IF;
1619:
1620: l_rowcount := DBMS_SQL.EXECUTE(l_cursor);
1621:
1622: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1623:
1624: END;
1625:
1626: END INVIDIT1;