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.GMIVDBL dependencies on IC_ITEM_CNV

Line 45: | to insert of ic_item_cnv. Added insert of |

41: | Modified ic_jrnl_mst insert to not insert journal no |
42: | if it already exists |
43: | 17-Nov-2002 Joe DiIorio Bug 1977956 11.5.1J - added nocopy. |
44: | 15-Apr-2003 Joe DiIorio Bug 2880585 11.5.1K - added conversion_id |
45: | to insert of ic_item_cnv. Added insert of |
46: | gmi_item_conv_audit. |
47: | 24-Jun-2003 Joe DiIorio Bug 3022564 11.5.10K - Changed sequennce |
48: | retrieval for gmi_item_conv_audit to |
49: | gmi_conv_audit_id_s. Was incorrectly calling |

Line 1530: FUNCTION ic_item_cnv_insert

1526:
1527:
1528:
1529:
1530: FUNCTION ic_item_cnv_insert
1531: (p_ic_item_cnv_row IN ic_item_cnv%ROWTYPE, x_ic_item_cnv_row IN OUT NOCOPY ic_item_cnv%ROWTYPE)
1532: RETURN BOOLEAN
1533:
1534:

Line 1531: (p_ic_item_cnv_row IN ic_item_cnv%ROWTYPE, x_ic_item_cnv_row IN OUT NOCOPY ic_item_cnv%ROWTYPE)

1527:
1528:
1529:
1530: FUNCTION ic_item_cnv_insert
1531: (p_ic_item_cnv_row IN ic_item_cnv%ROWTYPE, x_ic_item_cnv_row IN OUT NOCOPY ic_item_cnv%ROWTYPE)
1532: RETURN BOOLEAN
1533:
1534:
1535: IS

Line 1538: x_type_factor IC_ITEM_CNV.TYPE_FACTOR%TYPE := null;

1534:
1535: IS
1536: x_conv_audit_id GMI_ITEM_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
1537: x_reason_code SY_REAS_CDS.REASON_CODE%TYPE := null;
1538: x_type_factor IC_ITEM_CNV.TYPE_FACTOR%TYPE := null;
1539: x_event_spec_disp_id IC_ITEM_CNV.EVENT_SPEC_DISP_ID%TYPE := null;
1540:
1541: BEGIN
1542:

Line 1539: x_event_spec_disp_id IC_ITEM_CNV.EVENT_SPEC_DISP_ID%TYPE := null;

1535: IS
1536: x_conv_audit_id GMI_ITEM_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
1537: x_reason_code SY_REAS_CDS.REASON_CODE%TYPE := null;
1538: x_type_factor IC_ITEM_CNV.TYPE_FACTOR%TYPE := null;
1539: x_event_spec_disp_id IC_ITEM_CNV.EVENT_SPEC_DISP_ID%TYPE := null;
1540:
1541: BEGIN
1542:
1543: x_ic_item_cnv_row := p_ic_item_cnv_row;

Line 1543: x_ic_item_cnv_row := p_ic_item_cnv_row;

1539: x_event_spec_disp_id IC_ITEM_CNV.EVENT_SPEC_DISP_ID%TYPE := null;
1540:
1541: BEGIN
1542:
1543: x_ic_item_cnv_row := p_ic_item_cnv_row;
1544:
1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN
1546: select gmi_conversion_id_s.nextval into
1547: x_ic_item_cnv_row.conversion_id from dual;

Line 1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN

1541: BEGIN
1542:
1543: x_ic_item_cnv_row := p_ic_item_cnv_row;
1544:
1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN
1546: select gmi_conversion_id_s.nextval into
1547: x_ic_item_cnv_row.conversion_id from dual;
1548: END IF;
1549: INSERT INTO ic_item_cnv

Line 1547: x_ic_item_cnv_row.conversion_id from dual;

1543: x_ic_item_cnv_row := p_ic_item_cnv_row;
1544:
1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN
1546: select gmi_conversion_id_s.nextval into
1547: x_ic_item_cnv_row.conversion_id from dual;
1548: END IF;
1549: INSERT INTO ic_item_cnv
1550: ( item_id
1551: , lot_id

Line 1549: INSERT INTO ic_item_cnv

1545: IF (x_ic_item_cnv_row.conversion_id IS NULL) THEN
1546: select gmi_conversion_id_s.nextval into
1547: x_ic_item_cnv_row.conversion_id from dual;
1548: END IF;
1549: INSERT INTO ic_item_cnv
1550: ( item_id
1551: , lot_id
1552: , um_type
1553: , type_factor

Line 1566: ( p_ic_item_cnv_row.item_id

1562: , last_update_login
1563: , conversion_id
1564: )
1565: VALUES
1566: ( p_ic_item_cnv_row.item_id
1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date

Line 1567: , p_ic_item_cnv_row.lot_id

1563: , conversion_id
1564: )
1565: VALUES
1566: ( p_ic_item_cnv_row.item_id
1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date

Line 1568: , p_ic_item_cnv_row.um_type

1564: )
1565: VALUES
1566: ( p_ic_item_cnv_row.item_id
1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by

Line 1569: , p_ic_item_cnv_row.type_factor

1565: VALUES
1566: ( p_ic_item_cnv_row.item_id
1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by

Line 1570: , p_ic_item_cnv_row.creation_date

1566: ( p_ic_item_cnv_row.item_id
1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt

Line 1571: , p_ic_item_cnv_row.last_update_date

1567: , p_ic_item_cnv_row.lot_id
1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark

Line 1572: , p_ic_item_cnv_row.created_by

1568: , p_ic_item_cnv_row.um_type
1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code

Line 1573: , p_ic_item_cnv_row.last_updated_by

1569: , p_ic_item_cnv_row.type_factor
1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev

Line 1574: , p_ic_item_cnv_row.trans_cnt

1570: , p_ic_item_cnv_row.creation_date
1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login

Line 1575: , p_ic_item_cnv_row.delete_mark

1571: , p_ic_item_cnv_row.last_update_date
1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login
1579: , p_ic_item_cnv_row.conversion_id

Line 1576: , p_ic_item_cnv_row.text_code

1572: , p_ic_item_cnv_row.created_by
1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login
1579: , p_ic_item_cnv_row.conversion_id
1580: );

Line 1577: , p_ic_item_cnv_row.type_factorrev

1573: , p_ic_item_cnv_row.last_updated_by
1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login
1579: , p_ic_item_cnv_row.conversion_id
1580: );
1581:

Line 1578: , p_ic_item_cnv_row.last_update_login

1574: , p_ic_item_cnv_row.trans_cnt
1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login
1579: , p_ic_item_cnv_row.conversion_id
1580: );
1581:
1582: /* 15-Apr-2003 Joe DiIorio Bug 2880585 11.5.1K - */

Line 1579: , p_ic_item_cnv_row.conversion_id

1575: , p_ic_item_cnv_row.delete_mark
1576: , p_ic_item_cnv_row.text_code
1577: , p_ic_item_cnv_row.type_factorrev
1578: , p_ic_item_cnv_row.last_update_login
1579: , p_ic_item_cnv_row.conversion_id
1580: );
1581:
1582: /* 15-Apr-2003 Joe DiIorio Bug 2880585 11.5.1K - */
1583:

Line 1604: , p_ic_item_cnv_row.conversion_id

1600: , last_update_date
1601: )
1602: VALUES
1603: ( x_conv_audit_id
1604: , p_ic_item_cnv_row.conversion_id
1605: , p_ic_item_cnv_row.creation_date
1606: , x_reason_code
1607: , x_type_factor
1608: , p_ic_item_cnv_row.type_factor

Line 1605: , p_ic_item_cnv_row.creation_date

1601: )
1602: VALUES
1603: ( x_conv_audit_id
1604: , p_ic_item_cnv_row.conversion_id
1605: , p_ic_item_cnv_row.creation_date
1606: , x_reason_code
1607: , x_type_factor
1608: , p_ic_item_cnv_row.type_factor
1609: , x_event_spec_disp_id

Line 1608: , p_ic_item_cnv_row.type_factor

1604: , p_ic_item_cnv_row.conversion_id
1605: , p_ic_item_cnv_row.creation_date
1606: , x_reason_code
1607: , x_type_factor
1608: , p_ic_item_cnv_row.type_factor
1609: , x_event_spec_disp_id
1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by

Line 1610: , p_ic_item_cnv_row.created_by

1606: , x_reason_code
1607: , x_type_factor
1608: , p_ic_item_cnv_row.type_factor
1609: , x_event_spec_disp_id
1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by
1613: , p_ic_item_cnv_row.last_update_login
1614: , p_ic_item_cnv_row.last_update_date

Line 1611: , p_ic_item_cnv_row.creation_date

1607: , x_type_factor
1608: , p_ic_item_cnv_row.type_factor
1609: , x_event_spec_disp_id
1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by
1613: , p_ic_item_cnv_row.last_update_login
1614: , p_ic_item_cnv_row.last_update_date
1615: );

Line 1612: , p_ic_item_cnv_row.last_updated_by

1608: , p_ic_item_cnv_row.type_factor
1609: , x_event_spec_disp_id
1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by
1613: , p_ic_item_cnv_row.last_update_login
1614: , p_ic_item_cnv_row.last_update_date
1615: );
1616:

Line 1613: , p_ic_item_cnv_row.last_update_login

1609: , x_event_spec_disp_id
1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by
1613: , p_ic_item_cnv_row.last_update_login
1614: , p_ic_item_cnv_row.last_update_date
1615: );
1616:
1617:

Line 1614: , p_ic_item_cnv_row.last_update_date

1610: , p_ic_item_cnv_row.created_by
1611: , p_ic_item_cnv_row.creation_date
1612: , p_ic_item_cnv_row.last_updated_by
1613: , p_ic_item_cnv_row.last_update_login
1614: , p_ic_item_cnv_row.last_update_date
1615: );
1616:
1617:
1618: GMIGUTL.DB_ERRNUM := NULL;

Line 1632: END ic_item_cnv_insert;

1628:
1629: GMIGUTL.DB_ERRNUM := SQLCODE;
1630: GMIGUTL.DB_ERRMSG:= SQLERRM;
1631: RETURN FALSE;
1632: END ic_item_cnv_insert;
1633:
1634: FUNCTION sy_uoms_mst_select
1635: (p_sy_uoms_mst_row IN sy_uoms_mst%ROWTYPE, x_sy_uoms_mst_row IN OUT NOCOPY sy_uoms_mst%ROWTYPE)
1636: RETURN BOOLEAN