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 1642: FROM gme_batch_header_vw b

1638: x_error_msg OUT NOCOPY VARCHAR2) IS
1639:
1640: CURSOR Cur_batch_no IS
1641: SELECT b.parentline_id
1642: FROM gme_batch_header_vw b
1643: WHERE batch_type = 0
1644: AND organization_id = p_organization_id
1645: AND batch_id = p_batch_id;
1646:

Line 1836: l_batch_header GME_BATCH_HEADER%ROWTYPE;

1832: l_msg_count NUMBER;
1833: l_msg_list VARCHAR2(2000);
1834: l_msg_data VARCHAR2(2000);
1835: l_msg_index NUMBER;
1836: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1837: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1838: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1839:
1840: BACKFLUSH_ERROR EXCEPTION;

Line 2191: l_batch_header_rec gme_batch_header%ROWTYPE;

2187: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2188: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2189: l_material_detail_rec gme_material_details%ROWTYPE;
2190: l_in_material_detail_rec gme_material_details%ROWTYPE;
2191: l_batch_header_rec gme_batch_header%ROWTYPE;
2192: l_message_count NUMBER;
2193: l_message_list VARCHAR2(2000);
2194: l_create_lot VARCHAR2(6);
2195: l_duom_ctl VARCHAR2(30);

Line 2320: l_batch_header_rec gme_batch_header%ROWTYPE;

2316: l_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2317: l_out_pending_product_lots_rec gme_pending_product_lots%ROWTYPE;
2318: l_material_detail_rec gme_material_details%ROWTYPE;
2319: l_in_material_detail_rec gme_material_details%ROWTYPE;
2320: l_batch_header_rec gme_batch_header%ROWTYPE;
2321: l_message_count NUMBER;
2322: l_message_list VARCHAR2(2000);
2323: l_duom_ctl VARCHAR2(30);
2324:

Line 3326: FROM gme_batch_header

3322: WHERE material_detail_id = p_material_detail_id;
3323:
3324: CURSOR get_Batch_Status IS
3325: SELECT batch_status
3326: FROM gme_batch_header
3327: WHERE batch_id = p_batch_id;
3328:
3329: l_release_type NUMBER;
3330: l_batch_status NUMBER;

Line 3711: l_batch_header gme_batch_header%ROWTYPE;

3707: message VARCHAR2(2000);
3708: l_batch_step gme_batch_steps%ROWTYPE;
3709: l_batch_step_out gme_batch_steps%ROWTYPE;
3710: x_batch_step gme_batch_steps%ROWTYPE;
3711: l_batch_header gme_batch_header%ROWTYPE;
3712: x_exception_material gme_common_pvt.exceptions_tab;
3713: step_alloc_error EXCEPTION;
3714: expected_error EXCEPTION;
3715: validate_step_error EXCEPTION;

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

3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;
3732: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3733: RAISE expected_error;
3734: END IF;
3735: l_batch_step.batch_id := p_batch_id;
3736: l_batch_step.batchstep_id := p_step_id;

Line 3883: FROM gme_batch_header

3879: PROCEDURE get_ASQC ( p_batch_id IN NUMBER,
3880: x_ASQC_status OUT NOCOPY NUMBER) IS
3881: BEGIN
3882: SELECT NVL(automatic_step_calculation,0) INTO x_ASQC_status
3883: FROM gme_batch_header
3884: WHERE batch_id = p_batch_id;
3885: EXCEPTION
3886: WHEN OTHERS THEN NULL;
3887: END get_ASQC;

Line 3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;

3919: l_api_name VARCHAR2(30) := 'release_step';
3920: l_batch_step gme_batch_steps%ROWTYPE;
3921: l_batch_step_out gme_batch_steps%ROWTYPE;
3922: x_batch_step gme_batch_steps%ROWTYPE;
3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3924: x_exception_material gme_common_pvt.exceptions_tab;
3925: step_alloc_error EXCEPTION;
3926: expected_error EXCEPTION;
3927: validate_step_error EXCEPTION;

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

3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;
3942: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3943: RAISE expected_error;
3944: END IF;
3945:
3946: l_batch_step.batch_id := p_batch_id;

Line 4176: FROM gme_batch_header

4172: l_start_date DATE;
4173: l_api_name VARCHAR2(30) := 'Validate_Step_Start_Date';
4174: CURSOR Cur_get_stat IS
4175: SELECT batch_status
4176: FROM gme_batch_header
4177: WHERE batch_id = p_batch_id;
4178: CURSOR Cur_get_batch_start_dt IS
4179: SELECT actual_start_date
4180: FROM gme_batch_header

Line 4180: FROM gme_batch_header

4176: FROM gme_batch_header
4177: WHERE batch_id = p_batch_id;
4178: CURSOR Cur_get_batch_start_dt IS
4179: SELECT actual_start_date
4180: FROM gme_batch_header
4181: WHERE batch_id = p_batch_id;
4182: FUTURE_DATE_EX EXCEPTION;
4183: INVALID_STEP_START_DATE EXCEPTION;
4184: BEGIN

Line 4238: l_batch_rec gme_batch_header%ROWTYPE;

4234: PROCEDURE Load_resource_Txns (p_batch_id IN NUMBER,
4235: x_row_count OUT NOCOPY NUMBER,
4236: x_return_status OUT NOCOPY VARCHAR2) IS
4237:
4238: l_batch_rec gme_batch_header%ROWTYPE;
4239: expected_error EXCEPTION;
4240: BEGIN
4241: l_batch_rec.batch_id := p_batch_id;
4242: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_rec, l_batch_rec)) THEN

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

4238: l_batch_rec gme_batch_header%ROWTYPE;
4239: expected_error EXCEPTION;
4240: BEGIN
4241: l_batch_rec.batch_id := p_batch_id;
4242: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_rec, l_batch_rec)) THEN
4243: RAISE expected_error;
4244: END IF;
4245:
4246: gme_trans_engine_util.load_rsrc_trans (p_batch_row => l_batch_rec

Line 4563: FROM gme_batch_header_vw bh,

4559: bh.batch_no batch_no,
4560: mmt.transaction_id,
4561: mmt.created_by,
4562: mmt.transaction_type_id
4563: FROM gme_batch_header_vw bh,
4564: mtl_parameters mp,
4565: gme_material_details bl,
4566: mtl_system_items_vl msi,
4567: mtl_material_transactions mmt