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.4 2008/01/17 06:07:56 vpedarla ship $ */
3:
4: --Package Declarations
5:

Line 2: /* $Header: GMPPSRPB.pls 120.4 2008/01/17 06:07:56 vpedarla ship $ */

1: PACKAGE BODY GMPPSRP as
2: /* $Header: GMPPSRPB.pls 120.4 2008/01/17 06:07:56 vpedarla ship $ */
3:
4: --Package Declarations
5:
6: PROCEDURE ps_insert_header ;

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

648: seq_stmt := NULL;
649: x_seq_num := 0;
650:
651: x_stmt := ' SELECT ' ||
652: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
653: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
654: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
655: ''''||G_fcategory||''''||' fcategory, ' ||
656: ''''||G_tcategory||''''||' tcategory, ' ||

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

649: x_seq_num := 0;
650:
651: x_stmt := ' SELECT ' ||
652: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
653: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
654: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
655: ''''||G_fcategory||''''||' fcategory, ' ||
656: ''''||G_tcategory||''''||' tcategory, ' ||
657: ''''||G_fbuyer||''''||' fbuyer, ' ||

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

650:
651: x_stmt := ' SELECT ' ||
652: ' gmppsrp.organization_code( '||G_orgnanization_id||') master_org, ' ||
653: ' gmppsrp.schedule( '||G_schedule_id||') schedule, ' ||
654: ' gmppsrp.category_set( '||G_category_set||') category_set, ' ||
655: ''''||G_fcategory||''''||' fcategory, ' ||
656: ''''||G_tcategory||''''||' tcategory, ' ||
657: ''''||G_fbuyer||''''||' fbuyer, ' ||
658: ''''||G_tbuyer||''''||' tbuyer, ' ||

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

663: ''''||G_fitem||''''||' fitem, ' ||
664: ''''||G_titem||''''||' titem, ' ||
665: ' CURSOR( ' ||
666: ' SELECT ' ||
667: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||

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

664: ''''||G_titem||''''||' titem, ' ||
665: ' CURSOR( ' ||
666: ' SELECT ' ||
667: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||

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

665: ' CURSOR( ' ||
666: ' SELECT ' ||
667: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||

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

666: ' SELECT ' ||
667: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||
674: ' CURSOR( ' ||

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

667: ' gmppsrp.item_name(pmh.inventory_item_id, pmh.organization_id) item_name, ' ||
668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||
674: ' CURSOR( ' ||
675: ' SELECT pmd.* ' ||

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

668: ' gmppsrp.organization_code (pmh.organization_id) organization_code, ' ||
669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||
674: ' CURSOR( ' ||
675: ' SELECT pmd.* ' ||
676: ' FROM ps_matl_dtl pmd ' ||

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

669: ' gmppsrp.planner_code (pmh.inventory_item_id, pmh.organization_id) planner_code, ' ||
670: ' gmppsrp.buyer_name (pmh.inventory_item_id, pmh.organization_id) buyer_name, ' ||
671: ' gmppsrp.onhand_qty (pmh.inventory_item_id, pmh.organization_id) onhand_qty, ' ||
672: ' gmppsrp.unit_of_measure(pmh.inventory_item_id, pmh.organization_id) primary_uom_code, ' ||
673: ' gmppsrp.category(pmh.category_id) category, ' ||
674: ' CURSOR( ' ||
675: ' SELECT pmd.* ' ||
676: ' FROM ps_matl_dtl pmd ' ||
677: ' WHERE pmd.inventory_item_id = pmh.inventory_item_id ' ||

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

1100: WHEN OTHERS THEN
1101: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
1102: END xml_transfer;
1103:
1104: END GMPPSRP; /***** END PACKAGE BODY ***************************/