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

Line 1546: FROM gme_batch_header_vw b

1542: x_error_msg OUT NOCOPY VARCHAR2) IS
1543:
1544: CURSOR Cur_batch_no IS
1545: SELECT b.parentline_id
1546: FROM gme_batch_header_vw b
1547: WHERE batch_type = 0
1548: AND organization_id = p_organization_id
1549: AND batch_id = p_batch_id;
1550:

Line 1740: l_batch_header GME_BATCH_HEADER%ROWTYPE;

1736: l_msg_count NUMBER;
1737: l_msg_list VARCHAR2(2000);
1738: l_msg_data VARCHAR2(2000);
1739: l_msg_index NUMBER;
1740: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1741: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1742: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1743:
1744: BACKFLUSH_ERROR EXCEPTION;

Line 2095: l_batch_header_rec gme_batch_header%ROWTYPE;

2091: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2092: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2093: l_material_detail_rec gme_material_details%ROWTYPE;
2094: l_in_material_detail_rec gme_material_details%ROWTYPE;
2095: l_batch_header_rec gme_batch_header%ROWTYPE;
2096: l_message_count NUMBER;
2097: l_message_list VARCHAR2(2000);
2098: l_create_lot VARCHAR2(6);
2099: l_duom_ctl VARCHAR2(30);

Line 2224: l_batch_header_rec gme_batch_header%ROWTYPE;

2220: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2221: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2222: l_material_detail_rec gme_material_details%ROWTYPE;
2223: l_in_material_detail_rec gme_material_details%ROWTYPE;
2224: l_batch_header_rec gme_batch_header%ROWTYPE;
2225: l_message_count NUMBER;
2226: l_message_list VARCHAR2(2000);
2227: l_duom_ctl VARCHAR2(30);
2228:

Line 3230: FROM gme_batch_header

3226: WHERE material_detail_id = p_material_detail_id;
3227:
3228: CURSOR get_Batch_Status IS
3229: SELECT batch_status
3230: FROM gme_batch_header
3231: WHERE batch_id = p_batch_id;
3232:
3233: l_release_type NUMBER;
3234: l_batch_status NUMBER;

Line 3615: l_batch_header gme_batch_header%ROWTYPE;

3611: message VARCHAR2(2000);
3612: l_batch_step gme_batch_steps%ROWTYPE;
3613: l_batch_step_out gme_batch_steps%ROWTYPE;
3614: x_batch_step gme_batch_steps%ROWTYPE;
3615: l_batch_header gme_batch_header%ROWTYPE;
3616: x_exception_material gme_common_pvt.exceptions_tab;
3617: step_alloc_error EXCEPTION;
3618: expected_error EXCEPTION;
3619: validate_step_error EXCEPTION;

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

3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;
3636: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3637: RAISE expected_error;
3638: END IF;
3639: l_batch_step.batch_id := p_batch_id;
3640: l_batch_step.batchstep_id := p_step_id;

Line 3779: FROM gme_batch_header

3775: PROCEDURE get_ASQC ( p_batch_id IN NUMBER,
3776: x_ASQC_status OUT NOCOPY NUMBER) IS
3777: BEGIN
3778: SELECT NVL(automatic_step_calculation,0) INTO x_ASQC_status
3779: FROM gme_batch_header
3780: WHERE batch_id = p_batch_id;
3781: EXCEPTION
3782: WHEN OTHERS THEN NULL;
3783: END get_ASQC;

Line 3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;

3815: l_api_name VARCHAR2(30) := 'release_step';
3816: l_batch_step gme_batch_steps%ROWTYPE;
3817: l_batch_step_out gme_batch_steps%ROWTYPE;
3818: x_batch_step gme_batch_steps%ROWTYPE;
3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3820: x_exception_material gme_common_pvt.exceptions_tab;
3821: step_alloc_error EXCEPTION;
3822: expected_error EXCEPTION;
3823: validate_step_error EXCEPTION;

Line 3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN

3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;
3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3839: RAISE expected_error;
3840: END IF;
3841:
3842: l_batch_step.batch_id := p_batch_id;

Line 4046: FROM gme_batch_header

4042: l_start_date DATE;
4043: l_api_name VARCHAR2(30) := 'Validate_Step_Start_Date';
4044: CURSOR Cur_get_stat IS
4045: SELECT batch_status
4046: FROM gme_batch_header
4047: WHERE batch_id = p_batch_id;
4048: CURSOR Cur_get_batch_start_dt IS
4049: SELECT actual_start_date
4050: FROM gme_batch_header

Line 4050: FROM gme_batch_header

4046: FROM gme_batch_header
4047: WHERE batch_id = p_batch_id;
4048: CURSOR Cur_get_batch_start_dt IS
4049: SELECT actual_start_date
4050: FROM gme_batch_header
4051: WHERE batch_id = p_batch_id;
4052: FUTURE_DATE_EX EXCEPTION;
4053: INVALID_STEP_START_DATE EXCEPTION;
4054: BEGIN

Line 4108: l_batch_rec gme_batch_header%ROWTYPE;

4104: PROCEDURE Load_resource_Txns (p_batch_id IN NUMBER,
4105: x_row_count OUT NOCOPY NUMBER,
4106: x_return_status OUT NOCOPY VARCHAR2) IS
4107:
4108: l_batch_rec gme_batch_header%ROWTYPE;
4109: expected_error EXCEPTION;
4110: BEGIN
4111: l_batch_rec.batch_id := p_batch_id;
4112: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_rec, l_batch_rec)) THEN

Line 4112: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_rec, l_batch_rec)) THEN

4108: l_batch_rec gme_batch_header%ROWTYPE;
4109: expected_error EXCEPTION;
4110: BEGIN
4111: l_batch_rec.batch_id := p_batch_id;
4112: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_rec, l_batch_rec)) THEN
4113: RAISE expected_error;
4114: END IF;
4115:
4116: gme_trans_engine_util.load_rsrc_trans (p_batch_row => l_batch_rec