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.GME_CONVERT_FPO_PVT dependencies on GME_MATERIAL_DETAILS

Line 8: ,batch_size_uom gme_material_details.dtl_um%TYPE

4: --******************************************************************
5: TYPE pregen_fpo_row IS RECORD (
6: batch_id gme_batch_header.batch_id%TYPE
7: ,qty_per_batch NUMBER
8: ,batch_size_uom gme_material_details.dtl_um%TYPE
9: ,num_batches NUMBER
10: ,validity_rule_id gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE
11: ,leadtime NUMBER
12: ,offset_type NUMBER

Line 16: ,fpo_assigned_qty gme_material_details.plan_qty%TYPE

12: ,offset_type NUMBER
13: ,batch_offset NUMBER
14: ,plan_start_date gme_batch_header.plan_start_date%TYPE
15: ,plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE
16: ,fpo_assigned_qty gme_material_details.plan_qty%TYPE
17: ,fpo_unassigned_qty gme_material_details.plan_qty%TYPE
18: ,schedule_method VARCHAR2 (10)
19: ,effective_qty gme_material_details.plan_qty%TYPE
20: ,sum_eff_qty gme_material_details.plan_qty%TYPE DEFAULT 0

Line 17: ,fpo_unassigned_qty gme_material_details.plan_qty%TYPE

13: ,batch_offset NUMBER
14: ,plan_start_date gme_batch_header.plan_start_date%TYPE
15: ,plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE
16: ,fpo_assigned_qty gme_material_details.plan_qty%TYPE
17: ,fpo_unassigned_qty gme_material_details.plan_qty%TYPE
18: ,schedule_method VARCHAR2 (10)
19: ,effective_qty gme_material_details.plan_qty%TYPE
20: ,sum_eff_qty gme_material_details.plan_qty%TYPE DEFAULT 0
21: ,std_qty NUMBER

Line 19: ,effective_qty gme_material_details.plan_qty%TYPE

15: ,plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE
16: ,fpo_assigned_qty gme_material_details.plan_qty%TYPE
17: ,fpo_unassigned_qty gme_material_details.plan_qty%TYPE
18: ,schedule_method VARCHAR2 (10)
19: ,effective_qty gme_material_details.plan_qty%TYPE
20: ,sum_eff_qty gme_material_details.plan_qty%TYPE DEFAULT 0
21: ,std_qty NUMBER
22: ,fixed_leadtime NUMBER
23: ,variable_leadtime NUMBER

Line 20: ,sum_eff_qty gme_material_details.plan_qty%TYPE DEFAULT 0

16: ,fpo_assigned_qty gme_material_details.plan_qty%TYPE
17: ,fpo_unassigned_qty gme_material_details.plan_qty%TYPE
18: ,schedule_method VARCHAR2 (10)
19: ,effective_qty gme_material_details.plan_qty%TYPE
20: ,sum_eff_qty gme_material_details.plan_qty%TYPE DEFAULT 0
21: ,std_qty NUMBER
22: ,fixed_leadtime NUMBER
23: ,variable_leadtime NUMBER
24: ,rules_found NUMBER

Line 33: ,prim_prod_item_id gme_material_details.inventory_item_id%TYPE

29: );
30:
31: TYPE validity_rule_row IS RECORD (
32: plant_code gme_batch_header.plant_code%TYPE
33: ,prim_prod_item_id gme_material_details.inventory_item_id%TYPE
34: ,prim_prod_item_no VARCHAR2(2000)
35: ,prim_prod_item_desc1 mtl_system_items.description%TYPE
36: ,prim_prod_item_um gme_material_details.dtl_um%TYPE
37: ,prim_prod_effective_qty gme_material_details.plan_qty%TYPE

Line 36: ,prim_prod_item_um gme_material_details.dtl_um%TYPE

32: plant_code gme_batch_header.plant_code%TYPE
33: ,prim_prod_item_id gme_material_details.inventory_item_id%TYPE
34: ,prim_prod_item_no VARCHAR2(2000)
35: ,prim_prod_item_desc1 mtl_system_items.description%TYPE
36: ,prim_prod_item_um gme_material_details.dtl_um%TYPE
37: ,prim_prod_effective_qty gme_material_details.plan_qty%TYPE
38: ,organization_id NUMBER
39: );
40:

Line 37: ,prim_prod_effective_qty gme_material_details.plan_qty%TYPE

33: ,prim_prod_item_id gme_material_details.inventory_item_id%TYPE
34: ,prim_prod_item_no VARCHAR2(2000)
35: ,prim_prod_item_desc1 mtl_system_items.description%TYPE
36: ,prim_prod_item_um gme_material_details.dtl_um%TYPE
37: ,prim_prod_effective_qty gme_material_details.plan_qty%TYPE
38: ,organization_id NUMBER
39: );
40:
41: TYPE fpo_material_details_tab IS TABLE OF gme_material_details%ROWTYPE

Line 41: TYPE fpo_material_details_tab IS TABLE OF gme_material_details%ROWTYPE

37: ,prim_prod_effective_qty gme_material_details.plan_qty%TYPE
38: ,organization_id NUMBER
39: );
40:
41: TYPE fpo_material_details_tab IS TABLE OF gme_material_details%ROWTYPE
42: INDEX BY BINARY_INTEGER;
43:
44: TYPE generated_pre_batch_tab IS TABLE OF gme_batch_header%ROWTYPE
45: INDEX BY BINARY_INTEGER;

Line 76: ,x_prim_prod_row OUT NOCOPY gme_material_details%ROWTYPE

72: p_fpo_header_row IN gme_batch_header%ROWTYPE
73: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
74: ,p_pregen_fpo_row IN pregen_fpo_row
75: ,x_pregen_fpo_row OUT NOCOPY pregen_fpo_row
76: ,x_prim_prod_row OUT NOCOPY gme_material_details%ROWTYPE
77: ,x_validity_rule_row OUT NOCOPY validity_rule_row
78: ,x_fpo_material_details_tab OUT NOCOPY fpo_material_details_tab
79: ,x_return_status OUT NOCOPY VARCHAR2);
80:

Line 88: ,p_prim_prod_row IN gme_material_details%ROWTYPE

84: ,x_return_status OUT NOCOPY VARCHAR2);
85:
86: PROCEDURE generate_pre_batch_header_recs (
87: p_fpo_header_row IN gme_batch_header%ROWTYPE
88: ,p_prim_prod_row IN gme_material_details%ROWTYPE
89: ,p_pregen_fpo_row IN pregen_fpo_row
90: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
91: ,x_return_status OUT NOCOPY VARCHAR2);
92:

Line 139: ,p_prim_prod_row IN gme_material_details%ROWTYPE

135: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
136:
137: PROCEDURE update_original_fpo (
138: p_fpo_header_row IN gme_batch_header%ROWTYPE
139: ,p_prim_prod_row IN gme_material_details%ROWTYPE
140: ,p_pregen_fpo_row IN pregen_fpo_row
141: ,p_fpo_material_details_tab IN fpo_material_details_tab
142: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
143: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE