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.PO_ASL_API_PUB dependencies on PO_ASL_ATTRIBUTES_GT

Line 159: DELETE FROM po_asl_attributes_gt;

155: --Empty GT tables
156: DELETE FROM po_approved_supplier_list_gt;
157: DELETE FROM po_asl_documents_gt ;
158: DELETE FROM chv_authorizations_gt;
159: DELETE FROM po_asl_attributes_gt;
160: DELETE FROM po_supplier_item_capacity_gt;
161: DELETE FROM po_supplier_item_tolerance_gt;
162:
163: --generate the session key.

Line 205: FROM po_asl_attributes_gt

201: l_progress := 30;
202: --Raise exception in case user_key not found in parent table
203: SELECT Count(*)
204: INTO invalids
205: FROM po_asl_attributes_gt
206: WHERE user_key NOT IN
207: (SELECT user_key
208: FROM po_approved_supplier_list_gt);
209:

Line 376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: x_return_msg := 'Unexpected while dumping to po_approved_supplier_list_gt';
374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN

Line 378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';

374:
375: WHEN unexp_err_paa THEN
376: po_asl_api_pvt.log('Unexpected while dumping to po_asl_attributes_gt');
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: x_return_msg := 'Unexpected while dumping to po_asl_attributes_gt';
379:
380: WHEN unexp_err_pad THEN
381: po_asl_api_pvt.log('Unexpected while dumping to po_asl_documents_gt');
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 460: --updating po_asl_attributes_gt to derive id fields

456: x_return_msg => x_return_msg
457: );
458: l_progress := 25;
459:
460: --updating po_asl_attributes_gt to derive id fields
461: derive_ids_asl_attr(
462: x_return_status => x_return_status,
463: x_return_msg => x_return_msg
464: );

Line 695: -- this will dump all the data from p_asl_attr_rec to po_asl_attributes_gt

691:
692: --NAME: dump_to_asl_attr_gtt
693:
694: --FUNCTION:
695: -- this will dump all the data from p_asl_attr_rec to po_asl_attributes_gt
696:
697: --parameters:
698:
699: --IN:

Line 722: INSERT INTO po_asl_attributes_gt (

718: po_asl_api_pvt.log(p_asl_attr_rec);
719: x_return_msg := NULL;
720:
721: FORALL l_index IN 1 .. p_asl_attr_rec.user_key.Count
722: INSERT INTO po_asl_attributes_gt (
723: session_key ,
724: user_key ,
725: process_action ,
726: asl_id ,

Line 1639: -- this will derive ids for the display fields in po_asl_attributes_gt

1635:
1636: --NAME: derive_ids_asl_attr
1637:
1638: --FUNCTION:
1639: -- this will derive ids for the display fields in po_asl_attributes_gt
1640: -- which ever applicabale
1641:
1642: --parameters:
1643:

Line 1661: UPDATE po_asl_attributes_gt paa

1657:
1658: BEGIN
1659: po_asl_api_pvt.log('START ::: derive_ids_asl_attr');
1660:
1661: UPDATE po_asl_attributes_gt paa
1662: SET paa.using_organization_id =
1663: (SELECT hout.organization_id
1664: FROM hr_all_organization_units_tl hout
1665: WHERE hout.name = paa.using_organization_dsp

Line 1671: UPDATE po_asl_attributes_gt paa

1667: AND ROWNUM < 2)
1668: WHERE paa.using_organization_dsp IS NOT NULL;
1669: l_progress := 10;
1670:
1671: UPDATE po_asl_attributes_gt paa
1672: SET paa.release_generation_method =
1673: (SELECT polc.lookup_code
1674: FROM po_lookup_codes polc
1675: WHERE polc.lookup_type = 'DOC GENERATION METHOD'

Line 1681: UPDATE po_asl_attributes_gt paa

1677: AND ROWNUM < 2)
1678: WHERE paa.release_generation_method_dsp IS NOT NULL;
1679: l_progress := 15;
1680:
1681: UPDATE po_asl_attributes_gt paa
1682: SET paa.plan_schedule_type =
1683: (SELECT polc.lookup_code
1684: FROM po_lookup_codes polc
1685: WHERE polc.lookup_type = 'PLAN_SCHEDULE_SUBTYPE'

Line 1691: UPDATE po_asl_attributes_gt paa

1687: AND ROWNUM < 2)
1688: WHERE paa.plan_schedule_type_dsp IS NOT NULL;
1689: l_progress := 20;
1690:
1691: UPDATE po_asl_attributes_gt paa
1692: SET paa.ship_schedule_type =
1693: (SELECT polc.lookup_code
1694: FROM po_lookup_codes polc
1695: WHERE polc.lookup_type = 'SHIP_SCHEDULE_SUBTYPE'

Line 1701: UPDATE po_asl_attributes_gt paa

1697: AND ROWNUM < 2)
1698: WHERE paa.ship_schedule_type_dsp IS NOT NULL;
1699: l_progress := 25;
1700:
1701: UPDATE po_asl_attributes_gt paa
1702: SET paa.plan_bucket_pattern_id =
1703: (SELECT cbp.bucket_pattern_id
1704: FROM chv_bucket_patterns cbp
1705: WHERE cbp.bucket_pattern_name = paa.plan_bucket_pattern_dsp

Line 1710: UPDATE po_asl_attributes_gt paa

1706: AND ROWNUM < 2)
1707: WHERE paa.plan_bucket_pattern_dsp IS NOT NULL;
1708: l_progress := 30;
1709:
1710: UPDATE po_asl_attributes_gt paa
1711: SET paa.ship_bucket_pattern_id =
1712: (SELECT cbp.bucket_pattern_id
1713: FROM chv_bucket_patterns cbp
1714: WHERE cbp.bucket_pattern_name = paa.ship_bucket_pattern_dsp

Line 1719: UPDATE po_asl_attributes_gt paa

1715: AND ROWNUM < 2)
1716: WHERE paa.ship_bucket_pattern_dsp IS NOT NULL;
1717: l_progress := 35;
1718:
1719: UPDATE po_asl_attributes_gt paa
1720: SET paa.scheduler_id =
1721: (SELECT ppf.person_id
1722: FROM per_people_f ppf
1723: WHERE ppf.full_name = paa.scheduler_dsp

Line 1728: UPDATE po_asl_attributes_gt paa

1724: AND ROWNUM < 2)
1725: WHERE paa.scheduler_dsp IS NOT NULL;
1726: l_progress := 40;
1727:
1728: UPDATE po_asl_attributes_gt paa
1729: SET paa.vendor_id =
1730: (SELECT pv.vendor_id
1731: FROM po_vendors pv
1732: WHERE pv.vendor_name = paa.vendor_dsp

Line 1737: UPDATE po_asl_attributes_gt paa

1733: AND ROWNUM < 2)
1734: WHERE paa.vendor_dsp IS NOT NULL;
1735: l_progress := 50;
1736:
1737: UPDATE po_asl_attributes_gt paa
1738: SET paa.vendor_site_id =
1739: (SELECT pvs.vendor_site_id
1740: FROM po_vendor_sites_all pvs
1741: WHERE pvs.vendor_site_code = paa.vendor_site_dsp

Line 1751: UPDATE po_asl_attributes_gt paa

1747: AND ROWNUM < 2)
1748: WHERE paa.vendor_site_dsp IS NOT NULL;
1749: l_progress := 60;
1750:
1751: UPDATE po_asl_attributes_gt paa
1752: SET paa.item_id =
1753: (SELECT msi.inventory_item_id
1754: FROM mtl_system_items_kfv msi
1755: WHERE msi.concatenated_segments= paa.item_dsp

Line 1760: UPDATE po_asl_attributes_gt paa

1756: AND ROWNUM < 2)
1757: WHERE paa.item_dsp IS NOT NULL;
1758: l_progress := 70;
1759:
1760: UPDATE po_asl_attributes_gt paa
1761: SET paa.category_id =
1762: (SELECT mc.category_id
1763: FROM mtl_categories_kfv mc
1764: WHERE mc.concatenated_segments = paa.category_dsp

Line 1769: UPDATE po_asl_attributes_gt paa

1765: AND ROWNUM < 2)
1766: WHERE paa.category_dsp IS NOT NULL;
1767: l_progress := 80;
1768:
1769: UPDATE po_asl_attributes_gt paa
1770: SET paa.vmi_replenishment_approval =
1771: Decode(paa.vmi_replenishment_approval_dsp,
1772: 'Supplier or Buyer', 'SUPPLIER_OR_BUYER',
1773: 'None' , 'NONE',

Line 1778: UPDATE po_asl_attributes_gt paa

1774: 'Buyer' , 'BUYER')
1775: WHERE paa.vmi_replenishment_approval_dsp IS NOT NULL;
1776: l_progress := 90;
1777:
1778: UPDATE po_asl_attributes_gt paa
1779: SET paa.replenishment_method =
1780: Decode(paa.replenishment_method_dsp,
1781: 'Min - Max Quantities' , 1,
1782: 'Min - Max Days' , 2,

Line 1788: po_asl_api_pvt.log('derive_ids_asl_attr UPDATE po_asl_attributes_gt rowcount:'

1784: 'Min Days and Fixed Order Qty' , 4)
1785: WHERE paa.replenishment_method_dsp IS NOT NULL;
1786: l_progress := 100;
1787:
1788: po_asl_api_pvt.log('derive_ids_asl_attr UPDATE po_asl_attributes_gt rowcount:'
1789: || l_progress || ';' || SQL%ROWCOUNT);
1790: po_asl_api_pvt.log('END ::: derive_ids_asl_attr');
1791: EXCEPTION
1792:

Line 2066: -- in po_asl_attributes_gt table.

2062: --NAME: collect_invalids_in_aslattr_gt
2063:
2064: --FUNCTION:
2065: -- This will collect userkeys for which ids not found for the descriptions
2066: -- in po_asl_attributes_gt table.
2067:
2068: --PARAMETERS:
2069: --OUT:
2070: -- x_return_status VARCHAR2

Line 2102: 'po_asl_attributes_gt' AS entity ,

2098: l_entity_name ,
2099: l_reject_reason
2100: FROM (
2101: SELECT user_key ,
2102: 'po_asl_attributes_gt' AS entity ,
2103: fnd_message.get_string('PO','REL_GEN_METHOD_NOT_FOUND') AS msg
2104: FROM po_asl_attributes_gt
2105: WHERE release_generation_method_dsp IS NOT NULL
2106: AND release_generation_method IS NULL

Line 2104: FROM po_asl_attributes_gt

2100: FROM (
2101: SELECT user_key ,
2102: 'po_asl_attributes_gt' AS entity ,
2103: fnd_message.get_string('PO','REL_GEN_METHOD_NOT_FOUND') AS msg
2104: FROM po_asl_attributes_gt
2105: WHERE release_generation_method_dsp IS NOT NULL
2106: AND release_generation_method IS NULL
2107:
2108: UNION ALL

Line 2111: 'po_asl_attributes_gt' AS entity ,

2107:
2108: UNION ALL
2109:
2110: SELECT user_key ,
2111: 'po_asl_attributes_gt' AS entity ,
2112: fnd_message.get_string('PO','PLAN_SCHEDULE_NOT_FOUND') AS msg
2113: FROM po_asl_attributes_gt
2114: WHERE plan_schedule_type_dsp IS NOT NULL
2115: AND plan_schedule_type IS NULL

Line 2113: FROM po_asl_attributes_gt

2109:
2110: SELECT user_key ,
2111: 'po_asl_attributes_gt' AS entity ,
2112: fnd_message.get_string('PO','PLAN_SCHEDULE_NOT_FOUND') AS msg
2113: FROM po_asl_attributes_gt
2114: WHERE plan_schedule_type_dsp IS NOT NULL
2115: AND plan_schedule_type IS NULL
2116:
2117: UNION ALL

Line 2120: 'po_asl_attributes_gt' AS entity ,

2116:
2117: UNION ALL
2118:
2119: SELECT user_key ,
2120: 'po_asl_attributes_gt' AS entity ,
2121: fnd_message.get_string('PO','SHIP_SCHEDULE_NOT_FOUND') AS msg
2122: FROM po_asl_attributes_gt
2123: WHERE ship_schedule_type_dsp IS NOT NULL
2124: AND ship_schedule_type IS NULL

Line 2122: FROM po_asl_attributes_gt

2118:
2119: SELECT user_key ,
2120: 'po_asl_attributes_gt' AS entity ,
2121: fnd_message.get_string('PO','SHIP_SCHEDULE_NOT_FOUND') AS msg
2122: FROM po_asl_attributes_gt
2123: WHERE ship_schedule_type_dsp IS NOT NULL
2124: AND ship_schedule_type IS NULL
2125:
2126: UNION ALL

Line 2129: 'po_asl_attributes_gt' AS entity ,

2125:
2126: UNION ALL
2127:
2128: SELECT user_key ,
2129: 'po_asl_attributes_gt' AS entity ,
2130: fnd_message.get_string('PO','PLAN_BUCKET_NOT_FOUND') AS msg
2131: FROM po_asl_attributes_gt
2132: WHERE plan_bucket_pattern_dsp IS NOT NULL
2133: AND plan_bucket_pattern_id IS NULL

Line 2131: FROM po_asl_attributes_gt

2127:
2128: SELECT user_key ,
2129: 'po_asl_attributes_gt' AS entity ,
2130: fnd_message.get_string('PO','PLAN_BUCKET_NOT_FOUND') AS msg
2131: FROM po_asl_attributes_gt
2132: WHERE plan_bucket_pattern_dsp IS NOT NULL
2133: AND plan_bucket_pattern_id IS NULL
2134:
2135: UNION ALL

Line 2138: 'po_asl_attributes_gt' AS entity ,

2134:
2135: UNION ALL
2136:
2137: SELECT user_key ,
2138: 'po_asl_attributes_gt' AS entity ,
2139: fnd_message.get_string('PO','SHIP_BUCKET_NOT_FOUND') AS msg
2140: FROM po_asl_attributes_gt
2141: WHERE ship_bucket_pattern_dsp IS NOT NULL
2142: AND ship_bucket_pattern_id IS NULL);

Line 2140: FROM po_asl_attributes_gt

2136:
2137: SELECT user_key ,
2138: 'po_asl_attributes_gt' AS entity ,
2139: fnd_message.get_string('PO','SHIP_BUCKET_NOT_FOUND') AS msg
2140: FROM po_asl_attributes_gt
2141: WHERE ship_bucket_pattern_dsp IS NOT NULL
2142: AND ship_bucket_pattern_id IS NULL);
2143: l_progress := 10;
2144:

Line 2154: 'po_asl_attributes_gt' AS entity ,

2150: l_entity_name1 ,
2151: l_reject_reason1
2152: FROM (
2153: SELECT user_key ,
2154: 'po_asl_attributes_gt' AS entity ,
2155: fnd_message.get_string('PO','SHCEDULER_NOT_FOUND') AS msg
2156: FROM po_asl_attributes_gt
2157: WHERE scheduler_dsp IS NOT NULL
2158: AND scheduler_id IS NULL

Line 2156: FROM po_asl_attributes_gt

2152: FROM (
2153: SELECT user_key ,
2154: 'po_asl_attributes_gt' AS entity ,
2155: fnd_message.get_string('PO','SHCEDULER_NOT_FOUND') AS msg
2156: FROM po_asl_attributes_gt
2157: WHERE scheduler_dsp IS NOT NULL
2158: AND scheduler_id IS NULL
2159:
2160: UNION ALL

Line 2163: 'po_asl_attributes_gt' AS entity ,

2159:
2160: UNION ALL
2161:
2162: SELECT user_key ,
2163: 'po_asl_attributes_gt' AS entity ,
2164: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
2165: FROM po_asl_attributes_gt
2166: WHERE vendor_dsp IS NOT NULL
2167: AND vendor_id IS NULL

Line 2165: FROM po_asl_attributes_gt

2161:
2162: SELECT user_key ,
2163: 'po_asl_attributes_gt' AS entity ,
2164: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
2165: FROM po_asl_attributes_gt
2166: WHERE vendor_dsp IS NOT NULL
2167: AND vendor_id IS NULL
2168:
2169: UNION ALL

Line 2172: 'po_asl_attributes_gt' AS entity ,

2168:
2169: UNION ALL
2170:
2171: SELECT user_key ,
2172: 'po_asl_attributes_gt' AS entity ,
2173: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
2174: FROM po_asl_attributes_gt
2175: WHERE item_dsp IS NOT NULL
2176: AND item_id IS NULL

Line 2174: FROM po_asl_attributes_gt

2170:
2171: SELECT user_key ,
2172: 'po_asl_attributes_gt' AS entity ,
2173: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
2174: FROM po_asl_attributes_gt
2175: WHERE item_dsp IS NOT NULL
2176: AND item_id IS NULL
2177:
2178: UNION ALL

Line 2181: 'po_asl_attributes_gt' AS entity ,

2177:
2178: UNION ALL
2179:
2180: SELECT user_key ,
2181: 'po_asl_attributes_gt' AS entity ,
2182: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2183: FROM po_asl_attributes_gt
2184: WHERE category_dsp IS NOT NULL
2185: AND category_id IS NULL

Line 2183: FROM po_asl_attributes_gt

2179:
2180: SELECT user_key ,
2181: 'po_asl_attributes_gt' AS entity ,
2182: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2183: FROM po_asl_attributes_gt
2184: WHERE category_dsp IS NOT NULL
2185: AND category_id IS NULL
2186:
2187: UNION ALL

Line 2190: 'po_asl_attributes_gt' AS entity ,

2186:
2187: UNION ALL
2188:
2189: SELECT user_key ,
2190: 'po_asl_attributes_gt' AS entity ,
2191: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2192: FROM po_asl_attributes_gt
2193: WHERE vendor_site_dsp IS NOT NULL
2194: AND vendor_site_id IS NULL

Line 2192: FROM po_asl_attributes_gt

2188:
2189: SELECT user_key ,
2190: 'po_asl_attributes_gt' AS entity ,
2191: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2192: FROM po_asl_attributes_gt
2193: WHERE vendor_site_dsp IS NOT NULL
2194: AND vendor_site_id IS NULL
2195:
2196: UNION ALL

Line 2199: 'po_asl_attributes_gt' AS entity ,

2195:
2196: UNION ALL
2197:
2198: SELECT user_key ,
2199: 'po_asl_attributes_gt' AS entity ,
2200: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2201: FROM po_asl_attributes_gt
2202: WHERE using_organization_dsp IS NOT NULL
2203: AND using_organization_id IS NULL);

Line 2201: FROM po_asl_attributes_gt

2197:
2198: SELECT user_key ,
2199: 'po_asl_attributes_gt' AS entity ,
2200: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2201: FROM po_asl_attributes_gt
2202: WHERE using_organization_dsp IS NOT NULL
2203: AND using_organization_id IS NULL);
2204:
2205: l_progress := 25;

Line 2219: 'po_asl_attributes_gt' AS entity ,

2215: l_entity_name ,
2216: l_reject_reason
2217: FROM (
2218: SELECT user_key ,
2219: 'po_asl_attributes_gt' AS entity ,
2220: fnd_message.get_string('PO','REPL_APPROVAL_NOT_FOUND') AS msg
2221: FROM po_asl_attributes_gt
2222: WHERE vmi_replenishment_approval_dsp IS NOT NULL
2223: AND vmi_replenishment_approval IS NULL

Line 2221: FROM po_asl_attributes_gt

2217: FROM (
2218: SELECT user_key ,
2219: 'po_asl_attributes_gt' AS entity ,
2220: fnd_message.get_string('PO','REPL_APPROVAL_NOT_FOUND') AS msg
2221: FROM po_asl_attributes_gt
2222: WHERE vmi_replenishment_approval_dsp IS NOT NULL
2223: AND vmi_replenishment_approval IS NULL
2224:
2225: UNION ALL

Line 2228: 'po_asl_attributes_gt' AS entity ,

2224:
2225: UNION ALL
2226:
2227: SELECT user_key ,
2228: 'po_asl_attributes_gt' AS entity ,
2229: fnd_message.get_string('PO','REPL_METHOD_NOT_FOUND') AS msg
2230: FROM po_asl_attributes_gt
2231: WHERE replenishment_method_dsp IS NOT NULL
2232: AND replenishment_method IS NULL

Line 2230: FROM po_asl_attributes_gt

2226:
2227: SELECT user_key ,
2228: 'po_asl_attributes_gt' AS entity ,
2229: fnd_message.get_string('PO','REPL_METHOD_NOT_FOUND') AS msg
2230: FROM po_asl_attributes_gt
2231: WHERE replenishment_method_dsp IS NOT NULL
2232: AND replenishment_method IS NULL
2233:
2234: UNION ALL

Line 2237: 'po_asl_attributes_gt' AS entity ,

2233:
2234: UNION ALL
2235: --Reject records if process action is other than ADD,UPDATE,DELETE
2236: SELECT user_key ,
2237: 'po_asl_attributes_gt' AS entity ,
2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,

Line 2239: FROM po_asl_attributes_gt

2235: --Reject records if process action is other than ADD,UPDATE,DELETE
2236: SELECT user_key ,
2237: 'po_asl_attributes_gt' AS entity ,
2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,
2242: PO_ASL_API_PUB.g_ACTION_UPDATE,
2243: PO_ASL_API_PUB.g_ACTION_DELETE)

Line 2250: 'po_asl_attributes_gt' AS entity ,

2246: UNION ALL
2247: --Reject records if ASL Process action is create and attribute's process
2248: --action is delete/update
2249: SELECT PAA.user_key ,
2250: 'po_asl_attributes_gt' AS entity ,
2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg
2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key

Line 2252: FROM po_asl_attributes_gt PAA,

2248: --action is delete/update
2249: SELECT PAA.user_key ,
2250: 'po_asl_attributes_gt' AS entity ,
2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg
2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key
2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
2256: AND PAA.process_action <> PO_ASL_API_PUB.g_ACTION_ADD