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_BATCH_HEADER

Line 9: p_batch_header IN gme_batch_header%ROWTYPE

5:
6: --*************************************************************
7: --*************************************************************
8: PROCEDURE VALIDATION (
9: p_batch_header IN gme_batch_header%ROWTYPE
10: ,p_batch_size IN NUMBER
11: ,p_batch_size_uom IN VARCHAR2
12: ,p_num_batches IN NUMBER
13: ,p_validity_rule_id IN NUMBER

Line 17: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE

13: ,p_validity_rule_id IN NUMBER
14: ,p_leadtime IN NUMBER
15: ,p_batch_offset IN NUMBER
16: ,p_offset_type IN NUMBER
17: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
18: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
19: ,x_pregen_fpo_row OUT NOCOPY pregen_fpo_row
20: ,x_return_status OUT NOCOPY VARCHAR2)
21: IS

Line 18: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE

14: ,p_leadtime IN NUMBER
15: ,p_batch_offset IN NUMBER
16: ,p_offset_type IN NUMBER
17: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
18: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
19: ,x_pregen_fpo_row OUT NOCOPY pregen_fpo_row
20: ,x_return_status OUT NOCOPY VARCHAR2)
21: IS
22: l_api_name CONSTANT VARCHAR2 (30) := 'VALIDATION';

Line 173: p_fpo_header_row IN gme_batch_header%ROWTYPE

169: --*************************************************************
170:
171: --*************************************************************
172: PROCEDURE retrieve_fpo_data (
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

Line 174: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE

170:
171: --*************************************************************
172: PROCEDURE retrieve_fpo_data (
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

Line 211: FROM gme_batch_header

207: (SELECT inventory_item_id
208: FROM gmd_recipe_validity_rules
209: WHERE recipe_validity_rule_id =
210: (SELECT recipe_validity_rule_id
211: FROM gme_batch_header
212: WHERE batch_id = v_batch_id) );
213:
214: /* GME CONV
215: CURSOR get_production_rules (v_plant_code VARCHAR2, v_item_id NUMBER) IS

Line 257: gme_batch_header_dbl.fetch_row (p_fpo_header_row, x_fpo_header_row);

253: x_return_status := fnd_api.g_ret_sts_success;
254: l_pregen_fpo_row := p_pregen_fpo_row;
255: --Retrieve fpo_header into local fpo_header_rec structure.
256: l_return :=
257: gme_batch_header_dbl.fetch_row (p_fpo_header_row, x_fpo_header_row);
258:
259: -- exception added
260: IF NOT l_return THEN
261: RAISE batch_fetch_error;

Line 442: p_fpo_header_row IN gme_batch_header%ROWTYPE

438:
439: --*************************************************************
440: --*****************************************************************
441: PROCEDURE generate_pre_batch_header_recs (
442: p_fpo_header_row IN gme_batch_header%ROWTYPE
443: ,p_prim_prod_row IN gme_material_details%ROWTYPE
444: ,p_pregen_fpo_row IN pregen_fpo_row
445: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
446: ,x_return_status OUT NOCOPY VARCHAR2)

Line 449: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;

445: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
446: ,x_return_status OUT NOCOPY VARCHAR2)
447: IS
448: l_api_name CONSTANT VARCHAR2 (30) := 'GENERATE_PRE_BATCH_HEADER_RECS';
449: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;
450: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
451: x_batch_leadtime_days NUMBER;
452: x_batch_offset_days NUMBER;
453: x_neg_batch_leadtime_days NUMBER;

Line 450: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;

446: ,x_return_status OUT NOCOPY VARCHAR2)
447: IS
448: l_api_name CONSTANT VARCHAR2 (30) := 'GENERATE_PRE_BATCH_HEADER_RECS';
449: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;
450: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
451: x_batch_leadtime_days NUMBER;
452: x_batch_offset_days NUMBER;
453: x_neg_batch_leadtime_days NUMBER;
454: x_neg_batch_offset_days NUMBER;

Line 455: l_fpo_header_row gme_batch_header%ROWTYPE;

451: x_batch_leadtime_days NUMBER;
452: x_batch_offset_days NUMBER;
453: x_neg_batch_leadtime_days NUMBER;
454: x_neg_batch_offset_days NUMBER;
455: l_fpo_header_row gme_batch_header%ROWTYPE;
456: l_prim_prod_row gme_material_details%ROWTYPE;
457: l_pregen_fpo_row pregen_fpo_row;
458: l_generated_pre_batch_tab generated_pre_batch_tab;
459: /* Exception definitions */

Line 751: l_pre_batch_row gme_batch_header%ROWTYPE;

747: IS
748: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';
749: dummy NUMBER;
750: l_generated_pre_batch_tab generated_pre_batch_tab;
751: l_pre_batch_row gme_batch_header%ROWTYPE;
752: l_in_pre_batch_row gme_batch_header%ROWTYPE;
753: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
754: l_pregen_fpo_row pregen_fpo_row;
755: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 752: l_in_pre_batch_row gme_batch_header%ROWTYPE;

748: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';
749: dummy NUMBER;
750: l_generated_pre_batch_tab generated_pre_batch_tab;
751: l_pre_batch_row gme_batch_header%ROWTYPE;
752: l_in_pre_batch_row gme_batch_header%ROWTYPE;
753: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
754: l_pregen_fpo_row pregen_fpo_row;
755: l_exception_material_tbl gme_common_pvt.exceptions_tab;
756: l_return_status VARCHAR2 (1);

Line 1064: p_fpo_header_row IN gme_batch_header%ROWTYPE

1060:
1061: --*********************************************************
1062: --*********************************************************
1063: PROCEDURE update_original_fpo (
1064: p_fpo_header_row IN gme_batch_header%ROWTYPE
1065: ,p_prim_prod_row IN gme_material_details%ROWTYPE
1066: ,p_pregen_fpo_row IN pregen_fpo_row
1067: ,p_fpo_material_details_tab IN fpo_material_details_tab
1068: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

Line 1069: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE

1065: ,p_prim_prod_row IN gme_material_details%ROWTYPE
1066: ,p_pregen_fpo_row IN pregen_fpo_row
1067: ,p_fpo_material_details_tab IN fpo_material_details_tab
1068: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
1069: ,x_fpo_header_row OUT NOCOPY gme_batch_header%ROWTYPE
1070: ,x_return_status OUT NOCOPY VARCHAR2)
1071: IS
1072: CURSOR get_phantom_fpo (v_batch_id NUMBER)
1073: IS

Line 1079: l_fpo_header_row gme_batch_header%ROWTYPE;

1075: FROM gme_material_details
1076: WHERE batch_id = v_batch_id AND phantom_id IS NOT NULL;
1077:
1078: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_ORIGINAL_FPO';
1079: l_fpo_header_row gme_batch_header%ROWTYPE;
1080: l_prim_prod_row gme_material_details%ROWTYPE;
1081: l_pregen_fpo_row pregen_fpo_row;
1082: l_fpo_material_details_tab fpo_material_details_tab;
1083: l_over_allocations gme_common_pvt.exceptions_tab;

Line 1086: l_batch_header gme_batch_header%ROWTYPE;

1082: l_fpo_material_details_tab fpo_material_details_tab;
1083: l_over_allocations gme_common_pvt.exceptions_tab;
1084: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1085: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1086: l_batch_header gme_batch_header%ROWTYPE;
1087: x_batch_header gme_batch_header%ROWTYPE;
1088: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1089: l_resource_tab gme_common_pvt.resource_transactions_tab;
1090: -- l_batch_type ic_tran_pnd.doc_type%TYPE;

Line 1087: x_batch_header gme_batch_header%ROWTYPE;

1083: l_over_allocations gme_common_pvt.exceptions_tab;
1084: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1085: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1086: l_batch_header gme_batch_header%ROWTYPE;
1087: x_batch_header gme_batch_header%ROWTYPE;
1088: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1089: l_resource_tab gme_common_pvt.resource_transactions_tab;
1090: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1091: l_scale_factor NUMBER;

Line 1093: l_batch_status gme_batch_header.batch_status%TYPE;

1089: l_resource_tab gme_common_pvt.resource_transactions_tab;
1090: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1091: l_scale_factor NUMBER;
1092: l_primaries VARCHAR2 (8);
1093: l_batch_status gme_batch_header.batch_status%TYPE;
1094: l_mat_row_count NUMBER;
1095: l_rsc_row_count NUMBER;
1096: l_return_status VARCHAR2 (1);
1097: l_return BOOLEAN;

Line 1172: l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);

1168: END IF;
1169:
1170: --Update FPO status to CONVERTED
1171: l_fpo_header_row.batch_status := -3;
1172: l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);
1173:
1174: IF NOT l_return THEN
1175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1176: gme_debug.put_line ('l_return from update_row = FALSE');

Line 1261: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header,

1257: || TO_CHAR (l_batch_header.batch_id) );
1258: END IF;
1259:
1260: --FPBug#4941012
1261: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header,
1262: l_batch_header) THEN
1263: RAISE fetch_batch_err;
1264: END IF;
1265:

Line 1374: p_batch_header IN gme_batch_header%ROWTYPE

1370: END update_original_fpo;
1371:
1372: --*********************************************************
1373: PROCEDURE convert_fpo_main (
1374: p_batch_header IN gme_batch_header%ROWTYPE
1375: ,p_batch_size IN NUMBER
1376: ,p_num_batches IN NUMBER
1377: ,p_validity_rule_id IN NUMBER
1378: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

Line 1385: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE

1381: ,p_batch_offset IN NUMBER
1382: ,p_offset_type IN NUMBER
1383: ,
1384: -- p_schedule_method IN VARCHAR2,
1385: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2

Line 1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE

1382: ,p_offset_type IN NUMBER
1383: ,
1384: -- p_schedule_method IN VARCHAR2,
1385: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

Line 1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

1386: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1387: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1388: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1389: ,x_return_status OUT NOCOPY VARCHAR2
1390: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1391: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1392: IS
1393: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_MAIN';
1394: /* Cursor definitions */

Line 1405: l_fpo_header_row gme_batch_header%ROWTYPE;

1401: AND v.inventory_item_id = i.inventory_item_id;
1402:
1403: /* Local variables */
1404: l_inventory_item_id NUMBER; -- KYH GME CONV
1405: l_fpo_header_row gme_batch_header%ROWTYPE;
1406: l_in_fpo_header_row gme_batch_header%ROWTYPE;
1407: l_batch_header gme_batch_header%ROWTYPE;
1408: l_prim_prod_row gme_material_details%ROWTYPE;
1409: l_fpo_material_details_tab fpo_material_details_tab;

Line 1406: l_in_fpo_header_row gme_batch_header%ROWTYPE;

1402:
1403: /* Local variables */
1404: l_inventory_item_id NUMBER; -- KYH GME CONV
1405: l_fpo_header_row gme_batch_header%ROWTYPE;
1406: l_in_fpo_header_row gme_batch_header%ROWTYPE;
1407: l_batch_header gme_batch_header%ROWTYPE;
1408: l_prim_prod_row gme_material_details%ROWTYPE;
1409: l_fpo_material_details_tab fpo_material_details_tab;
1410: l_validity_rule_row validity_rule_row;

Line 1407: l_batch_header gme_batch_header%ROWTYPE;

1403: /* Local variables */
1404: l_inventory_item_id NUMBER; -- KYH GME CONV
1405: l_fpo_header_row gme_batch_header%ROWTYPE;
1406: l_in_fpo_header_row gme_batch_header%ROWTYPE;
1407: l_batch_header gme_batch_header%ROWTYPE;
1408: l_prim_prod_row gme_material_details%ROWTYPE;
1409: l_fpo_material_details_tab fpo_material_details_tab;
1410: l_validity_rule_row validity_rule_row;
1411: l_pregen_fpo_row pregen_fpo_row;

Line 1457: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN

1453: l_api_name ||
1454: ' Retrieve batch header for batch_id '||
1455: l_batch_header.batch_id);
1456: END IF;
1457: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
1458: RAISE batch_header_fetch_error;
1459: END IF;
1460:
1461: /* Get the validity rule for the existing FPO */