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.10 2012/01/02 13:32:39 vkinduri ship $ */
3:
4: --Package Declarations
5:

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

1813: seq_stmt := NULL;
1814: x_seq_num := 0;
1815:
1816: x_stmt := ' SELECT ' ||
1817: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1818: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1819: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1820: ''''||G_fcategory||''''||' fcategory, ' ||
1821: ''''||G_tcategory||''''||' tcategory, ' ||

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

1814: x_seq_num := 0;
1815:
1816: x_stmt := ' SELECT ' ||
1817: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1818: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1819: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1820: ''''||G_fcategory||''''||' fcategory, ' ||
1821: ''''||G_tcategory||''''||' tcategory, ' ||
1822: ''''||G_fbuyer||''''||' fbuyer, ' ||

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

1815:
1816: x_stmt := ' SELECT ' ||
1817: ' gmpmpact.organization_code( '||G_orgnanization_id||') master_org, ' ||
1818: ' gmpmpact.schedule( '||G_schedule_id||') schedule, ' ||
1819: ' gmpmpact.category_set( '||G_category_set_id||') category_set, ' ||
1820: ''''||G_fcategory||''''||' fcategory, ' ||
1821: ''''||G_tcategory||''''||' tcategory, ' ||
1822: ''''||G_fbuyer||''''||' fbuyer, ' ||
1823: ''''||G_tbuyer||''''||' tbuyer, ' ||

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

1830: ''''||G_ftrans_date||''''||' fdate, ' ||
1831: ''''||G_ttrans_date||''''||' tdate, ' ||
1832: ' CURSOR( ' ||
1833: ' SELECT ' ||
1834: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

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

1831: ''''||G_ttrans_date||''''||' tdate, ' ||
1832: ' CURSOR( ' ||
1833: ' SELECT ' ||
1834: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

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

1832: ' CURSOR( ' ||
1833: ' SELECT ' ||
1834: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1840: ' gmpmpact.category(pmh.category_id) category, ' ||

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

1833: ' SELECT ' ||
1834: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1840: ' gmpmpact.category(pmh.category_id) category, ' ||
1841: ' CURSOR( ' ||

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

1834: ' gmpmpact.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1840: ' gmpmpact.category(pmh.category_id) category, ' ||
1841: ' CURSOR( ' ||
1842: ' SELECT pud.line_id line_id, ' ||

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

1835: ' gmpmpact.organization_code (pmh.organization_id) organization_code, ' ||
1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1840: ' gmpmpact.category(pmh.category_id) category, ' ||
1841: ' CURSOR( ' ||
1842: ' SELECT pud.line_id line_id, ' ||
1843: ' pud.matl_rep_id matl_rep_id, ' ||

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

1836: ' gmpmpact.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
1837: ' gmpmpact.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
1838: ' gmpmpact.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
1839: ' gmpmpact.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
1840: ' gmpmpact.category(pmh.category_id) category, ' ||
1841: ' CURSOR( ' ||
1842: ' SELECT pud.line_id line_id, ' ||
1843: ' pud.matl_rep_id matl_rep_id, ' ||
1844: ' pud.doc_type doc_type, ' ||

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

1850: ' pud.balance balance, ' ||
1851: ' pud.critical_ind critical_ind, ' ||
1852: ' pud.cust_vend cust_vend, ' ||
1853: ' pud.inventory_item_id inventory_item_id, ' ||
1854: ' gmpmpact.organization_code (pud.organization_id) organization_code ' ||
1855: ' FROM ps_ubkt_dtl pud ' ||
1856: ' WHERE pud.inventory_item_id = pmh.inventory_item_id ' ||
1857: ' AND pud.organization_id = pmh.organization_id ' ||
1858: ' AND pud.matl_rep_id = pmh.matl_rep_id ' ||

Line 2312: END GMPMPACT;

2308: WHEN OTHERS THEN
2309: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
2310: END;
2311:
2312: END GMPMPACT;