DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on PO_UDA_MAPPINGS

Line 826: FROM PO_UDA_MAPPINGS

822: l_pon_auc_item_price_group_id,
823: l_pon_auc_header_group_id,
824: l_bid_header_group_id,
825: l_bid_item_proce_group_id
826: FROM PO_UDA_MAPPINGS
827: WHERE DUMMY_ATTRIBUTE_GROUP_ID = l_attr_grp_id
828: AND ROWNUM < 2;
829:
830: IF l_po_header_group_id IS NOT NULL THEN

Line 1440: DELETE FROM PO_UDA_MAPPINGS

1436: END IF;
1437:
1438: d_progress := 90;
1439:
1440: DELETE FROM PO_UDA_MAPPINGS
1441: WHERE dummy_attribute_group_id = p_attribute_group_id;
1442:
1443: d_progress := 100;
1444:

Line 1544: -- Following if statement populates PO_UDA_MAPPINGS to refresh the latest dummy data

1540: IF PO_LOG.d_stmt THEN
1541: PO_LOG.stmt(d_module, d_progress, 'x_return_status', x_return_status);
1542: END IF;
1543:
1544: -- Following if statement populates PO_UDA_MAPPINGS to refresh the latest dummy data
1545:
1546: IF (get_map_table_details(p_dummy_attr_group_id, 'PO_HEADER_EXT_ATTRS') IS NULL
1547: AND get_map_table_details(p_dummy_attr_group_id, 'PO_LINE_EXT_ATTRS') IS NULL
1548: AND get_map_table_details(p_dummy_attr_group_id, 'PO_DISTRIBUTIONS_EXT_ATTRS') IS NULL

Line 1559: INSERT INTO PO_UDA_MAPPINGS

1555: AND get_map_table_details(p_dummy_attr_group_id, 'PON_BID_HDRS_EXT_ATTRS') IS NULL
1556: AND get_map_table_details(p_dummy_attr_group_id, 'PON_BID_PRICES_EXT_ATTRS') IS NULL)
1557: THEN
1558: IF p_attr_group_type = 'PO_HEADER_EXT_ATTRS' THEN
1559: INSERT INTO PO_UDA_MAPPINGS
1560: (
1561: dummy_attribute_group_id
1562: ,PO_HEADER_GROUP_ID
1563: ,created_by

Line 1580: INSERT INTO PO_UDA_MAPPINGS

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: (
1582: dummy_attribute_group_id
1583: ,PO_LINE_GROUP_ID
1584: ,created_by

Line 1601: INSERT INTO PO_UDA_MAPPINGS

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: (
1603: dummy_attribute_group_id
1604: ,PO_DISTRIBUTIONS_GROUP_ID
1605: ,created_by

Line 1622: INSERT INTO PO_UDA_MAPPINGS

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: (
1624: dummy_attribute_group_id
1625: ,PO_SHIPMENTS_GROUP_ID
1626: ,created_by

Line 1643: INSERT INTO PO_UDA_MAPPINGS

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: (
1645: dummy_attribute_group_id
1646: ,REQ_HEADER_GROUP_ID
1647: ,created_by

Line 1664: INSERT INTO PO_UDA_MAPPINGS

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: (
1666: dummy_attribute_group_id
1667: ,REQ_LINE_GROUP_ID
1668: ,created_by

Line 1685: INSERT INTO PO_UDA_MAPPINGS

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: (
1687: dummy_attribute_group_id
1688: ,REQ_DISTRIBUTION_GROUP_ID
1689: ,created_by

Line 1706: INSERT INTO PO_UDA_MAPPINGS

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: (
1708: dummy_attribute_group_id
1709: ,PON_AUC_ITEM_PRICE_GROUP_ID
1710: ,created_by

Line 1727: INSERT INTO PO_UDA_MAPPINGS

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: (
1729: dummy_attribute_group_id
1730: ,PON_AUC_HEADER_GROUP_ID
1731: ,created_by

Line 1748: INSERT INTO PO_UDA_MAPPINGS

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: (
1750: dummy_attribute_group_id
1751: ,BID_HEADER_GROUP_ID
1752: ,created_by

Line 1769: INSERT INTO PO_UDA_MAPPINGS

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: (
1771: dummy_attribute_group_id
1772: ,BID_ITEM_PRICE_GROUP_ID
1773: ,created_by

Line 1797: UPDATE PO_UDA_MAPPINGS

1793: PO_LOG.stmt(d_module, d_progress, 'd_progress', d_progress);
1794: END IF;
1795: ELSE
1796: IF p_attr_group_type = 'PO_HEADER_EXT_ATTRS' THEN
1797: UPDATE PO_UDA_MAPPINGS
1798: SET PO_HEADER_GROUP_ID = p_real_attr_group_id
1799: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1800: ELSIF p_attr_group_type = 'PO_LINE_EXT_ATTRS' THEN
1801: UPDATE PO_UDA_MAPPINGS

Line 1801: UPDATE PO_UDA_MAPPINGS

1797: UPDATE PO_UDA_MAPPINGS
1798: SET PO_HEADER_GROUP_ID = p_real_attr_group_id
1799: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1800: ELSIF p_attr_group_type = 'PO_LINE_EXT_ATTRS' THEN
1801: UPDATE PO_UDA_MAPPINGS
1802: SET PO_LINE_GROUP_ID = p_real_attr_group_id
1803: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1804: ELSIF p_attr_group_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN
1805: UPDATE PO_UDA_MAPPINGS

Line 1805: UPDATE PO_UDA_MAPPINGS

1801: UPDATE PO_UDA_MAPPINGS
1802: SET PO_LINE_GROUP_ID = p_real_attr_group_id
1803: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1804: ELSIF p_attr_group_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN
1805: UPDATE PO_UDA_MAPPINGS
1806: SET PO_DISTRIBUTIONS_GROUP_ID = p_real_attr_group_id
1807: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1808: ELSIF p_attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN
1809: UPDATE PO_UDA_MAPPINGS

Line 1809: UPDATE PO_UDA_MAPPINGS

1805: UPDATE PO_UDA_MAPPINGS
1806: SET PO_DISTRIBUTIONS_GROUP_ID = p_real_attr_group_id
1807: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1808: ELSIF p_attr_group_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN
1809: UPDATE PO_UDA_MAPPINGS
1810: SET PO_SHIPMENTS_GROUP_ID = p_real_attr_group_id
1811: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1812: ELSIF p_attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN
1813: UPDATE PO_UDA_MAPPINGS

Line 1813: UPDATE PO_UDA_MAPPINGS

1809: UPDATE PO_UDA_MAPPINGS
1810: SET PO_SHIPMENTS_GROUP_ID = p_real_attr_group_id
1811: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1812: ELSIF p_attr_group_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN
1813: UPDATE PO_UDA_MAPPINGS
1814: SET REQ_HEADER_GROUP_ID = p_real_attr_group_id
1815: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1816: ELSIF p_attr_group_type = 'PO_REQ_LINE_EXT_ATTRS' THEN
1817: UPDATE PO_UDA_MAPPINGS

Line 1817: UPDATE PO_UDA_MAPPINGS

1813: UPDATE PO_UDA_MAPPINGS
1814: SET REQ_HEADER_GROUP_ID = p_real_attr_group_id
1815: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1816: ELSIF p_attr_group_type = 'PO_REQ_LINE_EXT_ATTRS' THEN
1817: UPDATE PO_UDA_MAPPINGS
1818: SET REQ_LINE_GROUP_ID = p_real_attr_group_id
1819: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1820: ELSIF p_attr_group_type = 'PO_REQ_DIST_EXT_ATTRS' THEN
1821: UPDATE PO_UDA_MAPPINGS

Line 1821: UPDATE PO_UDA_MAPPINGS

1817: UPDATE PO_UDA_MAPPINGS
1818: SET REQ_LINE_GROUP_ID = p_real_attr_group_id
1819: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1820: ELSIF p_attr_group_type = 'PO_REQ_DIST_EXT_ATTRS' THEN
1821: UPDATE PO_UDA_MAPPINGS
1822: SET REQ_DISTRIBUTION_GROUP_ID = p_real_attr_group_id
1823: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1824: ELSIF p_attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN
1825: UPDATE PO_UDA_MAPPINGS

Line 1825: UPDATE PO_UDA_MAPPINGS

1821: UPDATE PO_UDA_MAPPINGS
1822: SET REQ_DISTRIBUTION_GROUP_ID = p_real_attr_group_id
1823: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1824: ELSIF p_attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN
1825: UPDATE PO_UDA_MAPPINGS
1826: SET PON_AUC_ITEM_PRICE_GROUP_ID = p_real_attr_group_id
1827: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1828: ELSIF p_attr_group_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN
1829: UPDATE PO_UDA_MAPPINGS

Line 1829: UPDATE PO_UDA_MAPPINGS

1825: UPDATE PO_UDA_MAPPINGS
1826: SET PON_AUC_ITEM_PRICE_GROUP_ID = p_real_attr_group_id
1827: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1828: ELSIF p_attr_group_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN
1829: UPDATE PO_UDA_MAPPINGS
1830: SET PON_AUC_HEADER_GROUP_ID = p_real_attr_group_id
1831: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1832: ELSIF p_attr_group_type = 'PON_BID_HDRS_EXT_ATTRS' THEN
1833: UPDATE PO_UDA_MAPPINGS

Line 1833: UPDATE PO_UDA_MAPPINGS

1829: UPDATE PO_UDA_MAPPINGS
1830: SET PON_AUC_HEADER_GROUP_ID = p_real_attr_group_id
1831: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1832: ELSIF p_attr_group_type = 'PON_BID_HDRS_EXT_ATTRS' THEN
1833: UPDATE PO_UDA_MAPPINGS
1834: SET BID_HEADER_GROUP_ID = p_real_attr_group_id
1835: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1836: ELSIF p_attr_group_type = 'PON_BID_PRICES_EXT_ATTRS' THEN
1837: UPDATE PO_UDA_MAPPINGS

Line 1837: UPDATE PO_UDA_MAPPINGS

1833: UPDATE PO_UDA_MAPPINGS
1834: SET BID_HEADER_GROUP_ID = p_real_attr_group_id
1835: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1836: ELSIF p_attr_group_type = 'PON_BID_PRICES_EXT_ATTRS' THEN
1837: UPDATE PO_UDA_MAPPINGS
1838: SET BID_ITEM_PRICE_GROUP_ID = p_real_attr_group_id
1839: WHERE dummy_attribute_group_id = p_dummy_attr_group_id;
1840: END IF;
1841: d_progress := 70;

Line 2218: DELETE FROM PO_UDA_MAPPINGS

2214: AND get_map_table_details(p_attribute_group_id, 'PON_AUC_HDRS_EXT_ATTRS') IS NULL
2215: AND get_map_table_details(p_attribute_group_id, 'PON_BID_HDRS_EXT_ATTRS') IS NULL
2216: AND get_map_table_details(p_attribute_group_id, 'PON_BID_PRICES_EXT_ATTRS') IS NULL)
2217: THEN
2218: DELETE FROM PO_UDA_MAPPINGS
2219: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2220: -- Deleting the data from the mapping table after the
2221: -- real attribute group is deleted and there are no real attribute groups
2222: -- left with the dummy

Line 2822: UPDATE PO_UDA_MAPPINGS

2818: PO_LOG.proc_begin(d_module, 'p_data_level_type', p_data_level_type);
2819: END IF;
2820:
2821: IF p_data_level_type = 'PO_HEADER_EXT_ATTRS' THEN
2822: UPDATE PO_UDA_MAPPINGS
2823: SET PO_HEADER_GROUP_ID = NULL
2824: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2825: ELSIF p_data_level_type = 'PO_LINE_EXT_ATTRS' THEN
2826: UPDATE PO_UDA_MAPPINGS

Line 2826: UPDATE PO_UDA_MAPPINGS

2822: UPDATE PO_UDA_MAPPINGS
2823: SET PO_HEADER_GROUP_ID = NULL
2824: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2825: ELSIF p_data_level_type = 'PO_LINE_EXT_ATTRS' THEN
2826: UPDATE PO_UDA_MAPPINGS
2827: SET PO_LINE_GROUP_ID = NULL
2828: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2829: ELSIF p_data_level_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN
2830: UPDATE PO_UDA_MAPPINGS

Line 2830: UPDATE PO_UDA_MAPPINGS

2826: UPDATE PO_UDA_MAPPINGS
2827: SET PO_LINE_GROUP_ID = NULL
2828: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2829: ELSIF p_data_level_type = 'PO_DISTRIBUTIONS_EXT_ATTRS' THEN
2830: UPDATE PO_UDA_MAPPINGS
2831: SET PO_DISTRIBUTIONS_GROUP_ID = NULL
2832: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2833: ELSIF p_data_level_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN
2834: UPDATE PO_UDA_MAPPINGS

Line 2834: UPDATE PO_UDA_MAPPINGS

2830: UPDATE PO_UDA_MAPPINGS
2831: SET PO_DISTRIBUTIONS_GROUP_ID = NULL
2832: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2833: ELSIF p_data_level_type = 'PO_SHIPMENTS_EXT_ATTRS' THEN
2834: UPDATE PO_UDA_MAPPINGS
2835: SET PO_SHIPMENTS_GROUP_ID = NULL
2836: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2837: ELSIF p_data_level_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN
2838: UPDATE PO_UDA_MAPPINGS

Line 2838: UPDATE PO_UDA_MAPPINGS

2834: UPDATE PO_UDA_MAPPINGS
2835: SET PO_SHIPMENTS_GROUP_ID = NULL
2836: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2837: ELSIF p_data_level_type = 'PO_REQ_HEADER_EXT_ATTRS' THEN
2838: UPDATE PO_UDA_MAPPINGS
2839: SET REQ_HEADER_GROUP_ID = NULL
2840: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2841: ELSIF p_data_level_type = 'PO_REQ_LINE_EXT_ATTRS' THEN
2842: UPDATE PO_UDA_MAPPINGS

Line 2842: UPDATE PO_UDA_MAPPINGS

2838: UPDATE PO_UDA_MAPPINGS
2839: SET REQ_HEADER_GROUP_ID = NULL
2840: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2841: ELSIF p_data_level_type = 'PO_REQ_LINE_EXT_ATTRS' THEN
2842: UPDATE PO_UDA_MAPPINGS
2843: SET REQ_LINE_GROUP_ID = NULL
2844: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2845: ELSIF p_data_level_type = 'PO_REQ_DIST_EXT_ATTRS' THEN
2846: UPDATE PO_UDA_MAPPINGS

Line 2846: UPDATE PO_UDA_MAPPINGS

2842: UPDATE PO_UDA_MAPPINGS
2843: SET REQ_LINE_GROUP_ID = NULL
2844: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2845: ELSIF p_data_level_type = 'PO_REQ_DIST_EXT_ATTRS' THEN
2846: UPDATE PO_UDA_MAPPINGS
2847: SET REQ_DISTRIBUTION_GROUP_ID = NULL
2848: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2849: ELSIF p_data_level_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN
2850: UPDATE PO_UDA_MAPPINGS

Line 2850: UPDATE PO_UDA_MAPPINGS

2846: UPDATE PO_UDA_MAPPINGS
2847: SET REQ_DISTRIBUTION_GROUP_ID = NULL
2848: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2849: ELSIF p_data_level_type = 'PON_AUC_PRICES_EXT_ATTRS' THEN
2850: UPDATE PO_UDA_MAPPINGS
2851: SET PON_AUC_ITEM_PRICE_GROUP_ID = NULL
2852: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2853: ELSIF p_data_level_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN
2854: UPDATE PO_UDA_MAPPINGS

Line 2854: UPDATE PO_UDA_MAPPINGS

2850: UPDATE PO_UDA_MAPPINGS
2851: SET PON_AUC_ITEM_PRICE_GROUP_ID = NULL
2852: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2853: ELSIF p_data_level_type = 'PON_AUC_HDRS_EXT_ATTRS' THEN
2854: UPDATE PO_UDA_MAPPINGS
2855: SET PON_AUC_HEADER_GROUP_ID = NULL
2856: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2857: ELSIF p_data_level_type = 'PON_BID_HDRS_EXT_ATTRS' THEN
2858: UPDATE PO_UDA_MAPPINGS

Line 2858: UPDATE PO_UDA_MAPPINGS

2854: UPDATE PO_UDA_MAPPINGS
2855: SET PON_AUC_HEADER_GROUP_ID = NULL
2856: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2857: ELSIF p_data_level_type = 'PON_BID_HDRS_EXT_ATTRS' THEN
2858: UPDATE PO_UDA_MAPPINGS
2859: SET BID_HEADER_GROUP_ID = NULL
2860: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2861: ELSIF p_data_level_type = 'PON_BID_PRICES_EXT_ATTRS' THEN
2862: UPDATE PO_UDA_MAPPINGS

Line 2862: UPDATE PO_UDA_MAPPINGS

2858: UPDATE PO_UDA_MAPPINGS
2859: SET BID_HEADER_GROUP_ID = NULL
2860: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2861: ELSIF p_data_level_type = 'PON_BID_PRICES_EXT_ATTRS' THEN
2862: UPDATE PO_UDA_MAPPINGS
2863: SET BID_ITEM_PRICE_GROUP_ID = NULL
2864: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2865: END IF;
2866:

Line 2935: FROM PO_UDA_MAPPINGS

2931: l_pon_auc_item_price_group_id,
2932: l_pon_auc_header_group_id,
2933: l_bid_header_group_id,
2934: l_bid_item_price_group_id
2935: FROM PO_UDA_MAPPINGS
2936: WHERE DUMMY_ATTRIBUTE_GROUP_ID = p_attribute_group_id;
2937:
2938: d_progress := 20;
2939: