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 53: UPDATE gme_material_details

49: /* Set the return status to success initially */
50: x_return_status := fnd_api.g_ret_sts_success;
51:
52: -- renumber subsequent lines
53: UPDATE gme_material_details
54: SET line_no = line_no + 1
55: ,last_updated_by = gme_common_pvt.g_user_ident
56: ,last_update_date = gme_common_pvt.g_timestamp
57: ,last_update_login = gme_common_pvt.g_login_id

Line 67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec

63: gme_debug.put_line (g_pkg_name||'.'|| l_api_name||': '||SQL%ROWCOUNT||' records renumbered');
64: END IF;
65:
66: -- insert new material line
67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
68: ,x_material_detail_rec) THEN
69: l_proc := 'gme_material_details_dbl.insert_row';
70: RAISE error_dbl;
71: END IF;

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

65:
66: -- insert new material line
67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
68: ,x_material_detail_rec) THEN
69: l_proc := 'gme_material_details_dbl.insert_row';
70: RAISE error_dbl;
71: END IF;
72:
73: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

203: END IF;
204: END IF; -- IF recipe_id null
205: END IF;
206:
207: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
208: l_proc := 'gme_material_details_dbl.update_row';
209: RAISE error_dbl;
210: END IF;
211:

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

204: END IF; -- IF recipe_id null
205: END IF;
206:
207: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
208: l_proc := 'gme_material_details_dbl.update_row';
209: RAISE error_dbl;
210: END IF;
211:
212: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 350: ,p_material_detail_rec IN gme_material_details%ROWTYPE

346: *
347: ***********************************************************************/
348: PROCEDURE validate_material_for_ins (
349: p_batch_header_rec IN gme_batch_header%ROWTYPE
350: ,p_material_detail_rec IN gme_material_details%ROWTYPE
351: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
352: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
353: ,x_return_status OUT NOCOPY VARCHAR2)
354: IS

Line 352: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

348: PROCEDURE validate_material_for_ins (
349: p_batch_header_rec IN gme_batch_header%ROWTYPE
350: ,p_material_detail_rec IN gme_material_details%ROWTYPE
351: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
352: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
353: ,x_return_status OUT NOCOPY VARCHAR2)
354: IS
355: l_item_rec mtl_system_items_b%ROWTYPE;
356: l_status NUMBER;

Line 798: ,p_material_detail_rec IN gme_material_details%ROWTYPE

794: END validate_material_for_ins;
795:
796: PROCEDURE open_and_process_actual_qty (
797: p_batch_header_rec IN gme_batch_header%ROWTYPE
798: ,p_material_detail_rec IN gme_material_details%ROWTYPE
799: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE DEFAULT NULL
800: ,p_trans_id IN NUMBER
801: ,p_insert IN VARCHAR2
802: ,x_transacted OUT NOCOPY VARCHAR2

Line 943: p_material_detail_rec IN gme_material_details%ROWTYPE

939: * >0 => open actual qty: Yes with transaction id returned; must update existing transaction
940: * **********************
941: */
942: FUNCTION open_actual_qty (
943: p_material_detail_rec IN gme_material_details%ROWTYPE
944: ,p_batch_status IN NUMBER
945: ,p_update_inventory_ind IN VARCHAR2
946: ,p_batchstep_id IN NUMBER DEFAULT NULL
947: ,p_step_status IN NUMBER DEFAULT NULL

Line 1004: l_mtl_dtl_rec gme_material_details%ROWTYPE;

1000: --Bug#5129153 End.
1001: l_count_trans NUMBER;
1002: l_step_status NUMBER;
1003: l_trans_id NUMBER;
1004: l_mtl_dtl_rec gme_material_details%ROWTYPE;
1005: l_count_lot_trans NUMBER;
1006: l_release_type NUMBER;
1007: l_sub_locator_type NUMBER;
1008: l_txn_action NUMBER;

Line 1382: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1378: END open_actual_qty;
1379:
1380: PROCEDURE process_actual_qty (
1381: p_batch_header_rec IN gme_batch_header%ROWTYPE
1382: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1383: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1384: DEFAULT NULL
1385: ,p_trans_id IN NUMBER
1386: ,p_item_rec IN mtl_system_items_b%ROWTYPE

Line 1545: p_matl_dtl_rec IN gme_material_details%ROWTYPE

1541: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: END process_actual_qty;
1543:
1544: PROCEDURE construct_trans_row (
1545: p_matl_dtl_rec IN gme_material_details%ROWTYPE
1546: ,p_item_rec IN mtl_system_items_b%ROWTYPE
1547: ,p_batch_hdr_rec IN gme_batch_header%ROWTYPE
1548: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1549: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE

Line 2203: FROM gme_material_details

2199:
2200: CURSOR cur_last_line_no (v_batch_id NUMBER, v_line_type NUMBER)
2201: IS
2202: SELECT max(line_no)
2203: FROM gme_material_details
2204: WHERE batch_id = v_batch_id
2205: AND line_type = v_line_type;
2206:
2207: l_api_name CONSTANT VARCHAR2 (30) := 'validate_line_no';

Line 2468: p_material_detail_rec IN gme_material_details%ROWTYPE

2464: x_return_status := fnd_api.g_ret_sts_unexp_error;
2465: END validate_actual_qty;
2466:
2467: PROCEDURE validate_release_type (
2468: p_material_detail_rec IN gme_material_details%ROWTYPE
2469: ,p_release_type IN NUMBER
2470: ,x_return_status OUT NOCOPY VARCHAR2)
2471: IS
2472: CURSOR cur_rel_type (v_rel_type VARCHAR2) IS

Line 2755: p_material_detail_rec IN gme_material_details%ROWTYPE

2751: END validate_scale_type;
2752:
2753: --FPBug#4524232 changed parameter to p_material_detail_rec from p_cost_alloc
2754: PROCEDURE validate_cost_alloc(
2755: p_material_detail_rec IN gme_material_details%ROWTYPE
2756: ,x_return_status OUT NOCOPY VARCHAR2)
2757: IS
2758: --FPBug#4524232 Begin
2759: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS

Line 2770: FROM gme_material_details

2766: FROM gme_batch_header
2767: WHERE batch_id = v_batch_id;
2768: CURSOR Cur_get_cost_alloc(v_material_detail_id NUMBER) IS
2769: SELECT cost_alloc
2770: FROM gme_material_details
2771: WHERE material_detail_id = v_material_detail_id;
2772:
2773: l_batch_id NUMBER;
2774: l_material_detail_id NUMBER;

Line 3120: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3116: END validate_locator;
3117:
3118: PROCEDURE update_material_line (
3119: p_batch_header_rec IN gme_batch_header%ROWTYPE
3120: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3121: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3122: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3123: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3124: ,p_trans_id IN NUMBER

Line 3121: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

3117:
3118: PROCEDURE update_material_line (
3119: p_batch_header_rec IN gme_batch_header%ROWTYPE
3120: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3121: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3122: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3123: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3124: ,p_trans_id IN NUMBER
3125: ,x_transacted OUT NOCOPY VARCHAR2

Line 3127: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)

3123: ,p_scale_phantom IN VARCHAR2 := fnd_api.g_false
3124: ,p_trans_id IN NUMBER
3125: ,x_transacted OUT NOCOPY VARCHAR2
3126: ,x_return_status OUT NOCOPY VARCHAR2
3127: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
3128: IS
3129: l_api_name CONSTANT VARCHAR2 (30) := 'update_material_line';
3130: l_factor NUMBER;
3131: l_old_scrap NUMBER;

Line 3152: l_mtl_dtl_rec gme_material_details%ROWTYPE;

3148: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
3149: l_material_detail_tbl gme_common_pvt.material_details_tab;
3150: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3151:
3152: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3153: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3154: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3155: l_batch_step_rec gme_batch_steps%ROWTYPE;
3156: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 3153: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;

3149: l_material_detail_tbl gme_common_pvt.material_details_tab;
3150: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3151:
3152: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3153: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3154: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3155: l_batch_step_rec gme_batch_steps%ROWTYPE;
3156: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3157: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;

Line 3154: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;

3150: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3151:
3152: l_mtl_dtl_rec gme_material_details%ROWTYPE;
3153: l_ph_mtl_dtl_rec gme_material_details%ROWTYPE;
3154: l_db_mtl_dtl_rec gme_material_details%ROWTYPE;
3155: l_batch_step_rec gme_batch_steps%ROWTYPE;
3156: l_exception_material_tbl gme_common_pvt.exceptions_tab;
3157: l_ph_batch_step_rec gme_batch_steps%ROWTYPE;
3158: l_phantom_batch_header_rec_out gme_batch_header%ROWTYPE;

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

3331: -- 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.
3332:
3333: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3334: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3335: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3336: l_proc := 'gme_material_details_dbl.fetch_row';
3337: RAISE error_dbl;
3338: END IF;
3339: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

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

3332:
3333: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3334: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3335: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3336: l_proc := 'gme_material_details_dbl.fetch_row';
3337: RAISE error_dbl;
3338: END IF;
3339: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;
3340: l_ph_mtl_dtl_rec.release_type := l_mtl_dtl_rec.release_type;

Line 3504: FROM gme_material_details

3500: END IF;--IF l_db_mtl_dtl_rec.phantom_id IS NOT NULL
3501:
3502: /* 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. */
3503: SELECT last_update_date INTO l_ph_mtl_dtl_rec.last_update_date
3504: FROM gme_material_details
3505: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3506: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3507:
3508:

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

3505: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3506: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3507:
3508:
3509: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3510: l_proc := 'gme_material_details_dbl.update_row';
3511: RAISE error_dbl;
3512: END IF;
3513:

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

3506: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3507:
3508:
3509: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3510: l_proc := 'gme_material_details_dbl.update_row';
3511: RAISE error_dbl;
3512: END IF;
3513:
3514: END IF; -- IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN

Line 3592: FROM gme_material_details

3588: END IF;
3589: END IF;
3590: -- 4944024 KYH END
3591: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3592: FROM gme_material_details
3593: WHERE batch_id = l_mtl_dtl_rec.batch_id
3594: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3596: l_proc := 'gme_material_details_dbl.update_row';

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

3591: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3592: FROM gme_material_details
3593: WHERE batch_id = l_mtl_dtl_rec.batch_id
3594: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3596: l_proc := 'gme_material_details_dbl.update_row';
3597: RAISE error_dbl;
3598: -- nsinghi bug#5208923. added the else part.
3599: ELSE

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

3592: FROM gme_material_details
3593: WHERE batch_id = l_mtl_dtl_rec.batch_id
3594: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3596: l_proc := 'gme_material_details_dbl.update_row';
3597: RAISE error_dbl;
3598: -- nsinghi bug#5208923. added the else part.
3599: ELSE
3600: gme_common_pvt.get_who(x_user_ident => x_material_detail_rec.last_updated_by,

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

3611: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3612: gme_debug.put_line ( g_pkg_name
3613: || '.'
3614: || l_api_name
3615: || ' after gme_material_details_dbl.update_row');
3616: gme_debug.put_line ( g_pkg_name
3617: || '.'
3618: || l_api_name
3619: || ' successfully updated material_detail_id= '

Line 3690: ,p_material_detail_rec IN gme_material_details%ROWTYPE

3686:
3687: --Bug#5078853 removed p_validate_flexfields parameter
3688: PROCEDURE val_and_pop_material_for_upd (
3689: p_batch_header_rec IN gme_batch_header%ROWTYPE
3690: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3691: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3694: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3691: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE

3687: --Bug#5078853 removed p_validate_flexfields parameter
3688: PROCEDURE val_and_pop_material_for_upd (
3689: p_batch_header_rec IN gme_batch_header%ROWTYPE
3690: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3691: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3694: ,x_return_status OUT NOCOPY VARCHAR2)
3695: IS

Line 3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE

3689: p_batch_header_rec IN gme_batch_header%ROWTYPE
3690: ,p_material_detail_rec IN gme_material_details%ROWTYPE
3691: ,p_stored_material_detail_rec IN gme_material_details%ROWTYPE
3692: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3693: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
3694: ,x_return_status OUT NOCOPY VARCHAR2)
3695: IS
3696: l_item_rec mtl_system_items_b%ROWTYPE;
3697: l_batch_status NUMBER;

Line 3700: l_material_detail_rec gme_material_details%ROWTYPE;

3696: l_item_rec mtl_system_items_b%ROWTYPE;
3697: l_batch_status NUMBER;
3698: l_status NUMBER;
3699: l_step_status NUMBER;
3700: l_material_detail_rec gme_material_details%ROWTYPE;
3701:
3702: l_scale_type NUMBER;
3703: l_scale_round_var NUMBER;
3704: l_val_proc VARCHAR2 (100);

Line 4214: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4210:
4211: --Bug#5078853 Procedure Created
4212: PROCEDURE validate_material_for_del (
4213: p_batch_header_rec IN gme_batch_header%ROWTYPE
4214: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4215: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4216: ,x_return_status OUT NOCOPY VARCHAR2) IS
4217:
4218: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_del';

Line 4227: FROM gme_material_details

4223: WHERE organization_id = v_org_id;
4224:
4225: CURSOR num_detail_lines (v_batch_id NUMBER, v_line_type NUMBER) IS
4226: SELECT COUNT (*)
4227: FROM gme_material_details
4228: WHERE batch_id = v_batch_id AND
4229: line_type = v_line_type;
4230:
4231: CURSOR c_prim_prod(v_rule_id NUMBER, v_det_id NUMBER) IS

Line 4236: FROM gme_material_details

4232: SELECT 1
4233: FROM gmd_recipe_validity_rules
4234: WHERE recipe_validity_rule_id = v_rule_id
4235: AND inventory_item_id = (SELECT inventory_item_id
4236: FROM gme_material_details
4237: WHERE material_detail_id = v_det_id);
4238:
4239: /*CURSOR cur_parent_phant (v_batch_id NUMBER, v_item_id NUMBER) IS
4240: SELECT 1

Line 4356: p_material_detail_rec IN gme_material_details%ROWTYPE

4352: x_return_status := fnd_api.g_ret_sts_unexp_error;
4353: END validate_material_for_del;
4354:
4355: PROCEDURE validate_phantom_type_change (
4356: p_material_detail_rec IN gme_material_details%ROWTYPE
4357: ,x_return_status OUT NOCOPY VARCHAR2) IS
4358:
4359: val_error EXCEPTION;
4360:

Line 4411: ,p_material_detail_rec IN gme_material_details%ROWTYPE

4407: END validate_phantom_type_change;
4408:
4409: PROCEDURE delete_material_line (
4410: p_batch_header_rec IN gme_batch_header%ROWTYPE
4411: ,p_material_detail_rec IN gme_material_details%ROWTYPE
4412: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4413: ,x_transacted OUT NOCOPY VARCHAR2
4414: ,x_return_status OUT NOCOPY VARCHAR2)
4415: IS

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

4516: END IF;
4517: END IF;
4518: -- 4944024 END
4519:
4520: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4521: l_proc := 'gme_material_details_dbl.delete_row';
4522: RAISE error_dbl;
4523: END IF;
4524:

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

4517: END IF;
4518: -- 4944024 END
4519:
4520: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4521: l_proc := 'gme_material_details_dbl.delete_row';
4522: RAISE error_dbl;
4523: END IF;
4524:
4525: -- renumber subsequent lines

Line 4526: UPDATE gme_material_details

4522: RAISE error_dbl;
4523: END IF;
4524:
4525: -- renumber subsequent lines
4526: UPDATE gme_material_details
4527: SET line_no = line_no - 1
4528: ,last_updated_by = gme_common_pvt.g_user_ident
4529: ,last_update_date = gme_common_pvt.g_timestamp
4530: ,last_update_login = gme_common_pvt.g_login_id