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_COMMON_PVT dependencies on GME_BATCH_HEADER

Line 757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

753:
754: PROCEDURE construct_material_detail (
755: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
756: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
757: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
758: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
759: ,x_return_status OUT NOCOPY VARCHAR2)
760: IS
761: l_api_name CONSTANT VARCHAR2 (30) := 'construct_material_detail';

Line 886: FROM gme_batch_header b, gmd_recipe_validity_rules a

882: CURSOR cur_get_info (v_batch_id NUMBER)
883: IS
884: SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
885: ,b.routing_id, b.formula_id
886: FROM gme_batch_header b, gmd_recipe_validity_rules a
887: WHERE b.batch_id = v_batch_id
888: AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;
889:
890: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)

Line 1222: p_batch_header_rec IN gme_batch_header%ROWTYPE

1218: RETURN (NULL);
1219: END get_process_loss;
1220:
1221: PROCEDURE create_document_no (
1222: p_batch_header_rec IN gme_batch_header%ROWTYPE
1223: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1224: IS
1225: l_assignment_type NUMBER;
1226: l_document_no gme_batch_header.batch_no%TYPE;

Line 1223: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)

1219: END get_process_loss;
1220:
1221: PROCEDURE create_document_no (
1222: p_batch_header_rec IN gme_batch_header%ROWTYPE
1223: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1224: IS
1225: l_assignment_type NUMBER;
1226: l_document_no gme_batch_header.batch_no%TYPE;
1227: invalid_doc_no EXCEPTION;

Line 1226: l_document_no gme_batch_header.batch_no%TYPE;

1222: p_batch_header_rec IN gme_batch_header%ROWTYPE
1223: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1224: IS
1225: l_assignment_type NUMBER;
1226: l_document_no gme_batch_header.batch_no%TYPE;
1227: invalid_doc_no EXCEPTION;
1228: l_api_name CONSTANT VARCHAR2 (30) := 'create_document_no';
1229: PRAGMA AUTONOMOUS_TRANSACTION;
1230: BEGIN

Line 1385: p_batch_header_rec IN gme_batch_header%ROWTYPE

1381: RETURN FALSE;
1382: END calc_date_from_prod_rule;
1383:
1384: PROCEDURE calc_mtl_req_date (
1385: p_batch_header_rec IN gme_batch_header%ROWTYPE
1386: DEFAULT NULL
1387: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1388: DEFAULT NULL
1389: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 1415: FROM gme_batch_header

1411:
1412: CURSOR cur_fetch_batch_dates (v_batch_id NUMBER)
1413: IS
1414: SELECT plan_start_date, plan_cmplt_date
1415: FROM gme_batch_header
1416: WHERE batch_id = v_batch_id;
1417: BEGIN
1418: IF g_debug <= gme_debug.g_log_procedure THEN
1419: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3252: p_batch_header_rec IN gme_batch_header%ROWTYPE

3248: RETURN FALSE;
3249: END get_assoc_step;
3250:
3251: FUNCTION get_batch_header (
3252: p_batch_header_rec IN gme_batch_header%ROWTYPE
3253: ,p_org_code IN VARCHAR2
3254: ,p_batch_type IN NUMBER
3255: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3256: RETURN BOOLEAN

Line 3255: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3251: FUNCTION get_batch_header (
3252: p_batch_header_rec IN gme_batch_header%ROWTYPE
3253: ,p_org_code IN VARCHAR2
3254: ,p_batch_type IN NUMBER
3255: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3256: RETURN BOOLEAN
3257: IS
3258: CURSOR get_organization (p_org_code IN VARCHAR2)
3259: IS

Line 3264: l_batch_header_rec gme_batch_header%ROWTYPE;

3260: SELECT organization_id
3261: FROM mtl_parameters
3262: WHERE organization_code = p_org_code;
3263:
3264: l_batch_header_rec gme_batch_header%ROWTYPE;
3265: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';
3266: BEGIN
3267: IF g_debug <= gme_debug.g_log_procedure THEN
3268: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3278: ,'GME_BATCH_HEADER');

3274: IF p_batch_header_rec.batch_id IS NULL THEN
3275: IF p_org_code IS NULL AND p_batch_header_rec.organization_id IS NULL THEN
3276: gme_common_pvt.log_message ('GME_NO_KEYS'
3277: ,'TABLE_NAME'
3278: ,'GME_BATCH_HEADER');
3279: RAISE fnd_api.g_exc_error;
3280: ELSIF p_org_code IS NOT NULL THEN
3281: OPEN get_organization (p_org_code);
3282:

Line 3304: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3300: NVL (p_batch_header_rec.batch_type, p_batch_type);
3301: END IF;
3302: END IF;
3303:
3304: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3305: ,x_batch_header_rec) ) THEN
3306: RAISE fnd_api.g_exc_error;
3307: END IF;
3308:

Line 3344: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3340: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3341: ,p_org_code IN VARCHAR2
3342: ,p_batch_no IN VARCHAR2
3343: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3344: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3345: RETURN BOOLEAN
3346: IS
3347:
3348: l_batch_header_rec_in gme_batch_header%ROWTYPE;

Line 3348: l_batch_header_rec_in gme_batch_header%ROWTYPE;

3344: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3345: RETURN BOOLEAN
3346: IS
3347:
3348: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3349: l_batch_header_rec gme_batch_header%ROWTYPE;
3350: l_batch_step_rec gme_batch_steps%ROWTYPE;
3351: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3352:

Line 3349: l_batch_header_rec gme_batch_header%ROWTYPE;

3345: RETURN BOOLEAN
3346: IS
3347:
3348: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3349: l_batch_header_rec gme_batch_header%ROWTYPE;
3350: l_batch_step_rec gme_batch_steps%ROWTYPE;
3351: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3352:
3353: BEGIN

Line 3380: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3376: RAISE fnd_api.g_exc_error;
3377: END IF;
3378:
3379: l_batch_header_rec.batch_id := l_batch_step_rec.batch_id;
3380: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3381: ,l_batch_header_rec) ) THEN
3382: RAISE fnd_api.g_exc_error;
3383: END IF;
3384:

Line 3413: p_batch_header_rec IN gme_batch_header%ROWTYPE

3409: RETURN FALSE;
3410: END get_batch_step;
3411:
3412: FUNCTION create_history (
3413: p_batch_header_rec IN gme_batch_header%ROWTYPE
3414: ,p_original_status IN NUMBER
3415: ,p_event_id IN NUMBER DEFAULT NULL)
3416: RETURN BOOLEAN
3417: IS

Line 3525: FROM gme_batch_header

3521:
3522: CURSOR get_batch_id (l_org_id IN NUMBER, l_batch_no IN VARCHAR2)
3523: IS
3524: SELECT batch_id
3525: FROM gme_batch_header
3526: WHERE organization_id = l_org_id AND batch_no = l_batch_no;
3527:
3528: CURSOR get_batchstep_id (l_batch_id IN NUMBER, l_batchstep_no IN NUMBER)
3529: IS

Line 3803: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

3799: FUNCTION check_validity_rule_dates (
3800: p_validity_rule_id IN NUMBER
3801: ,p_start_date IN DATE
3802: ,p_cmplt_date IN DATE
3803: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3804: ,p_validate_plan_dates_ind IN NUMBER DEFAULT 0)
3805: RETURN BOOLEAN
3806: IS
3807: /* Cusror definitions */

Line 4056: l_batch_header_rec gme_batch_header%ROWTYPE;

4052: l_msg_data VARCHAR2 (2000);
4053: l_material_date DATE;
4054: l_lot_expiration_date DATE;
4055: l_material_detail_rec gme_material_details%ROWTYPE;
4056: l_batch_header_rec gme_batch_header%ROWTYPE;
4057: l_rsv inv_reservation_global.mtl_reservation_rec_type;
4058: ---l_rsv_array inv_reservation_global.mtl_reservation_tbl_type; --------- Punit Kumar
4059: l_rsv_array gme_common_pvt.reservations_tab;
4060: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 4089: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

4085: END IF;
4086:
4087: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
4088:
4089: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
4090: ,l_batch_header_rec) ) THEN
4091: RAISE fnd_api.g_exc_error;
4092: END IF;
4093:

Line 4617: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4613: p_material_detail_rec IN gme_material_details%ROWTYPE
4614: ,p_org_code IN VARCHAR2
4615: ,p_batch_no IN VARCHAR2
4616: ,p_batch_type IN NUMBER
4617: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4618: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4619: RETURN BOOLEAN
4620: IS
4621: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4621: l_batch_header_rec gme_batch_header%ROWTYPE;

4617: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4618: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4619: RETURN BOOLEAN
4620: IS
4621: l_batch_header_rec gme_batch_header%ROWTYPE;
4622: l_material_detail_rec gme_material_details%ROWTYPE;
4623: l_api_name VARCHAR2 (30) := 'GET_MATERIAL_DETAIL';
4624: material_detail_fetch_error EXCEPTION;
4625: batch_header_fetch_error EXCEPTION;

Line 4657: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

4653: END IF;
4654:
4655: l_batch_header_rec.batch_id := x_material_detail_rec.batch_id;
4656:
4657: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
4658: ,x_batch_header_rec) ) THEN
4659: RAISE batch_header_fetch_error;
4660: END IF;
4661:

Line 4738: p_batch_header_rec IN gme_batch_header%ROWTYPE

4734: --
4735: --===================================================================== */
4736:
4737: Procedure Validate_batch (
4738: p_batch_header_rec IN gme_batch_header%ROWTYPE
4739: ,p_org_code IN VARCHAR2
4740: ,p_batch_type IN NUMBER
4741: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4742: ,x_message_count OUT NOCOPY NUMBER

Line 4741: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4737: Procedure Validate_batch (
4738: p_batch_header_rec IN gme_batch_header%ROWTYPE
4739: ,p_org_code IN VARCHAR2
4740: ,p_batch_type IN NUMBER
4741: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4742: ,x_message_count OUT NOCOPY NUMBER
4743: ,x_message_list OUT NOCOPY VARCHAR2
4744: ,x_return_status OUT NOCOPY VARCHAR2)
4745:

Line 4748: l_batch_header_rec gme_batch_header%ROWTYPE;

4744: ,x_return_status OUT NOCOPY VARCHAR2)
4745:
4746: IS
4747: l_api_name VARCHAR2 (100) := 'validate_batch';
4748: l_batch_header_rec gme_batch_header%ROWTYPE;
4749:
4750: batch_header_fetch_error EXCEPTION;
4751: BEGIN
4752: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4847: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4843: p_material_detail_rec IN gme_material_details%ROWTYPE
4844: ,p_org_code IN VARCHAR2
4845: ,p_batch_no IN VARCHAR2
4846: ,p_batch_type IN NUMBER
4847: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
4849: ,x_message_count OUT NOCOPY NUMBER
4850: ,x_message_list OUT NOCOPY VARCHAR2
4851: ,x_return_status OUT NOCOPY VARCHAR2)

Line 4855: l_batch_header_rec gme_batch_header%ROWTYPE;

4851: ,x_return_status OUT NOCOPY VARCHAR2)
4852:
4853: IS
4854: l_api_name VARCHAR2 (100) := 'validate_material_detail';
4855: l_batch_header_rec gme_batch_header%ROWTYPE;
4856: l_material_detail_rec gme_material_details%ROWTYPE;
4857: material_fetch_error EXCEPTION;
4858: BEGIN
4859: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4966: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4962: p_batch_step_rec IN gme_batch_steps%ROWTYPE
4963: ,p_org_code IN VARCHAR2
4964: ,p_batch_no IN VARCHAR2
4965: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
4966: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4967: ,x_message_count OUT NOCOPY NUMBER
4968: ,x_message_list OUT NOCOPY VARCHAR2
4969: ,x_return_status OUT NOCOPY VARCHAR2)
4970:

Line 4973: l_batch_header_rec gme_batch_header%ROWTYPE;

4969: ,x_return_status OUT NOCOPY VARCHAR2)
4970:
4971: IS
4972: l_api_name VARCHAR2 (100) := 'validate_batch_step';
4973: l_batch_header_rec gme_batch_header%ROWTYPE;
4974: l_batch_step_rec gme_batch_steps%ROWTYPE;
4975: step_header_fetch_error EXCEPTION;
4976: BEGIN
4977: IF g_debug <= gme_debug.g_log_procedure THEN

Line 5078: l_batch_header_rec gme_batch_header%ROWTYPE;

5074: l_step_actual_start DATE;
5075: l_step_actual_cmplt DATE;
5076:
5077: l_material_detail_rec gme_material_details%ROWTYPE;
5078: l_batch_header_rec gme_batch_header%ROWTYPE;
5079:
5080: error_fetch_material EXCEPTION;
5081: error_fetch_batch_details EXCEPTION;
5082: error_close_period EXCEPTION;

Line 5115: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec)) THEN

5111: END IF;
5112:
5113: /*fetch the batch details*/
5114: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
5115: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec)) THEN
5116: IF g_debug <= gme_debug.g_log_statement THEN
5117: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the Batch Details');
5118: END IF;
5119: RAISE error_fetch_batch_details;