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 177: ,x_prim_prod_row OUT NOCOPY gme_material_details%ROWTYPE

173: p_fpo_header_row IN gme_batch_header%ROWTYPE
174: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
175: ,p_pregen_fpo_row IN pregen_fpo_row
176: ,x_pregen_fpo_row OUT NOCOPY pregen_fpo_row
177: ,x_prim_prod_row OUT NOCOPY gme_material_details%ROWTYPE
178: ,x_validity_rule_row OUT NOCOPY validity_rule_row
179: ,x_fpo_material_details_tab OUT NOCOPY fpo_material_details_tab
180: ,x_return_status OUT NOCOPY VARCHAR2)
181: IS

Line 188: l_prod_row gme_material_details%ROWTYPE;

184: l_pregen_fpo_row pregen_fpo_row;
185: l_fpo_material_details_tab fpo_material_details_tab;
186: l_return BOOLEAN;
187: --Begin Bug 2924803 Anil
188: l_prod_row gme_material_details%ROWTYPE;
189: l_plan_qty gme_material_details.plan_qty%TYPE;
190:
191: --End Bug 2924803 Anil
192: CURSOR get_fpo_material_details (v_batch_id NUMBER)

Line 189: l_plan_qty gme_material_details.plan_qty%TYPE;

185: l_fpo_material_details_tab fpo_material_details_tab;
186: l_return BOOLEAN;
187: --Begin Bug 2924803 Anil
188: l_prod_row gme_material_details%ROWTYPE;
189: l_plan_qty gme_material_details.plan_qty%TYPE;
190:
191: --End Bug 2924803 Anil
192: CURSOR get_fpo_material_details (v_batch_id NUMBER)
193: IS

Line 195: FROM gme_material_details

191: --End Bug 2924803 Anil
192: CURSOR get_fpo_material_details (v_batch_id NUMBER)
193: IS
194: SELECT *
195: FROM gme_material_details
196: WHERE batch_id = v_batch_id;
197:
198: l_fpo_material_details_row get_fpo_material_details%ROWTYPE;
199:

Line 203: FROM gme_material_details

199:
200: CURSOR get_prim_prod_row (v_batch_id NUMBER)
201: IS
202: SELECT *
203: FROM gme_material_details
204: WHERE batch_id = v_batch_id
205: AND line_type = 1
206: AND inventory_item_id =
207: (SELECT inventory_item_id

Line 458: ,p_prim_prod_row IN gme_material_details%ROWTYPE

454: --*************************************************************
455: --*****************************************************************
456: PROCEDURE generate_pre_batch_header_recs (
457: p_fpo_header_row IN gme_batch_header%ROWTYPE
458: ,p_prim_prod_row IN gme_material_details%ROWTYPE
459: ,p_pregen_fpo_row IN pregen_fpo_row
460: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
461: ,x_return_status OUT NOCOPY VARCHAR2)
462: IS

Line 471: l_prim_prod_row gme_material_details%ROWTYPE;

467: x_batch_offset_days NUMBER;
468: x_neg_batch_leadtime_days NUMBER;
469: x_neg_batch_offset_days NUMBER;
470: l_fpo_header_row gme_batch_header%ROWTYPE;
471: l_prim_prod_row gme_material_details%ROWTYPE;
472: l_pregen_fpo_row pregen_fpo_row;
473: l_generated_pre_batch_tab generated_pre_batch_tab;
474: /* Exception definitions */
475: generate_pre_batch_err EXCEPTION;

Line 825: l_batch_size gme_material_details.plan_qty%TYPE;

821: l_exception_material_tbl gme_common_pvt.exceptions_tab;
822: l_return_status VARCHAR2 (1);
823: l_api_version NUMBER;
824: l_validation_level NUMBER := 100;
825: l_batch_size gme_material_details.plan_qty%TYPE;
826: l_batch_uom gme_material_details.dtl_um%TYPE;
827: l_creation_mode VARCHAR2 (10);
828: l_om_gme_batch_rec gml_batch_om_util.batch_line_rec;
829: -- Bug 3185748 Added variables, validation_failure and cursor get_validity_rule .

Line 826: l_batch_uom gme_material_details.dtl_um%TYPE;

822: l_return_status VARCHAR2 (1);
823: l_api_version NUMBER;
824: l_validation_level NUMBER := 100;
825: l_batch_size gme_material_details.plan_qty%TYPE;
826: l_batch_uom gme_material_details.dtl_um%TYPE;
827: l_creation_mode VARCHAR2 (10);
828: l_om_gme_batch_rec gml_batch_om_util.batch_line_rec;
829: -- Bug 3185748 Added variables, validation_failure and cursor get_validity_rule .
830: l_inventory_item_id NUMBER; -- KYH GME CONV

Line 1131: ,p_prim_prod_row IN gme_material_details%ROWTYPE

1127: --*********************************************************
1128: --*********************************************************
1129: PROCEDURE update_original_fpo (
1130: p_fpo_header_row IN gme_batch_header%ROWTYPE
1131: ,p_prim_prod_row IN gme_material_details%ROWTYPE
1132: ,p_pregen_fpo_row IN pregen_fpo_row
1133: ,p_fpo_material_details_tab IN fpo_material_details_tab
1134: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1135: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE

Line 1141: FROM gme_material_details

1137: IS
1138: CURSOR get_phantom_fpo (v_batch_id NUMBER)
1139: IS
1140: SELECT phantom_id
1141: FROM gme_material_details
1142: WHERE batch_id = v_batch_id AND phantom_id IS NOT NULL;
1143:
1144: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ORIGINAL_FPO';
1145: l_fpo_header_row gme_batch_header%ROWTYPE;

Line 1146: l_prim_prod_row gme_material_details%ROWTYPE;

1142: WHERE batch_id = v_batch_id AND phantom_id IS NOT NULL;
1143:
1144: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ORIGINAL_FPO';
1145: l_fpo_header_row gme_batch_header%ROWTYPE;
1146: l_prim_prod_row gme_material_details%ROWTYPE;
1147: l_pregen_fpo_row pregen_fpo_row;
1148: l_fpo_material_details_tab fpo_material_details_tab;
1149: l_over_allocations gme_common_pvt.exceptions_tab;
1150: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;

Line 1267: UPDATE gme_material_details

1263: || TO_CHAR (l_fpo_header_row.batch_type) );
1264: END IF;
1265:
1266: --FPBug#4941012 set plan qty to zero for parent FPO
1267: UPDATE gme_material_details
1268: SET plan_qty = 0
1269: WHERE batch_id = l_fpo_header_row.batch_id;
1270:
1271: --Gonna delete the pending transactions associated with orig FPO

Line 1511: l_prim_prod_row gme_material_details%ROWTYPE;

1507: l_inventory_item_id NUMBER; -- KYH GME CONV
1508: l_fpo_header_row gme_batch_header%ROWTYPE;
1509: l_in_fpo_header_row gme_batch_header%ROWTYPE;
1510: l_batch_header gme_batch_header%ROWTYPE;
1511: l_prim_prod_row gme_material_details%ROWTYPE;
1512: l_fpo_material_details_tab fpo_material_details_tab;
1513: l_validity_rule_row validity_rule_row;
1514: l_pregen_fpo_row pregen_fpo_row;
1515: l_in_pregen_fpo_row pregen_fpo_row;