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 457: p_fpo_header_row IN gme_batch_header%ROWTYPE

453:
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)

Line 464: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;

460: ,x_generated_pre_batch_tab OUT NOCOPY generated_pre_batch_tab
461: ,x_return_status OUT NOCOPY VARCHAR2)
462: IS
463: l_api_name CONSTANT VARCHAR2 (30) := 'GENERATE_PRE_BATCH_HEADER_RECS';
464: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;
465: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
466: x_batch_leadtime_days NUMBER;
467: x_batch_offset_days NUMBER;
468: x_neg_batch_leadtime_days NUMBER;

Line 465: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;

461: ,x_return_status OUT NOCOPY VARCHAR2)
462: IS
463: l_api_name CONSTANT VARCHAR2 (30) := 'GENERATE_PRE_BATCH_HEADER_RECS';
464: x_prev_plan_start_date gme_batch_header.plan_start_date%TYPE;
465: x_prev_plan_cmplt_date gme_batch_header.plan_cmplt_date%TYPE;
466: x_batch_leadtime_days NUMBER;
467: x_batch_offset_days NUMBER;
468: x_neg_batch_leadtime_days NUMBER;
469: x_neg_batch_offset_days NUMBER;

Line 470: l_fpo_header_row gme_batch_header%ROWTYPE;

466: x_batch_leadtime_days NUMBER;
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 */

Line 817: l_pre_batch_row gme_batch_header%ROWTYPE;

813: IS
814: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';
815: dummy NUMBER;
816: l_generated_pre_batch_tab generated_pre_batch_tab;
817: l_pre_batch_row gme_batch_header%ROWTYPE;
818: l_in_pre_batch_row gme_batch_header%ROWTYPE;
819: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
820: l_pregen_fpo_row pregen_fpo_row;
821: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 818: l_in_pre_batch_row gme_batch_header%ROWTYPE;

814: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_TO_BATCH';
815: dummy NUMBER;
816: l_generated_pre_batch_tab generated_pre_batch_tab;
817: l_pre_batch_row gme_batch_header%ROWTYPE;
818: l_in_pre_batch_row gme_batch_header%ROWTYPE;
819: l_recipe_validity_rule_tab gme_common_pvt.recipe_validity_rule_tab;
820: l_pregen_fpo_row pregen_fpo_row;
821: l_exception_material_tbl gme_common_pvt.exceptions_tab;
822: l_return_status VARCHAR2 (1);

Line 1130: p_fpo_header_row IN gme_batch_header%ROWTYPE

1126:
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

Line 1135: ,x_fpo_header_row OUT NOCOPY 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
1136: ,x_return_status OUT NOCOPY VARCHAR2)
1137: IS
1138: CURSOR get_phantom_fpo (v_batch_id NUMBER)
1139: IS

Line 1145: l_fpo_header_row gme_batch_header%ROWTYPE;

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;
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;

Line 1152: l_batch_header gme_batch_header%ROWTYPE;

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;
1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1152: l_batch_header gme_batch_header%ROWTYPE;
1153: x_batch_header gme_batch_header%ROWTYPE;
1154: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1155: l_resource_tab gme_common_pvt.resource_transactions_tab;
1156: -- l_batch_type ic_tran_pnd.doc_type%TYPE;

Line 1153: x_batch_header gme_batch_header%ROWTYPE;

1149: l_over_allocations gme_common_pvt.exceptions_tab;
1150: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
1151: -- GME CONV l_tran_tab gme_common_pvt.transactions_tab;
1152: l_batch_header gme_batch_header%ROWTYPE;
1153: x_batch_header gme_batch_header%ROWTYPE;
1154: l_resource_txns gme_resource_txns_gtmp%ROWTYPE;
1155: l_resource_tab gme_common_pvt.resource_transactions_tab;
1156: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1157: l_scale_factor NUMBER;

Line 1159: l_batch_status gme_batch_header.batch_status%TYPE;

1155: l_resource_tab gme_common_pvt.resource_transactions_tab;
1156: -- l_batch_type ic_tran_pnd.doc_type%TYPE;
1157: l_scale_factor NUMBER;
1158: l_primaries VARCHAR2 (8);
1159: l_batch_status gme_batch_header.batch_status%TYPE;
1160: l_mat_row_count NUMBER;
1161: l_rsc_row_count NUMBER;
1162: l_return_status VARCHAR2 (1);
1163: l_return BOOLEAN;

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

1239: END IF;
1240:
1241: --Update FPO status to CONVERTED
1242: l_fpo_header_row.batch_status := -3;
1243: l_return := gme_batch_header_dbl.update_row (l_fpo_header_row);
1244:
1245: IF NOT l_return THEN
1246: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1247: gme_debug.put_line ('l_return from update_row = FALSE');

Line 1332: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header,

1328: || TO_CHAR (l_batch_header.batch_id) );
1329: END IF;
1330:
1331: --FPBug#4941012
1332: IF NOT gme_batch_header_dbl.fetch_row(l_batch_header,
1333: l_batch_header) THEN
1334: RAISE fetch_batch_err;
1335: END IF;
1336:

Line 1477: p_batch_header IN gme_batch_header%ROWTYPE

1473: END update_original_fpo;
1474:
1475: --*********************************************************
1476: PROCEDURE convert_fpo_main (
1477: p_batch_header IN gme_batch_header%ROWTYPE
1478: ,p_batch_size IN NUMBER
1479: ,p_num_batches IN NUMBER
1480: ,p_validity_rule_id IN NUMBER
1481: ,p_validity_rule_tab IN gme_common_pvt.recipe_validity_rule_tab

Line 1488: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE

1484: ,p_batch_offset IN NUMBER
1485: ,p_offset_type IN NUMBER
1486: ,
1487: -- p_schedule_method IN VARCHAR2,
1488: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2

Line 1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE

1485: ,p_offset_type IN NUMBER
1486: ,
1487: -- p_schedule_method IN VARCHAR2,
1488: p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2
1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

Line 1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

1489: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
1490: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
1491: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
1492: ,x_return_status OUT NOCOPY VARCHAR2
1493: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE
1494: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1495: IS
1496: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_MAIN';
1497: /* Cursor definitions */

Line 1508: l_fpo_header_row gme_batch_header%ROWTYPE;

1504: AND v.inventory_item_id = i.inventory_item_id;
1505:
1506: /* Local variables */
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;

Line 1509: l_in_fpo_header_row gme_batch_header%ROWTYPE;

1505:
1506: /* Local variables */
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;

Line 1510: l_batch_header gme_batch_header%ROWTYPE;

1506: /* Local variables */
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;

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

1556: l_api_name ||
1557: ' Retrieve batch header for batch_id '||
1558: l_batch_header.batch_id);
1559: END IF;
1560: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header, l_batch_header) ) THEN
1561: RAISE batch_header_fetch_error;
1562: END IF;
1563:
1564: /* Get the validity rule for the existing FPO */