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_MATERIAL_DETAIL_PVT dependencies on GME_MATERIAL_DETAILS

Line 8: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4: g_pkg_name VARCHAR2 (30) := 'gme_material_detail_pvt';
5:
6: PROCEDURE insert_material_line
7: (p_batch_header_rec IN gme_batch_header%ROWTYPE
8: ,p_material_detail_rec IN gme_material_details%ROWTYPE
9: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10: ,p_trans_id IN NUMBER
11: ,x_transacted OUT NOCOPY VARCHAR2
12: ,x_return_status OUT NOCOPY VARCHAR2

Line 13: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

9: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10: ,p_trans_id IN NUMBER
11: ,x_transacted OUT NOCOPY VARCHAR2
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
14: IS
15: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
16: l_material_detail_rec gme_material_details%ROWTYPE;
17: l_batchstep_items gme_batch_step_items%ROWTYPE;

Line 16: l_material_detail_rec gme_material_details%ROWTYPE;

12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
14: IS
15: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
16: l_material_detail_rec gme_material_details%ROWTYPE;
17: l_batchstep_items gme_batch_step_items%ROWTYPE;
18: l_batch_step_rec gme_batch_steps%ROWTYPE;
19: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
20: l_material_detail_tbl gme_common_pvt.material_details_tab;

Line 58: UPDATE gme_material_details

54: /* Set the return status to success initially */
55: x_return_status := fnd_api.g_ret_sts_success;
56:
57: -- renumber subsequent lines
58: UPDATE gme_material_details
59: SET line_no = line_no + 1
60: ,last_updated_by = gme_common_pvt.g_user_ident
61: ,last_update_date = gme_common_pvt.g_timestamp
62: ,last_update_login = gme_common_pvt.g_login_id

Line 72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec

68: gme_debug.put_line (g_pkg_name||'.'|| l_api_name||': '||SQL%ROWCOUNT||' records renumbered');
69: END IF;
70:
71: -- insert new material line
72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
73: ,x_material_detail_rec) THEN
74: l_proc := 'gme_material_details_dbl.insert_row';
75: RAISE error_dbl;
76: END IF;

Line 74: l_proc := 'gme_material_details_dbl.insert_row';

70:
71: -- insert new material line
72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
73: ,x_material_detail_rec) THEN
74: l_proc := 'gme_material_details_dbl.insert_row';
75: RAISE error_dbl;
76: END IF;
77:
78: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 247: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN

243: END IF;
244: END IF; -- IF recipe_id null
245: END IF;
246:
247: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
248: l_proc := 'gme_material_details_dbl.update_row';
249: RAISE error_dbl;
250: END IF;
251:

Line 248: l_proc := 'gme_material_details_dbl.update_row';

244: END IF; -- IF recipe_id null
245: END IF;
246:
247: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
248: l_proc := 'gme_material_details_dbl.update_row';
249: RAISE error_dbl;
250: END IF;
251:
252: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 390: ,p_material_detail_rec IN gme_material_details%ROWTYPE

386: *
387: ***********************************************************************/
388: PROCEDURE validate_material_for_ins (
389: p_batch_header_rec IN gme_batch_header%ROWTYPE
390: ,p_material_detail_rec IN gme_material_details%ROWTYPE
391: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
392: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
393: ,x_return_status OUT NOCOPY VARCHAR2)
394: IS

Line 392: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

388: PROCEDURE validate_material_for_ins (
389: p_batch_header_rec IN gme_batch_header%ROWTYPE
390: ,p_material_detail_rec IN gme_material_details%ROWTYPE
391: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
392: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
393: ,x_return_status OUT NOCOPY VARCHAR2)
394: IS
395: l_item_rec mtl_system_items_b%ROWTYPE;
396: l_status NUMBER;

Line 838: ,p_material_detail_rec IN gme_material_details%ROWTYPE

834: END validate_material_for_ins;
835:
836: PROCEDURE open_and_process_actual_qty (
837: p_batch_header_rec IN gme_batch_header%ROWTYPE
838: ,p_material_detail_rec IN gme_material_details%ROWTYPE
839: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL
840: ,p_trans_id IN NUMBER
841: ,p_insert IN VARCHAR2
842: ,x_transacted OUT NOCOPY VARCHAR2

Line 983: p_material_detail_rec IN gme_material_details%ROWTYPE

979: * >0 => open actual qty: Yes with transaction id returned; must update existing transaction
980: * **********************
981: */
982: FUNCTION open_actual_qty (
983: p_material_detail_rec IN gme_material_details%ROWTYPE
984: ,p_batch_status IN NUMBER
985: ,p_update_inventory_ind IN VARCHAR2
986: ,p_batchstep_id IN NUMBER DEFAULT NULL
987: ,p_step_status IN NUMBER DEFAULT NULL

Line 1044: l_mtl_dtl_rec gme_material_details%ROWTYPE;

1040: --Bug#5129153 End.
1041: l_count_trans NUMBER;
1042: l_step_status NUMBER;
1043: l_trans_id NUMBER;
1044: l_mtl_dtl_rec gme_material_details%ROWTYPE;
1045: l_count_lot_trans NUMBER;
1046: l_release_type NUMBER;
1047: l_sub_locator_type NUMBER;
1048: l_txn_action NUMBER;

Line 1422: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1418: END open_actual_qty;
1419:
1420: PROCEDURE process_actual_qty (
1421: p_batch_header_rec IN gme_batch_header%ROWTYPE
1422: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1423: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1424: DEFAULT NULL
1425: ,p_trans_id IN NUMBER
1426: ,p_item_rec IN mtl_system_items_b%ROWTYPE

Line 1688: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1684: x_return_status := fnd_api.g_ret_sts_unexp_error;
1685: END process_actual_qty;
1686:
1687: PROCEDURE construct_trans_row (
1688: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1689: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1690: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1691: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1692: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

Line 2347: FROM gme_material_details

2343:
2344: CURSOR cur_last_line_no (v_batch_id NUMBER, v_line_type NUMBER)
2345: IS
2346: SELECT max(line_no)
2347: FROM gme_material_details
2348: WHERE batch_id = v_batch_id
2349: AND line_type = v_line_type;
2350:
2351: l_api_name CONSTANT VARCHAR2 (30) := 'validate_line_no';

Line 2612: p_material_detail_rec IN gme_material_details%ROWTYPE

2608: x_return_status := fnd_api.g_ret_sts_unexp_error;
2609: END validate_actual_qty;
2610:
2611: PROCEDURE validate_release_type (
2612: p_material_detail_rec IN gme_material_details%ROWTYPE
2613: ,p_release_type IN NUMBER
2614: ,x_return_status OUT NOCOPY VARCHAR2)
2615: IS
2616: CURSOR cur_rel_type (v_rel_type VARCHAR2) IS

Line 2899: p_material_detail_rec IN gme_material_details%ROWTYPE

2895: END validate_scale_type;
2896:
2897: --FPBug#4524232 changed parameter to p_material_detail_rec from p_cost_alloc
2898: PROCEDURE validate_cost_alloc(
2899: p_material_detail_rec IN gme_material_details%ROWTYPE
2900: ,x_return_status OUT NOCOPY VARCHAR2)
2901: IS
2902: --FPBug#4524232 Begin
2903: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS

Line 2914: FROM gme_material_details

2910: FROM gme_batch_header
2911: WHERE batch_id = v_batch_id;
2912: CURSOR Cur_get_cost_alloc(v_material_detail_id NUMBER) IS
2913: SELECT cost_alloc
2914: FROM gme_material_details
2915: WHERE material_detail_id = v_material_detail_id;
2916:
2917: l_batch_id NUMBER;
2918: l_material_detail_id NUMBER;

Line 3264: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3260: END validate_locator;
3261:
3262: PROCEDURE update_material_line (
3263: p_batch_header_rec IN gme_batch_header%ROWTYPE
3264: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3265: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3266: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3267: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3268: ,p_trans_id IN NUMBER

Line 3265: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

3261:
3262: PROCEDURE update_material_line (
3263: p_batch_header_rec IN gme_batch_header%ROWTYPE
3264: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3265: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3266: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3267: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3268: ,p_trans_id IN NUMBER
3269: ,x_transacted OUT NOCOPY VARCHAR2

Line 3271: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

3267: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3268: ,p_trans_id IN NUMBER
3269: ,x_transacted OUT NOCOPY VARCHAR2
3270: ,x_return_status OUT NOCOPY VARCHAR2
3271: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
3272: IS
3273: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line';
3274: l_factor NUMBER;
3275: l_old_scrap NUMBER;

Line 3298: l_mtl_dtl_rec gme_material_details%ROWTYPE;

3294: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3295: l_material_detail_tbl gme_common_pvt.material_details_tab;
3296: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3297:
3298: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3299: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3300: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3301: l_batch_step_rec gme_batch_steps%ROWTYPE;
3302: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 3299: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;

3295: l_material_detail_tbl gme_common_pvt.material_details_tab;
3296: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3297:
3298: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3299: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3300: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3301: l_batch_step_rec gme_batch_steps%ROWTYPE;
3302: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3303: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;

Line 3300: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;

3296: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3297:
3298: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3299: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3300: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3301: l_batch_step_rec gme_batch_steps%ROWTYPE;
3302: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3303: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;
3304: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;

Line 3481: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN

3477: -- ToDo Put an IF condition to check if material_requirement_date has changed or release_type has changed. Only if either has changed, then we need to do the re-schedule stuff.
3478:
3479: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3480: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3481: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3482: l_proc := 'gme_material_details_dbl.fetch_row';
3483: RAISE error_dbl;
3484: END IF;
3485: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

Line 3482: l_proc := 'gme_material_details_dbl.fetch_row';

3478:
3479: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3480: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3481: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3482: l_proc := 'gme_material_details_dbl.fetch_row';
3483: RAISE error_dbl;
3484: END IF;
3485: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;
3486: l_ph_mtl_dtl_rec.release_type := l_mtl_dtl_rec.release_type;

Line 3650: FROM gme_material_details

3646: END IF;--IF l_db_mtl_dtl_rec.phantom_id IS NOT NULL
3647:
3648: /* Sunitha REWORK Bug 5353941. We do not need to call fetch_row, as this will override the updated values of material_requirement_date, release_type, subinventory and locator that have been set above. */
3649: SELECT last_update_date INTO l_ph_mtl_dtl_rec.last_update_date
3650: FROM gme_material_details
3651: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3652: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3653:
3654:

Line 3655: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN

3651: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3652: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3653:
3654:
3655: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3656: l_proc := 'gme_material_details_dbl.update_row';
3657: RAISE error_dbl;
3658: END IF;
3659:

Line 3656: l_proc := 'gme_material_details_dbl.update_row';

3652: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3653:
3654:
3655: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3656: l_proc := 'gme_material_details_dbl.update_row';
3657: RAISE error_dbl;
3658: END IF;
3659:
3660: END IF; -- IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN

Line 3783: FROM gme_material_details

3779: END IF;
3780: END IF;
3781: -- 4944024 KYH END
3782: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3783: FROM gme_material_details
3784: WHERE batch_id = l_mtl_dtl_rec.batch_id
3785: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3787: l_proc := 'gme_material_details_dbl.update_row';

Line 3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN

3782: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3783: FROM gme_material_details
3784: WHERE batch_id = l_mtl_dtl_rec.batch_id
3785: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3787: l_proc := 'gme_material_details_dbl.update_row';
3788: RAISE error_dbl;
3789: -- nsinghi bug#5208923. added the else part.
3790: ELSE

Line 3787: l_proc := 'gme_material_details_dbl.update_row';

3783: FROM gme_material_details
3784: WHERE batch_id = l_mtl_dtl_rec.batch_id
3785: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3787: l_proc := 'gme_material_details_dbl.update_row';
3788: RAISE error_dbl;
3789: -- nsinghi bug#5208923. added the else part.
3790: ELSE
3791: gme_common_pvt.get_who(x_user_ident => x_material_detail_rec.last_updated_by,

Line 3806: || ' after gme_material_details_dbl.update_row');

3802: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3803: gme_debug.put_line ( g_pkg_name
3804: || '.'
3805: || l_api_name
3806: || ' after gme_material_details_dbl.update_row');
3807: gme_debug.put_line ( g_pkg_name
3808: || '.'
3809: || l_api_name
3810: || ' successfully updated material_detail_id= '

Line 3881: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3877:
3878: --Bug#5078853 removed p_validate_flexfields parameter
3879: PROCEDURE val_and_pop_material_for_upd (
3880: p_batch_header_rec IN gme_batch_header%ROWTYPE
3881: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3882: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3885: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3882: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

3878: --Bug#5078853 removed p_validate_flexfields parameter
3879: PROCEDURE val_and_pop_material_for_upd (
3880: p_batch_header_rec IN gme_batch_header%ROWTYPE
3881: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3882: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3885: ,x_return_status OUT NOCOPY VARCHAR2)
3886: IS

Line 3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3880: p_batch_header_rec IN gme_batch_header%ROWTYPE
3881: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3882: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3883: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3884: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3885: ,x_return_status OUT NOCOPY VARCHAR2)
3886: IS
3887: l_item_rec mtl_system_items_b%ROWTYPE;
3888: l_batch_status NUMBER;

Line 3891: l_material_detail_rec gme_material_details%ROWTYPE;

3887: l_item_rec mtl_system_items_b%ROWTYPE;
3888: l_batch_status NUMBER;
3889: l_status NUMBER;
3890: l_step_status NUMBER;
3891: l_material_detail_rec gme_material_details%ROWTYPE;
3892:
3893: l_scale_type NUMBER;
3894: l_scale_round_var NUMBER;
3895: l_val_proc VARCHAR2 (100);

Line 4405: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4401:
4402: --Bug#5078853 Procedure Created
4403: PROCEDURE validate_material_for_del (
4404: p_batch_header_rec IN gme_batch_header%ROWTYPE
4405: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4406: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4407: ,x_return_status OUT NOCOPY VARCHAR2) IS
4408:
4409: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_del';

Line 4418: FROM gme_material_details

4414: WHERE organization_id = v_org_id;
4415:
4416: CURSOR num_detail_lines (v_batch_id NUMBER, v_line_type NUMBER) IS
4417: SELECT COUNT (*)
4418: FROM gme_material_details
4419: WHERE batch_id = v_batch_id AND
4420: line_type = v_line_type;
4421:
4422: CURSOR c_prim_prod(v_rule_id NUMBER, v_det_id NUMBER) IS

Line 4427: FROM gme_material_details

4423: SELECT 1
4424: FROM gmd_recipe_validity_rules
4425: WHERE recipe_validity_rule_id = v_rule_id
4426: AND inventory_item_id = (SELECT inventory_item_id
4427: FROM gme_material_details
4428: WHERE material_detail_id = v_det_id);
4429:
4430: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4431: SELECT 1

Line 4549: p_material_detail_rec IN gme_material_details%ROWTYPE

4545: x_return_status := fnd_api.g_ret_sts_unexp_error;
4546: END validate_material_for_del;
4547:
4548: PROCEDURE validate_phantom_type_change (
4549: p_material_detail_rec IN gme_material_details%ROWTYPE
4550: ,x_return_status OUT NOCOPY VARCHAR2) IS
4551:
4552: val_error EXCEPTION;
4553:

Line 4604: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4600: END validate_phantom_type_change;
4601:
4602: PROCEDURE delete_material_line (
4603: p_batch_header_rec IN gme_batch_header%ROWTYPE
4604: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4605: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4606: ,x_transacted OUT NOCOPY VARCHAR2
4607: ,x_return_status OUT NOCOPY VARCHAR2)
4608: IS

Line 4713: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN

4709: END IF;
4710: END IF;
4711: -- 4944024 END
4712:
4713: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4714: l_proc := 'gme_material_details_dbl.delete_row';
4715: RAISE error_dbl;
4716: END IF;
4717:

Line 4714: l_proc := 'gme_material_details_dbl.delete_row';

4710: END IF;
4711: -- 4944024 END
4712:
4713: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4714: l_proc := 'gme_material_details_dbl.delete_row';
4715: RAISE error_dbl;
4716: END IF;
4717:
4718: -- renumber subsequent lines

Line 4719: UPDATE gme_material_details

4715: RAISE error_dbl;
4716: END IF;
4717:
4718: -- renumber subsequent lines
4719: UPDATE gme_material_details
4720: SET line_no = line_no - 1
4721: ,last_updated_by = gme_common_pvt.g_user_ident
4722: ,last_update_date = gme_common_pvt.g_timestamp
4723: ,last_update_login = gme_common_pvt.g_login_id