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

Line 1: PACKAGE BODY GMPPSRP as

1: PACKAGE BODY GMPPSRP as
2: /* $Header: GMPPSRPB.pls 120.6.12020000.1 2012/06/27 15:08:03 appldev ship $ */
3:
4: --Package Declarations
5:

Line 2: /* $Header: GMPPSRPB.pls 120.6.12020000.1 2012/06/27 15:08:03 appldev ship $ */

1: PACKAGE BODY GMPPSRP as
2: /* $Header: GMPPSRPB.pls 120.6.12020000.1 2012/06/27 15:08:03 appldev ship $ */
3:
4: --Package Declarations
5:
6: PROCEDURE ps_insert_header ;

Line 666: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||

662: seq_stmt := NULL;
663: x_seq_num := 0;
664:
665: x_stmt := ' SELECT ' ||
666: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
667: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
668: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
669: ''''||G_fcategory||''''||' fcategory, ' ||
670: ''''||G_tcategory||''''||' tcategory, ' ||

Line 667: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||

663: x_seq_num := 0;
664:
665: x_stmt := ' SELECT ' ||
666: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
667: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
668: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
669: ''''||G_fcategory||''''||' fcategory, ' ||
670: ''''||G_tcategory||''''||' tcategory, ' ||
671: ''''||G_fbuyer||''''||' fbuyer, ' ||

Line 668: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||

664:
665: x_stmt := ' SELECT ' ||
666: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
667: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
668: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
669: ''''||G_fcategory||''''||' fcategory, ' ||
670: ''''||G_tcategory||''''||' tcategory, ' ||
671: ''''||G_fbuyer||''''||' fbuyer, ' ||
672: ''''||G_tbuyer||''''||' tbuyer, ' ||

Line 681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||

677: ''''||G_fitem||''''||' fitem, ' ||
678: ''''||G_titem||''''||' titem, ' ||
679: ' CURSOR( ' ||
680: ' SELECT ' ||
681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

Line 682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||

678: ''''||G_titem||''''||' titem, ' ||
679: ' CURSOR( ' ||
680: ' SELECT ' ||
681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

Line 683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||

679: ' CURSOR( ' ||
680: ' SELECT ' ||
681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
687: ' gmppsrp.category(pmh.category_id) category, ' ||

Line 684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||

680: ' SELECT ' ||
681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
687: ' gmppsrp.category(pmh.category_id) category, ' ||
688: ' CURSOR( ' ||

Line 685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

681: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
687: ' gmppsrp.category(pmh.category_id) category, ' ||
688: ' CURSOR( ' ||
689: ' SELECT pmd.* ' ||

Line 686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

682: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
687: ' gmppsrp.category(pmh.category_id) category, ' ||
688: ' CURSOR( ' ||
689: ' SELECT pmd.* ' ||
690: ' FROM ps_matl_dtl pmd ' ||

Line 687: ' gmppsrp.category(pmh.category_id) category, ' ||

683: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
684: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
685: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
686: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
687: ' gmppsrp.category(pmh.category_id) category, ' ||
688: ' CURSOR( ' ||
689: ' SELECT pmd.* ' ||
690: ' FROM ps_matl_dtl pmd ' ||
691: ' WHERE pmd.inventory_item_id = pmh.inventory_item_id ' ||

Line 1145: END GMPPSRP; /* END PACKAGE BODY ***********************/

1141: WHEN OTHERS THEN
1142: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
1143: END xml_transfer;
1144:
1145: END GMPPSRP; /***** END PACKAGE BODY ***************************/