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_GRP dependencies on PO_SUPPLIER_ITEM_CAPACITY

Line 147: UPDATE po_supplier_item_capacity_gt PSIC

143:
144: l_progress := 30;
145: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
146:
147: UPDATE po_supplier_item_capacity_gt PSIC
148: SET asl_id = (SELECT asl_id
149: FROM po_approved_supplier_list_gt PASL
150: WHERE PASL.user_key = PSIC.user_key
151: AND ROWNUM < 2);

Line 167: UPDATE po_supplier_item_capacity_gt PSIC

163: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
164:
165: /*--Populate capacity id in case of update and
166: --Capacity's process action is ADD
167: UPDATE po_supplier_item_capacity_gt PSIC
168: SET capacity_id = po_supplier_item_capacity_s.NEXTVAL
169: WHERE process_action = PO_ASL_API_PUB.g_ACTION_ADD;
170: l_progress := 42;
171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/

Line 168: SET capacity_id = po_supplier_item_capacity_s.NEXTVAL

164:
165: /*--Populate capacity id in case of update and
166: --Capacity's process action is ADD
167: UPDATE po_supplier_item_capacity_gt PSIC
168: SET capacity_id = po_supplier_item_capacity_s.NEXTVAL
169: WHERE process_action = PO_ASL_API_PUB.g_ACTION_ADD;
170: l_progress := 42;
171: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);*/
172:

Line 454: --Duplicate check is not required for po_supplier_item_capacity_gt

450: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE
451: AND CHVGT.process_action = PO_ASL_API_PUB.g_ACTION_ADD;
452:
453: --*************************************************************************
454: --Duplicate check is not required for po_supplier_item_capacity_gt
455: --as there is a check in the validation for dates overlapping. That check
456: --covers the duplication as well
457: --*************************************************************************
458:

Line 466: 'po_supplier_item_capacity_gt' ,

462: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
463: --Reject records if capacity process mode is delete, asl mode is update
464: --and record does not exist for that org
465: SELECT CAPGT.user_key ,
466: 'po_supplier_item_capacity_gt' ,
467: fnd_message.get_string('PO','CAPACITY_NOT_EXIST')
468: BULK COLLECT INTO
469: l_user_key_tbl ,
470: l_entity_name ,

Line 472: FROM po_supplier_item_capacity_gt CAPGT ,

468: BULK COLLECT INTO
469: l_user_key_tbl ,
470: l_entity_name ,
471: l_reject_reason
472: FROM po_supplier_item_capacity_gt CAPGT ,
473: po_approved_supplier_list_gt ASLGT
474: WHERE NOT EXISTS
475: (SELECT 1
476: FROM po_supplier_item_capacity CAP

Line 476: FROM po_supplier_item_capacity CAP

472: FROM po_supplier_item_capacity_gt CAPGT ,
473: po_approved_supplier_list_gt ASLGT
474: WHERE NOT EXISTS
475: (SELECT 1
476: FROM po_supplier_item_capacity CAP
477: WHERE CAPGT.asl_id = CAP.asl_id
478: AND CAPGT.using_organization_id = CAP.using_organization_id
479: AND Nvl(CAPGT.to_date_dsp, SYSDATE) =
480: Nvl(CAP.to_date, SYSDATE)

Line 827: FROM po_supplier_item_capacity_gt PSIC

823: AND PAD.user_key = ASLGT.user_key)
824: OR
825: EXISTS
826: (SELECT 1
827: FROM po_supplier_item_capacity_gt PSIC
828: WHERE PSIC.asl_id = ASLGT.asl_id
829: AND PSIC.user_key = ASLGT.user_key)
830: OR
831: EXISTS

Line 1007: --Reject records if there is an entry in po_supplier_item_capacity_gt

1003: AND (PAAGT.ship_schedule_type IS NULL
1004: OR Trim(PAAGT.ship_schedule_type) = '')
1005:
1006: UNION ALL
1007: --Reject records if there is an entry in po_supplier_item_capacity_gt
1008: -- when global_flag is N and VMI flag is not checked
1009: SELECT PAAGT.user_key ,
1010: 'po_asl_attributes_gt' AS entity ,
1011: fnd_message.get_string('PO','INVALID_SUPP_ITEM_CAP_ENTRY') AS msg

Line 1019: FROM po_supplier_item_capacity_gt PSIC

1015: AND ASLGT.using_organization_id <> -1
1016: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1017: AND EXISTS
1018: (SELECT 1
1019: FROM po_supplier_item_capacity_gt PSIC
1020: WHERE PSIC.asl_id = PAAGT.asl_id
1021: AND PSIC.using_organization_id= PAAGT.using_organization_id
1022: AND PSIC.user_key = PAAGT.user_key
1023: AND PSIC.process_action = PO_ASL_API_PUB.g_ACTION_ADD)

Line 1707: -- This will validate data in po_supplier_item_capacity_gt table

1703:
1704: --Name: validate_supp_item_cap_gt
1705:
1706: --Function:
1707: -- This will validate data in po_supplier_item_capacity_gt table
1708:
1709: --Parameters:
1710:
1711: --OUT:

Line 1744: 'po_supplier_item_capacity_gt' AS entity ,

1740: l_reject_reason
1741: FROM (
1742: --Reject records if from_date is less than current date
1743: SELECT user_key ,
1744: 'po_supplier_item_capacity_gt' AS entity ,
1745: fnd_message.get_string('PO','INVALID_FROM_DATE') AS msg
1746: FROM po_supplier_item_capacity_gt PSICGT
1747: WHERE (PSICGT.from_date_dsp IS NULL
1748: OR PSICGT.from_date_dsp < SYSDATE)

Line 1746: FROM po_supplier_item_capacity_gt PSICGT

1742: --Reject records if from_date is less than current date
1743: SELECT user_key ,
1744: 'po_supplier_item_capacity_gt' AS entity ,
1745: fnd_message.get_string('PO','INVALID_FROM_DATE') AS msg
1746: FROM po_supplier_item_capacity_gt PSICGT
1747: WHERE (PSICGT.from_date_dsp IS NULL
1748: OR PSICGT.from_date_dsp < SYSDATE)
1749: AND PSICGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1750:

Line 1754: 'po_supplier_item_capacity_gt' AS entity ,

1750:
1751: UNION ALL
1752: --Reject records if to_date is less than current date or from_date
1753: SELECT user_key ,
1754: 'po_supplier_item_capacity_gt' AS entity ,
1755: fnd_message.get_string('PO','INVALID_TO_DATE') AS msg
1756: FROM po_supplier_item_capacity_gt PSICGT
1757: WHERE PSICGT.to_date_dsp < SYSDATE
1758: OR PSICGT.to_date_dsp < PSICGT.from_date_dsp

Line 1756: FROM po_supplier_item_capacity_gt PSICGT

1752: --Reject records if to_date is less than current date or from_date
1753: SELECT user_key ,
1754: 'po_supplier_item_capacity_gt' AS entity ,
1755: fnd_message.get_string('PO','INVALID_TO_DATE') AS msg
1756: FROM po_supplier_item_capacity_gt PSICGT
1757: WHERE PSICGT.to_date_dsp < SYSDATE
1758: OR PSICGT.to_date_dsp < PSICGT.from_date_dsp
1759:
1760: UNION ALL

Line 1763: 'po_supplier_item_capacity_gt' ,

1759:
1760: UNION ALL
1761: --Reject records if capacity is less than 1
1762: SELECT user_key ,
1763: 'po_supplier_item_capacity_gt' ,
1764: fnd_message.get_string('PO','INVALID_CAPACITY_PER_DAY') AS msg
1765: FROM po_supplier_item_capacity_gt PSICGT
1766: WHERE PSICGT.capacity_per_day_dsp IS NULL
1767: OR PSICGT.capacity_per_day_dsp <= 0);

Line 1765: FROM po_supplier_item_capacity_gt PSICGT

1761: --Reject records if capacity is less than 1
1762: SELECT user_key ,
1763: 'po_supplier_item_capacity_gt' ,
1764: fnd_message.get_string('PO','INVALID_CAPACITY_PER_DAY') AS msg
1765: FROM po_supplier_item_capacity_gt PSICGT
1766: WHERE PSICGT.capacity_per_day_dsp IS NULL
1767: OR PSICGT.capacity_per_day_dsp <= 0);
1768:
1769: l_progress := 20;

Line 1775: 'po_supplier_item_capacity_gt' AS entity ,

1771: l_entity_name1 := l_entity_name;
1772: l_reject_reason1 := l_reject_reason;
1773:
1774: SELECT PSICGT.user_key ,
1775: 'po_supplier_item_capacity_gt' AS entity ,
1776: fnd_message.get_string('PO','DATES_OVERLAPPED') AS msg
1777: BULK COLLECT INTO
1778: l_user_key_tbl ,
1779: l_entity_name ,

Line 1781: FROM po_supplier_item_capacity_gt PSICGT ,

1777: BULK COLLECT INTO
1778: l_user_key_tbl ,
1779: l_entity_name ,
1780: l_reject_reason
1781: FROM po_supplier_item_capacity_gt PSICGT ,
1782: po_approved_supplier_list_gt ASLGT
1783: WHERE 2 <= (SELECT Count(user_key)
1784: FROM po_supplier_item_capacity_gt PSIC
1785: WHERE (PSICGT.from_date_dsp

Line 1784: FROM po_supplier_item_capacity_gt PSIC

1780: l_reject_reason
1781: FROM po_supplier_item_capacity_gt PSICGT ,
1782: po_approved_supplier_list_gt ASLGT
1783: WHERE 2 <= (SELECT Count(user_key)
1784: FROM po_supplier_item_capacity_gt PSIC
1785: WHERE (PSICGT.from_date_dsp
1786: BETWEEN PSIC.from_date_dsp AND PSIC.to_date_dsp
1787: OR PSICGT.to_date_dsp
1788: BETWEEN PSIC.from_date_dsp AND PSIC.to_date_dsp)

Line 1801: 'po_supplier_item_capacity_gt' AS entity ,

1797: l_entity_name1 := l_entity_name1 MULTISET UNION ALL l_entity_name ;
1798: l_reject_reason1 := l_reject_reason1 MULTISET UNION ALL l_reject_reason;
1799: --Reject records if dates overlapped when update
1800: SELECT PSICGT.user_key ,
1801: 'po_supplier_item_capacity_gt' AS entity ,
1802: fnd_message.get_string('PO','DATES_OVERLAPPED') AS msg
1803: BULK COLLECT INTO
1804: l_user_key_tbl ,
1805: l_entity_name ,

Line 1807: FROM po_supplier_item_capacity_gt PSICGT ,

1803: BULK COLLECT INTO
1804: l_user_key_tbl ,
1805: l_entity_name ,
1806: l_reject_reason
1807: FROM po_supplier_item_capacity_gt PSICGT ,
1808: po_approved_supplier_list_gt ASLGT
1809: WHERE EXISTS
1810: (SELECT 1
1811: FROM po_supplier_item_capacity PSIC

Line 1811: FROM po_supplier_item_capacity PSIC

1807: FROM po_supplier_item_capacity_gt PSICGT ,
1808: po_approved_supplier_list_gt ASLGT
1809: WHERE EXISTS
1810: (SELECT 1
1811: FROM po_supplier_item_capacity PSIC
1812: WHERE (PSICGT.from_date_dsp
1813: BETWEEN PSIC.from_date AND PSIC.To_Date
1814: OR PSICGT.to_date_dsp
1815: BETWEEN PSIC.from_date AND PSIC.To_Date)