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.GMPMPACT dependencies on GMPMPACT

Line 1: PACKAGE BODY GMPMPACT AS

1: PACKAGE BODY GMPMPACT AS
2: /* $Header: GMPMPACB.pls 120.5 2008/01/17 06:05:47 vpedarla ship $ */
3:
4: --Package Declarations
5:

Line 1784: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||

1780: seq_stmt := NULL;
1781: x_seq_num := 0;
1782:
1783: x_stmt := ' SELECT ' ||
1784: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1785: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1786: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1787: ''''||G_fcategory||''''||' fcategory, ' ||
1788: ''''||G_tcategory||''''||' tcategory, ' ||

Line 1785: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||

1781: x_seq_num := 0;
1782:
1783: x_stmt := ' SELECT ' ||
1784: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1785: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1786: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1787: ''''||G_fcategory||''''||' fcategory, ' ||
1788: ''''||G_tcategory||''''||' tcategory, ' ||
1789: ''''||G_fbuyer||''''||' fbuyer, ' ||

Line 1786: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||

1782:
1783: x_stmt := ' SELECT ' ||
1784: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1785: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1786: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1787: ''''||G_fcategory||''''||' fcategory, ' ||
1788: ''''||G_tcategory||''''||' tcategory, ' ||
1789: ''''||G_fbuyer||''''||' fbuyer, ' ||
1790: ''''||G_tbuyer||''''||' tbuyer, ' ||

Line 1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||

1797: ''''||G_ftrans_date||''''||' fdate, ' ||
1798: ''''||G_ttrans_date||''''||' tdate, ' ||
1799: ' CURSOR( ' ||
1800: ' SELECT ' ||
1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

Line 1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||

1798: ''''||G_ttrans_date||''''||' tdate, ' ||
1799: ' CURSOR( ' ||
1800: ' SELECT ' ||
1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

Line 1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||

1799: ' CURSOR( ' ||
1800: ' SELECT ' ||
1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1807: ' gmpmpact.category(pmh.category_id) category, ' ||

Line 1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||

1800: ' SELECT ' ||
1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1807: ' gmpmpact.category(pmh.category_id) category, ' ||
1808: ' CURSOR( ' ||

Line 1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

1801: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1807: ' gmpmpact.category(pmh.category_id) category, ' ||
1808: ' CURSOR( ' ||
1809: ' SELECT pud.line_id line_id, ' ||

Line 1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

1802: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1807: ' gmpmpact.category(pmh.category_id) category, ' ||
1808: ' CURSOR( ' ||
1809: ' SELECT pud.line_id line_id, ' ||
1810: ' pud.matl_rep_id matl_rep_id, ' ||

Line 1807: ' gmpmpact.category(pmh.category_id) category, ' ||

1803: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1804: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1805: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1806: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1807: ' gmpmpact.category(pmh.category_id) category, ' ||
1808: ' CURSOR( ' ||
1809: ' SELECT pud.line_id line_id, ' ||
1810: ' pud.matl_rep_id matl_rep_id, ' ||
1811: ' pud.doc_type doc_type, ' ||

Line 1821: ' gmpmpact.organization_code (pud.organization_id) organization_code ' ||

1817: ' pud.balance balance, ' ||
1818: ' pud.critical_ind critical_ind, ' ||
1819: ' pud.cust_vend cust_vend, ' ||
1820: ' pud.inventory_item_id inventory_item_id, ' ||
1821: ' gmpmpact.organization_code (pud.organization_id) organization_code ' ||
1822: ' FROM ps_ubkt_dtl pud ' ||
1823: ' WHERE pud.inventory_item_id = pmh.inventory_item_id ' ||
1824: ' AND pud.organization_id = pmh.organization_id ' ||
1825: ' AND pud.matl_rep_id = pmh.matl_rep_id ' ||

Line 2249: END GMPMPACT;

2245: WHEN OTHERS THEN
2246: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
2247: END;
2248:
2249: END GMPMPACT;