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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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
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: (
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
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;
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:
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
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;
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
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;
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;
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;
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;
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;
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;