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 847: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

843:
844: PROCEDURE construct_material_detail (
845: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
846: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
847: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
848: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
849: ,x_return_status OUT NOCOPY VARCHAR2)
850: IS
851: l_api_name CONSTANT VARCHAR2 (30) := 'construct_material_detail';

Line 976: FROM gme_batch_header b, gmd_recipe_validity_rules a

972: CURSOR cur_get_info (v_batch_id NUMBER)
973: IS
974: SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
975: ,b.routing_id, b.formula_id
976: FROM gme_batch_header b, gmd_recipe_validity_rules a
977: WHERE b.batch_id = v_batch_id
978: AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;
979:
980: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)

Line 1312: p_batch_header_rec IN gme_batch_header%ROWTYPE

1308: RETURN (NULL);
1309: END get_process_loss;
1310:
1311: PROCEDURE create_document_no (
1312: p_batch_header_rec IN gme_batch_header%ROWTYPE
1313: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1314: IS
1315: l_assignment_type NUMBER;
1316: l_document_no gme_batch_header.batch_no%TYPE;

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

1309: END get_process_loss;
1310:
1311: PROCEDURE create_document_no (
1312: p_batch_header_rec IN gme_batch_header%ROWTYPE
1313: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1314: IS
1315: l_assignment_type NUMBER;
1316: l_document_no gme_batch_header.batch_no%TYPE;
1317: invalid_doc_no EXCEPTION;

Line 1316: l_document_no gme_batch_header.batch_no%TYPE;

1312: p_batch_header_rec IN gme_batch_header%ROWTYPE
1313: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE)
1314: IS
1315: l_assignment_type NUMBER;
1316: l_document_no gme_batch_header.batch_no%TYPE;
1317: invalid_doc_no EXCEPTION;
1318: l_api_name CONSTANT VARCHAR2 (30) := 'create_document_no';
1319: PRAGMA AUTONOMOUS_TRANSACTION;
1320: BEGIN

Line 1482: p_batch_header_rec IN gme_batch_header%ROWTYPE

1478: RETURN FALSE;
1479: END calc_date_from_prod_rule;
1480:
1481: PROCEDURE calc_mtl_req_date (
1482: p_batch_header_rec IN gme_batch_header%ROWTYPE
1483: DEFAULT NULL
1484: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
1485: DEFAULT NULL
1486: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 1512: FROM gme_batch_header

1508:
1509: CURSOR cur_fetch_batch_dates (v_batch_id NUMBER)
1510: IS
1511: SELECT plan_start_date, plan_cmplt_date
1512: FROM gme_batch_header
1513: WHERE batch_id = v_batch_id;
1514: BEGIN
1515: IF g_debug <= gme_debug.g_log_procedure THEN
1516: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3511: p_batch_header_rec IN gme_batch_header%ROWTYPE

3507: RETURN FALSE;
3508: END get_assoc_step;
3509:
3510: FUNCTION get_batch_header (
3511: p_batch_header_rec IN gme_batch_header%ROWTYPE
3512: ,p_org_code IN VARCHAR2
3513: ,p_batch_type IN NUMBER
3514: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3515: RETURN BOOLEAN

Line 3514: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3510: FUNCTION get_batch_header (
3511: p_batch_header_rec IN gme_batch_header%ROWTYPE
3512: ,p_org_code IN VARCHAR2
3513: ,p_batch_type IN NUMBER
3514: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3515: RETURN BOOLEAN
3516: IS
3517: CURSOR get_organization (p_org_code IN VARCHAR2)
3518: IS

Line 3523: l_batch_header_rec gme_batch_header%ROWTYPE;

3519: SELECT organization_id
3520: FROM mtl_parameters
3521: WHERE organization_code = p_org_code;
3522:
3523: l_batch_header_rec gme_batch_header%ROWTYPE;
3524: l_api_name VARCHAR2 (30) := 'GET_BATCH_HEADER';
3525: BEGIN
3526: IF g_debug <= gme_debug.g_log_procedure THEN
3527: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 3537: ,'GME_BATCH_HEADER');

3533: IF p_batch_header_rec.batch_id IS NULL THEN
3534: IF p_org_code IS NULL AND p_batch_header_rec.organization_id IS NULL THEN
3535: gme_common_pvt.log_message ('GME_NO_KEYS'
3536: ,'TABLE_NAME'
3537: ,'GME_BATCH_HEADER');
3538: RAISE fnd_api.g_exc_error;
3539: ELSIF p_org_code IS NOT NULL THEN
3540: OPEN get_organization (p_org_code);
3541:

Line 3563: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3559: NVL (p_batch_header_rec.batch_type, p_batch_type);
3560: END IF;
3561: END IF;
3562:
3563: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3564: ,x_batch_header_rec) ) THEN
3565: RAISE fnd_api.g_exc_error;
3566: END IF;
3567:

Line 3603: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

3599: p_batch_step_rec IN gme_batch_steps%ROWTYPE
3600: ,p_org_code IN VARCHAR2
3601: ,p_batch_no IN VARCHAR2
3602: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3603: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3604: RETURN BOOLEAN
3605: IS
3606:
3607: l_batch_header_rec_in gme_batch_header%ROWTYPE;

Line 3607: l_batch_header_rec_in gme_batch_header%ROWTYPE;

3603: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
3604: RETURN BOOLEAN
3605: IS
3606:
3607: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3608: l_batch_header_rec gme_batch_header%ROWTYPE;
3609: l_batch_step_rec gme_batch_steps%ROWTYPE;
3610: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3611:

Line 3608: l_batch_header_rec gme_batch_header%ROWTYPE;

3604: RETURN BOOLEAN
3605: IS
3606:
3607: l_batch_header_rec_in gme_batch_header%ROWTYPE;
3608: l_batch_header_rec gme_batch_header%ROWTYPE;
3609: l_batch_step_rec gme_batch_steps%ROWTYPE;
3610: l_api_name VARCHAR2 (30) := 'GET_BATCH_STEP';
3611:
3612: BEGIN

Line 3639: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

3635: RAISE fnd_api.g_exc_error;
3636: END IF;
3637:
3638: l_batch_header_rec.batch_id := l_batch_step_rec.batch_id;
3639: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
3640: ,l_batch_header_rec) ) THEN
3641: RAISE fnd_api.g_exc_error;
3642: END IF;
3643:

Line 3672: p_batch_header_rec IN gme_batch_header%ROWTYPE

3668: RETURN FALSE;
3669: END get_batch_step;
3670:
3671: FUNCTION create_history (
3672: p_batch_header_rec IN gme_batch_header%ROWTYPE
3673: ,p_original_status IN NUMBER
3674: ,p_event_id IN NUMBER DEFAULT NULL)
3675: RETURN BOOLEAN
3676: IS

Line 3784: FROM gme_batch_header

3780:
3781: CURSOR get_batch_id (l_org_id IN NUMBER, l_batch_no IN VARCHAR2)
3782: IS
3783: SELECT batch_id
3784: FROM gme_batch_header
3785: WHERE organization_id = l_org_id AND batch_no = l_batch_no;
3786:
3787: CURSOR get_batchstep_id (l_batch_id IN NUMBER, l_batchstep_no IN NUMBER)
3788: IS

Line 4062: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

4058: FUNCTION check_validity_rule_dates (
4059: p_validity_rule_id IN NUMBER
4060: ,p_start_date IN DATE
4061: ,p_cmplt_date IN DATE
4062: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4063: ,p_validate_plan_dates_ind IN NUMBER DEFAULT 0)
4064: RETURN BOOLEAN
4065: IS
4066: /* Cusror definitions */

Line 4315: l_batch_header_rec gme_batch_header%ROWTYPE;

4311: l_msg_data VARCHAR2 (2000);
4312: l_material_date DATE;
4313: l_lot_expiration_date DATE;
4314: l_material_detail_rec gme_material_details%ROWTYPE;
4315: l_batch_header_rec gme_batch_header%ROWTYPE;
4316: l_rsv inv_reservation_global.mtl_reservation_rec_type;
4317: ---l_rsv_array inv_reservation_global.mtl_reservation_tbl_type; --------- Punit Kumar
4318: l_rsv_array gme_common_pvt.reservations_tab;
4319: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 4348: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

4344: END IF;
4345:
4346: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
4347:
4348: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
4349: ,l_batch_header_rec) ) THEN
4350: RAISE fnd_api.g_exc_error;
4351: END IF;
4352:

Line 4876: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4872: p_material_detail_rec IN gme_material_details%ROWTYPE
4873: ,p_org_code IN VARCHAR2
4874: ,p_batch_no IN VARCHAR2
4875: ,p_batch_type IN NUMBER
4876: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4877: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4878: RETURN BOOLEAN
4879: IS
4880: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4880: l_batch_header_rec gme_batch_header%ROWTYPE;

4876: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
4877: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
4878: RETURN BOOLEAN
4879: IS
4880: l_batch_header_rec gme_batch_header%ROWTYPE;
4881: l_material_detail_rec gme_material_details%ROWTYPE;
4882: l_api_name VARCHAR2 (30) := 'GET_MATERIAL_DETAIL';
4883: material_detail_fetch_error EXCEPTION;
4884: batch_header_fetch_error EXCEPTION;

Line 4916: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

4912: END IF;
4913:
4914: l_batch_header_rec.batch_id := x_material_detail_rec.batch_id;
4915:
4916: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
4917: ,x_batch_header_rec) ) THEN
4918: RAISE batch_header_fetch_error;
4919: END IF;
4920:

Line 4999: p_batch_header_rec IN gme_batch_header%ROWTYPE

4995: -- Added parameter to allow calling routine to bypass phantom check.
4996: --===================================================================== */
4997:
4998: Procedure Validate_batch (
4999: p_batch_header_rec IN gme_batch_header%ROWTYPE
5000: ,p_org_code IN VARCHAR2
5001: ,p_batch_type IN NUMBER
5002: ,p_check_phantom IN VARCHAR2 DEFAULT 'Y'
5003: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 5003: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

4999: p_batch_header_rec IN gme_batch_header%ROWTYPE
5000: ,p_org_code IN VARCHAR2
5001: ,p_batch_type IN NUMBER
5002: ,p_check_phantom IN VARCHAR2 DEFAULT 'Y'
5003: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
5004: ,x_message_count OUT NOCOPY NUMBER
5005: ,x_message_list OUT NOCOPY VARCHAR2
5006: ,x_return_status OUT NOCOPY VARCHAR2)
5007:

Line 5010: l_batch_header_rec gme_batch_header%ROWTYPE;

5006: ,x_return_status OUT NOCOPY VARCHAR2)
5007:
5008: IS
5009: l_api_name VARCHAR2 (100) := 'validate_batch';
5010: l_batch_header_rec gme_batch_header%ROWTYPE;
5011:
5012: batch_header_fetch_error EXCEPTION;
5013: BEGIN
5014: IF g_debug <= gme_debug.g_log_procedure THEN

Line 5111: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

5107: p_material_detail_rec IN gme_material_details%ROWTYPE
5108: ,p_org_code IN VARCHAR2
5109: ,p_batch_no IN VARCHAR2
5110: ,p_batch_type IN NUMBER
5111: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
5112: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
5113: ,x_message_count OUT NOCOPY NUMBER
5114: ,x_message_list OUT NOCOPY VARCHAR2
5115: ,x_return_status OUT NOCOPY VARCHAR2)

Line 5119: l_batch_header_rec gme_batch_header%ROWTYPE;

5115: ,x_return_status OUT NOCOPY VARCHAR2)
5116:
5117: IS
5118: l_api_name VARCHAR2 (100) := 'validate_material_detail';
5119: l_batch_header_rec gme_batch_header%ROWTYPE;
5120: l_material_detail_rec gme_material_details%ROWTYPE;
5121: material_fetch_error EXCEPTION;
5122: BEGIN
5123: IF g_debug <= gme_debug.g_log_procedure THEN

Line 5232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

5228: p_batch_step_rec IN gme_batch_steps%ROWTYPE
5229: ,p_org_code IN VARCHAR2
5230: ,p_batch_no IN VARCHAR2
5231: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
5232: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
5233: ,x_message_count OUT NOCOPY NUMBER
5234: ,x_message_list OUT NOCOPY VARCHAR2
5235: ,x_return_status OUT NOCOPY VARCHAR2)
5236:

Line 5239: l_batch_header_rec gme_batch_header%ROWTYPE;

5235: ,x_return_status OUT NOCOPY VARCHAR2)
5236:
5237: IS
5238: l_api_name VARCHAR2 (100) := 'validate_batch_step';
5239: l_batch_header_rec gme_batch_header%ROWTYPE;
5240: l_batch_step_rec gme_batch_steps%ROWTYPE;
5241: step_header_fetch_error EXCEPTION;
5242: BEGIN
5243: IF g_debug <= gme_debug.g_log_procedure THEN

Line 5346: l_batch_header_rec gme_batch_header%ROWTYPE;

5342: l_step_actual_start DATE;
5343: l_step_actual_cmplt DATE;
5344:
5345: l_material_detail_rec gme_material_details%ROWTYPE;
5346: l_batch_header_rec gme_batch_header%ROWTYPE;
5347:
5348: error_fetch_material EXCEPTION;
5349: error_fetch_batch_details EXCEPTION;
5350: error_close_period EXCEPTION;

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

5379: END IF;
5380:
5381: /*fetch the batch details*/
5382: l_batch_header_rec.batch_id := l_material_detail_rec.batch_id;
5383: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header_rec, l_batch_header_rec)) THEN
5384: IF g_debug <= gme_debug.g_log_statement THEN
5385: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'||'Error in Fetching the Batch Details');
5386: END IF;
5387: RAISE error_fetch_batch_details;