DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on FND_GLOBAL

Line 1573: ,FND_GLOBAL.User_Id

1569: VALUES
1570: (
1571: p_dummy_attr_group_id
1572: ,p_real_attr_group_id
1573: ,FND_GLOBAL.User_Id
1574: ,SYSDATE
1575: ,FND_GLOBAL.User_Id
1576: ,SYSDATE
1577: ,FND_GLOBAL.Login_Id

Line 1575: ,FND_GLOBAL.User_Id

1571: p_dummy_attr_group_id
1572: ,p_real_attr_group_id
1573: ,FND_GLOBAL.User_Id
1574: ,SYSDATE
1575: ,FND_GLOBAL.User_Id
1576: ,SYSDATE
1577: ,FND_GLOBAL.Login_Id
1578: );
1579: ELSIF p_attr_group_type = 'PO_LINE_EXT_ATTRS' THEN

Line 1577: ,FND_GLOBAL.Login_Id

1573: ,FND_GLOBAL.User_Id
1574: ,SYSDATE
1575: ,FND_GLOBAL.User_Id
1576: ,SYSDATE
1577: ,FND_GLOBAL.Login_Id
1578: );
1579: ELSIF p_attr_group_type = 'PO_LINE_EXT_ATTRS' THEN
1580: INSERT INTO PO_UDA_MAPPINGS
1581: (

Line 1594: ,FND_GLOBAL.User_Id

1590: VALUES
1591: (
1592: p_dummy_attr_group_id
1593: ,p_real_attr_group_id
1594: ,FND_GLOBAL.User_Id
1595: ,SYSDATE
1596: ,FND_GLOBAL.User_Id
1597: ,SYSDATE
1598: ,FND_GLOBAL.Login_Id

Line 1596: ,FND_GLOBAL.User_Id

1592: p_dummy_attr_group_id
1593: ,p_real_attr_group_id
1594: ,FND_GLOBAL.User_Id
1595: ,SYSDATE
1596: ,FND_GLOBAL.User_Id
1597: ,SYSDATE
1598: ,FND_GLOBAL.Login_Id
1599: );
1600: ELSIF p_attr_group_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN

Line 1598: ,FND_GLOBAL.Login_Id

1594: ,FND_GLOBAL.User_Id
1595: ,SYSDATE
1596: ,FND_GLOBAL.User_Id
1597: ,SYSDATE
1598: ,FND_GLOBAL.Login_Id
1599: );
1600: ELSIF p_attr_group_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN
1601: INSERT INTO PO_UDA_MAPPINGS
1602: (

Line 1615: ,FND_GLOBAL.User_Id

1611: VALUES
1612: (
1613: p_dummy_attr_group_id
1614: ,p_real_attr_group_id
1615: ,FND_GLOBAL.User_Id
1616: ,SYSDATE
1617: ,FND_GLOBAL.User_Id
1618: ,SYSDATE
1619: ,FND_GLOBAL.Login_Id

Line 1617: ,FND_GLOBAL.User_Id

1613: p_dummy_attr_group_id
1614: ,p_real_attr_group_id
1615: ,FND_GLOBAL.User_Id
1616: ,SYSDATE
1617: ,FND_GLOBAL.User_Id
1618: ,SYSDATE
1619: ,FND_GLOBAL.Login_Id
1620: );
1621: ELSIF p_attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN

Line 1619: ,FND_GLOBAL.Login_Id

1615: ,FND_GLOBAL.User_Id
1616: ,SYSDATE
1617: ,FND_GLOBAL.User_Id
1618: ,SYSDATE
1619: ,FND_GLOBAL.Login_Id
1620: );
1621: ELSIF p_attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN
1622: INSERT INTO PO_UDA_MAPPINGS
1623: (

Line 1636: ,FND_GLOBAL.User_Id

1632: VALUES
1633: (
1634: p_dummy_attr_group_id
1635: ,p_real_attr_group_id
1636: ,FND_GLOBAL.User_Id
1637: ,SYSDATE
1638: ,FND_GLOBAL.User_Id
1639: ,SYSDATE
1640: ,FND_GLOBAL.Login_Id

Line 1638: ,FND_GLOBAL.User_Id

1634: p_dummy_attr_group_id
1635: ,p_real_attr_group_id
1636: ,FND_GLOBAL.User_Id
1637: ,SYSDATE
1638: ,FND_GLOBAL.User_Id
1639: ,SYSDATE
1640: ,FND_GLOBAL.Login_Id
1641: );
1642: ELSIF p_attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN

Line 1640: ,FND_GLOBAL.Login_Id

1636: ,FND_GLOBAL.User_Id
1637: ,SYSDATE
1638: ,FND_GLOBAL.User_Id
1639: ,SYSDATE
1640: ,FND_GLOBAL.Login_Id
1641: );
1642: ELSIF p_attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN
1643: INSERT INTO PO_UDA_MAPPINGS
1644: (

Line 1657: ,FND_GLOBAL.User_Id

1653: VALUES
1654: (
1655: p_dummy_attr_group_id
1656: ,p_real_attr_group_id
1657: ,FND_GLOBAL.User_Id
1658: ,SYSDATE
1659: ,FND_GLOBAL.User_Id
1660: ,SYSDATE
1661: ,FND_GLOBAL.Login_Id

Line 1659: ,FND_GLOBAL.User_Id

1655: p_dummy_attr_group_id
1656: ,p_real_attr_group_id
1657: ,FND_GLOBAL.User_Id
1658: ,SYSDATE
1659: ,FND_GLOBAL.User_Id
1660: ,SYSDATE
1661: ,FND_GLOBAL.Login_Id
1662: );
1663: ELSIF p_attr_group_type = 'PO_REQ_LINE_EXT_ATTRS' THEN

Line 1661: ,FND_GLOBAL.Login_Id

1657: ,FND_GLOBAL.User_Id
1658: ,SYSDATE
1659: ,FND_GLOBAL.User_Id
1660: ,SYSDATE
1661: ,FND_GLOBAL.Login_Id
1662: );
1663: ELSIF p_attr_group_type = 'PO_REQ_LINE_EXT_ATTRS' THEN
1664: INSERT INTO PO_UDA_MAPPINGS
1665: (

Line 1678: ,FND_GLOBAL.User_Id

1674: VALUES
1675: (
1676: p_dummy_attr_group_id
1677: ,p_real_attr_group_id
1678: ,FND_GLOBAL.User_Id
1679: ,SYSDATE
1680: ,FND_GLOBAL.User_Id
1681: ,SYSDATE
1682: ,FND_GLOBAL.Login_Id

Line 1680: ,FND_GLOBAL.User_Id

1676: p_dummy_attr_group_id
1677: ,p_real_attr_group_id
1678: ,FND_GLOBAL.User_Id
1679: ,SYSDATE
1680: ,FND_GLOBAL.User_Id
1681: ,SYSDATE
1682: ,FND_GLOBAL.Login_Id
1683: );
1684: ELSIF p_attr_group_type = 'PO_REQ_DIST_EXT_ATTRS' THEN

Line 1682: ,FND_GLOBAL.Login_Id

1678: ,FND_GLOBAL.User_Id
1679: ,SYSDATE
1680: ,FND_GLOBAL.User_Id
1681: ,SYSDATE
1682: ,FND_GLOBAL.Login_Id
1683: );
1684: ELSIF p_attr_group_type = 'PO_REQ_DIST_EXT_ATTRS' THEN
1685: INSERT INTO PO_UDA_MAPPINGS
1686: (

Line 1699: ,FND_GLOBAL.User_Id

1695: VALUES
1696: (
1697: p_dummy_attr_group_id
1698: ,p_real_attr_group_id
1699: ,FND_GLOBAL.User_Id
1700: ,SYSDATE
1701: ,FND_GLOBAL.User_Id
1702: ,SYSDATE
1703: ,FND_GLOBAL.Login_Id

Line 1701: ,FND_GLOBAL.User_Id

1697: p_dummy_attr_group_id
1698: ,p_real_attr_group_id
1699: ,FND_GLOBAL.User_Id
1700: ,SYSDATE
1701: ,FND_GLOBAL.User_Id
1702: ,SYSDATE
1703: ,FND_GLOBAL.Login_Id
1704: );
1705: ELSIF p_attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN

Line 1703: ,FND_GLOBAL.Login_Id

1699: ,FND_GLOBAL.User_Id
1700: ,SYSDATE
1701: ,FND_GLOBAL.User_Id
1702: ,SYSDATE
1703: ,FND_GLOBAL.Login_Id
1704: );
1705: ELSIF p_attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN
1706: INSERT INTO PO_UDA_MAPPINGS
1707: (

Line 1720: ,FND_GLOBAL.User_Id

1716: VALUES
1717: (
1718: p_dummy_attr_group_id
1719: ,p_real_attr_group_id
1720: ,FND_GLOBAL.User_Id
1721: ,SYSDATE
1722: ,FND_GLOBAL.User_Id
1723: ,SYSDATE
1724: ,FND_GLOBAL.Login_Id

Line 1722: ,FND_GLOBAL.User_Id

1718: p_dummy_attr_group_id
1719: ,p_real_attr_group_id
1720: ,FND_GLOBAL.User_Id
1721: ,SYSDATE
1722: ,FND_GLOBAL.User_Id
1723: ,SYSDATE
1724: ,FND_GLOBAL.Login_Id
1725: );
1726: ELSIF p_attr_group_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN

Line 1724: ,FND_GLOBAL.Login_Id

1720: ,FND_GLOBAL.User_Id
1721: ,SYSDATE
1722: ,FND_GLOBAL.User_Id
1723: ,SYSDATE
1724: ,FND_GLOBAL.Login_Id
1725: );
1726: ELSIF p_attr_group_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN
1727: INSERT INTO PO_UDA_MAPPINGS
1728: (

Line 1741: ,FND_GLOBAL.User_Id

1737: VALUES
1738: (
1739: p_dummy_attr_group_id
1740: ,p_real_attr_group_id
1741: ,FND_GLOBAL.User_Id
1742: ,SYSDATE
1743: ,FND_GLOBAL.User_Id
1744: ,SYSDATE
1745: ,FND_GLOBAL.Login_Id

Line 1743: ,FND_GLOBAL.User_Id

1739: p_dummy_attr_group_id
1740: ,p_real_attr_group_id
1741: ,FND_GLOBAL.User_Id
1742: ,SYSDATE
1743: ,FND_GLOBAL.User_Id
1744: ,SYSDATE
1745: ,FND_GLOBAL.Login_Id
1746: );
1747: ELSIF p_attr_group_type = 'PON_BID_HDRS_EXT_ATTRS' THEN

Line 1745: ,FND_GLOBAL.Login_Id

1741: ,FND_GLOBAL.User_Id
1742: ,SYSDATE
1743: ,FND_GLOBAL.User_Id
1744: ,SYSDATE
1745: ,FND_GLOBAL.Login_Id
1746: );
1747: ELSIF p_attr_group_type = 'PON_BID_HDRS_EXT_ATTRS' THEN
1748: INSERT INTO PO_UDA_MAPPINGS
1749: (

Line 1762: ,FND_GLOBAL.User_Id

1758: VALUES
1759: (
1760: p_dummy_attr_group_id
1761: ,p_real_attr_group_id
1762: ,FND_GLOBAL.User_Id
1763: ,SYSDATE
1764: ,FND_GLOBAL.User_Id
1765: ,SYSDATE
1766: ,FND_GLOBAL.Login_Id

Line 1764: ,FND_GLOBAL.User_Id

1760: p_dummy_attr_group_id
1761: ,p_real_attr_group_id
1762: ,FND_GLOBAL.User_Id
1763: ,SYSDATE
1764: ,FND_GLOBAL.User_Id
1765: ,SYSDATE
1766: ,FND_GLOBAL.Login_Id
1767: );
1768: ELSIF p_attr_group_type = 'PON_BID_PRICES_EXT_ATTRS' THEN

Line 1766: ,FND_GLOBAL.Login_Id

1762: ,FND_GLOBAL.User_Id
1763: ,SYSDATE
1764: ,FND_GLOBAL.User_Id
1765: ,SYSDATE
1766: ,FND_GLOBAL.Login_Id
1767: );
1768: ELSIF p_attr_group_type = 'PON_BID_PRICES_EXT_ATTRS' THEN
1769: INSERT INTO PO_UDA_MAPPINGS
1770: (

Line 1783: ,FND_GLOBAL.User_Id

1779: VALUES
1780: (
1781: p_dummy_attr_group_id
1782: ,p_real_attr_group_id
1783: ,FND_GLOBAL.User_Id
1784: ,SYSDATE
1785: ,FND_GLOBAL.User_Id
1786: ,SYSDATE
1787: ,FND_GLOBAL.Login_Id

Line 1785: ,FND_GLOBAL.User_Id

1781: p_dummy_attr_group_id
1782: ,p_real_attr_group_id
1783: ,FND_GLOBAL.User_Id
1784: ,SYSDATE
1785: ,FND_GLOBAL.User_Id
1786: ,SYSDATE
1787: ,FND_GLOBAL.Login_Id
1788: );
1789: END IF;

Line 1787: ,FND_GLOBAL.Login_Id

1783: ,FND_GLOBAL.User_Id
1784: ,SYSDATE
1785: ,FND_GLOBAL.User_Id
1786: ,SYSDATE
1787: ,FND_GLOBAL.Login_Id
1788: );
1789: END IF;
1790: d_progress := 60;
1791:

Line 1897: ,FND_GLOBAL.User_Id

1893: VALUES
1894: (
1895: p_attr_group_id
1896: ,p_data_level_id
1897: ,FND_GLOBAL.User_Id
1898: ,SYSDATE
1899: ,FND_GLOBAL.User_Id
1900: ,SYSDATE
1901: ,FND_GLOBAL.Login_Id

Line 1899: ,FND_GLOBAL.User_Id

1895: p_attr_group_id
1896: ,p_data_level_id
1897: ,FND_GLOBAL.User_Id
1898: ,SYSDATE
1899: ,FND_GLOBAL.User_Id
1900: ,SYSDATE
1901: ,FND_GLOBAL.Login_Id
1902: );
1903: d_progress := 20;

Line 1901: ,FND_GLOBAL.Login_Id

1897: ,FND_GLOBAL.User_Id
1898: ,SYSDATE
1899: ,FND_GLOBAL.User_Id
1900: ,SYSDATE
1901: ,FND_GLOBAL.Login_Id
1902: );
1903: d_progress := 20;
1904:
1905: IF (PO_LOG.d_exc) THEN

Line 4870: l_user_id := Fnd_Global.user_id;

4866: PO_LOG.proc_begin(d_module, 'p_new_template_id', p_new_template_id);
4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;
4869:
4870: l_user_id := Fnd_Global.user_id;
4871: l_login_id := Fnd_Global.login_id;
4872:
4873: OPEN c_get_temp_details(p_src_template_id);
4874: FETCH c_get_temp_details INTO l_object_id, l_data_level_name;

Line 4871: l_login_id := Fnd_Global.login_id;

4867: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
4868: END IF;
4869:
4870: l_user_id := Fnd_Global.user_id;
4871: l_login_id := Fnd_Global.login_id;
4872:
4873: OPEN c_get_temp_details(p_src_template_id);
4874: FETCH c_get_temp_details INTO l_object_id, l_data_level_name;
4875: CLOSE c_get_temp_details;

Line 5074: l_user_id := Fnd_Global.user_id;

5070: PO_LOG.proc_begin(d_module, 'p_dest_template_id', p_dest_template_id);
5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;
5073:
5074: l_user_id := Fnd_Global.user_id;
5075: l_login_id := Fnd_Global.login_id;
5076:
5077: OPEN c_get_temp_details(p_src_template_id);
5078: FETCH c_get_temp_details INTO l_object_id, l_data_level_name;

Line 5075: l_login_id := Fnd_Global.login_id;

5071: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5072: END IF;
5073:
5074: l_user_id := Fnd_Global.user_id;
5075: l_login_id := Fnd_Global.login_id;
5076:
5077: OPEN c_get_temp_details(p_src_template_id);
5078: FETCH c_get_temp_details INTO l_object_id, l_data_level_name;
5079: CLOSE c_get_temp_details;

Line 5288: l_user_id := Fnd_Global.user_id;

5284: PO_LOG.proc_begin(d_module);
5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5286: END IF;
5287:
5288: l_user_id := Fnd_Global.user_id;
5289: l_login_id := Fnd_Global.login_id;
5290:
5291: OPEN c_gen_template_seq;
5292: FETCH c_gen_template_seq INTO x_new_template_id;

Line 5289: l_login_id := Fnd_Global.login_id;

5285: PO_LOG.proc_begin(d_module, 'p_src_template_id', p_src_template_id);
5286: END IF;
5287:
5288: l_user_id := Fnd_Global.user_id;
5289: l_login_id := Fnd_Global.login_id;
5290:
5291: OPEN c_gen_template_seq;
5292: FETCH c_gen_template_seq INTO x_new_template_id;
5293: CLOSE c_gen_template_seq;