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.

[Home] [Help]

APPS.GME_API_PUB dependencies on GME_BATCH_STEPS

Line 2089: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

2085: p_api_version IN NUMBER := 2.0
2086: ,p_validation_level IN NUMBER
2087: ,p_init_msg_list IN VARCHAR2
2088: ,p_commit IN VARCHAR2
2089: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
2090: ,p_use_workday_cal IN VARCHAR2
2091: ,p_contiguity_override IN VARCHAR2
2092: ,p_org_code IN VARCHAR2
2093: ,p_batch_no IN VARCHAR2

Line 2100: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

2096: ,p_reschedule_succeeding IN VARCHAR2
2097: ,x_message_count OUT NOCOPY NUMBER
2098: ,x_message_list OUT NOCOPY VARCHAR2
2099: ,x_return_status OUT NOCOPY VARCHAR2
2100: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
2101: IS
2102: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
2103: l_diff NUMBER := 0;
2104: l_diff_cmplt NUMBER := 0;

Line 2107: l_batch_step_rec gme_batch_steps%ROWTYPE;

2103: l_diff NUMBER := 0;
2104: l_diff_cmplt NUMBER := 0;
2105: reschedule_step_failed EXCEPTION;
2106: l_batch_header_rec gme_batch_header%ROWTYPE;
2107: l_batch_step_rec gme_batch_steps%ROWTYPE;
2108: l_use VARCHAR2 (1);
2109: l_return_status VARCHAR2 (1);
2110: l_reschedule_preceding VARCHAR2 (1);
2111: l_reschedule_succeeding VARCHAR2 (1);

Line 3025: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE)

3021: ,p_batch_no IN VARCHAR2
3022: ,x_message_count OUT NOCOPY NUMBER
3023: ,x_message_list OUT NOCOPY VARCHAR2
3024: ,x_return_status OUT NOCOPY VARCHAR2
3025: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE)
3026: IS
3027: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_STEP';
3028: l_batch_header_rec gme_batch_header%rowtype;
3029: delete_step_failed EXCEPTION;

Line 3128: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

3124: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3125: ,p_oprn_no IN VARCHAR2
3126: ,p_oprn_vers IN NUMBER
3127: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3128: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3129: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3130: ,x_message_count OUT NOCOPY NUMBER
3131: ,x_message_list OUT NOCOPY VARCHAR2
3132: ,x_return_status OUT NOCOPY VARCHAR2)

Line 3129: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

3125: ,p_oprn_no IN VARCHAR2
3126: ,p_oprn_vers IN NUMBER
3127: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3128: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3129: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3130: ,x_message_count OUT NOCOPY NUMBER
3131: ,x_message_list OUT NOCOPY VARCHAR2
3132: ,x_return_status OUT NOCOPY VARCHAR2)
3133: IS

Line 3403: l_batch_step_rec gme_batch_steps%ROWTYPE;

3399:
3400: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_MATERIAL_LINE';
3401: l_batch_header_rec gme_batch_header%ROWTYPE;
3402: l_return_status VARCHAR2(1);
3403: l_batch_step_rec gme_batch_steps%ROWTYPE;
3404: l_material_detail_rec gme_material_details%ROWTYPE;
3405: p_trans_id NUMBER;
3406: l_locator_id NUMBER;
3407:

Line 3471: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

3467: IF l_batch_header_rec.poc_ind = 'Y' AND
3468: p_batchstep_no IS NOT NULL THEN
3469: l_batch_step_rec.batch_id := l_batch_header_rec.batch_id;
3470: l_batch_step_rec.batchstep_no := p_batchstep_no;
3471: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3472: RAISE fnd_api.g_exc_error;
3473: END IF;
3474: END IF;
3475:

Line 3636: l_batch_step_rec gme_batch_steps%ROWTYPE;

3632:
3633: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_LINE';
3634: l_batch_header_rec gme_batch_header%ROWTYPE;
3635: l_return_status VARCHAR2(1);
3636: l_batch_step_rec gme_batch_steps%ROWTYPE;
3637: l_material_detail_rec gme_material_details%ROWTYPE;
3638: l_stored_material_detail_rec gme_material_details%ROWTYPE;
3639: p_trans_id NUMBER;
3640: l_subinventory VARCHAR2(30);

Line 3712: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

3708: FETCH c_get_step_id INTO l_batchstep_id;
3709: IF c_get_step_id%FOUND THEN
3710: l_batch_step_rec.batchstep_id := l_batchstep_id;
3711:
3712: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3713: CLOSE c_get_step_id;
3714: RAISE fnd_api.g_exc_error;
3715: END IF;
3716: END IF;

Line 3872: l_batch_step_rec gme_batch_steps%ROWTYPE;

3868:
3869: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_LINE';
3870: l_batch_header_rec gme_batch_header%ROWTYPE;
3871: l_return_status VARCHAR2(1);
3872: l_batch_step_rec gme_batch_steps%ROWTYPE;
3873: l_material_detail_rec gme_material_details%ROWTYPE;
3874:
3875: l_batchstep_id NUMBER;
3876: x_transacted VARCHAR2(30);

Line 3932: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN

3928: FETCH c_get_step_id INTO l_batchstep_id;
3929: IF c_get_step_id%FOUND THEN
3930: l_batch_step_rec.batchstep_id := l_batchstep_id;
3931:
3932: IF NOT gme_batch_steps_dbl.fetch_row(l_batch_step_rec, l_batch_step_rec) THEN
3933: CLOSE c_get_step_id;
3934: RAISE fnd_api.g_exc_error;
3935: END IF;
3936: END IF;

Line 4226: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4222: ,x_message_list OUT NOCOPY VARCHAR2
4223: ,x_return_status OUT NOCOPY VARCHAR2
4224: ,p_org_code IN VARCHAR2
4225: ,p_batch_no IN VARCHAR2
4226: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4227: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
4228:
4229: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';
4230: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 4227: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS

4223: ,x_return_status OUT NOCOPY VARCHAR2
4224: ,p_org_code IN VARCHAR2
4225: ,p_batch_no IN VARCHAR2
4226: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4227: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
4228:
4229: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';
4230: l_batch_step_rec gme_batch_steps%ROWTYPE;
4231: l_batch_header_rec gme_batch_header%rowtype;

Line 4230: l_batch_step_rec gme_batch_steps%ROWTYPE;

4226: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4227: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)IS
4228:
4229: l_api_name CONSTANT VARCHAR2 (30) := 'REVERT_STEP';
4230: l_batch_step_rec gme_batch_steps%ROWTYPE;
4231: l_batch_header_rec gme_batch_header%rowtype;
4232:
4233: step_revert_failure EXCEPTION;
4234: BEGIN

Line 4513: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4509: ,p_commit IN VARCHAR2
4510: ,x_message_count OUT NOCOPY NUMBER
4511: ,x_message_list OUT NOCOPY VARCHAR2
4512: ,x_return_status OUT NOCOPY VARCHAR2
4513: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4514: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
4515: ,p_org_code IN VARCHAR2
4516: ,p_batch_no IN VARCHAR2
4517: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

Line 4517: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

4513: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4514: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
4515: ,p_org_code IN VARCHAR2
4516: ,p_batch_no IN VARCHAR2
4517: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4518: IS
4519: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
4520:
4521: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4522: l_batch_step_rec gme_batch_steps%ROWTYPE;

4518: IS
4519: l_api_name CONSTANT VARCHAR2 (30) := 'CLOSE_STEP';
4520:
4521: l_batch_header_rec gme_batch_header%ROWTYPE;
4522: l_batch_step_rec gme_batch_steps%ROWTYPE;
4523:
4524: step_close_failed EXCEPTION;
4525: BEGIN
4526: IF g_debug <= gme_debug.g_log_procedure THEN

Line 4766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

4762: ,x_message_list OUT NOCOPY VARCHAR2
4763: ,x_return_status OUT NOCOPY VARCHAR2
4764: ,p_org_code IN VARCHAR2
4765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4768: IS
4769: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';
4770: l_batch_header_rec gme_batch_header%ROWTYPE;

Line 4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

4763: ,x_return_status OUT NOCOPY VARCHAR2
4764: ,p_org_code IN VARCHAR2
4765: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
4766: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4768: IS
4769: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';
4770: l_batch_header_rec gme_batch_header%ROWTYPE;
4771: l_batch_step_rec gme_batch_steps%ROWTYPE;

Line 4771: l_batch_step_rec gme_batch_steps%ROWTYPE;

4767: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
4768: IS
4769: l_api_name CONSTANT VARCHAR2 (30):= 'REOPEN_STEP';
4770: l_batch_header_rec gme_batch_header%ROWTYPE;
4771: l_batch_step_rec gme_batch_steps%ROWTYPE;
4772: step_reopen_failure EXCEPTION;
4773: BEGIN
4774: IF g_debug <= gme_debug.g_log_procedure THEN
4775: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 7080: FROM gme_batch_steps

7076:
7077: CURSOR cur_get_step_status (v_batch_id NUMBER, v_batchstep_id NUMBER)
7078: IS
7079: SELECT step_status
7080: FROM gme_batch_steps
7081: WHERE batch_id = v_batch_id AND batchstep_id = v_batchstep_id;
7082: BEGIN
7083: IF (g_debug <> -1) THEN
7084: gme_debug.log_initialize ('InsertBatchstepResource');

Line 7308: ,'GME_BATCH_STEPS');

7304: CLOSE cur_get_step_status;
7305:
7306: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
7307: ,'TABLE_NAME'
7308: ,'GME_BATCH_STEPS');
7309: RAISE fnd_api.g_exc_error;
7310: END IF;
7311:
7312: IF g_debug <= gme_debug.g_log_statement THEN

Line 7487: FROM gme_batch_steps

7483: v_batchstep_id NUMBER
7484: ,v_batch_id NUMBER)
7485: IS
7486: SELECT step_status
7487: FROM gme_batch_steps
7488: WHERE batchstep_id = v_batchstep_id AND batch_id = v_batch_id;
7489:
7490: update_rsrc_failed EXCEPTION;
7491: BEGIN

Line 7782: FROM gme_batch_steps a

7778: CURSOR cur_get_step_dtl (v_batchstep_rsrc_id NUMBER)
7779: IS
7780: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id
7781: ,b.batchstep_activity_id, c.batch_status
7782: FROM gme_batch_steps a
7783: ,gme_batch_step_resources b
7784: ,gme_batch_header c
7785: WHERE a.batch_id = b.batch_id
7786: AND a.batchstep_id = b.batchstep_id

Line 10029: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

10025: ,p_commit IN VARCHAR2 := fnd_api.g_false
10026: ,x_message_count OUT NOCOPY NUMBER
10027: ,x_message_list OUT NOCOPY VARCHAR2
10028: ,x_return_status OUT NOCOPY VARCHAR2
10029: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10030: ,p_batch_no IN VARCHAR2
10031: ,p_org_code IN VARCHAR2
10032: ,p_create_resv_pend_lots IN NUMBER
10033: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

Line 10033: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)

10029: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10030: ,p_batch_no IN VARCHAR2
10031: ,p_org_code IN VARCHAR2
10032: ,p_create_resv_pend_lots IN NUMBER
10033: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
10034: IS
10035: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
10036:
10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

Line 10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

10033: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE)
10034: IS
10035: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
10036:
10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10038: l_batch_step_rec gme_batch_steps%ROWTYPE;
10039: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10040: l_batch_header_rec gme_batch_header%ROWTYPE;
10041:

Line 10038: l_batch_step_rec gme_batch_steps%ROWTYPE;

10034: IS
10035: l_api_name CONSTANT VARCHAR2 (30) := 'UNRELEASE_STEP';
10036:
10037: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10038: l_batch_step_rec gme_batch_steps%ROWTYPE;
10039: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10040: l_batch_header_rec gme_batch_header%ROWTYPE;
10041:
10042: error_unrelease_step EXCEPTION;

Line 10499: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

10495: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
10496: ,x_message_count OUT NOCOPY NUMBER
10497: ,x_message_list OUT NOCOPY VARCHAR2
10498: ,x_return_status OUT NOCOPY VARCHAR2
10499: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10500: ,p_batch_no IN VARCHAR2
10501: ,p_org_code IN VARCHAR2
10502: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10503: ,p_override_quality IN VARCHAR2 := fnd_api.g_false

Line 10505: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

10501: ,p_org_code IN VARCHAR2
10502: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10503: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
10504: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10505: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
10506: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10507: IS
10508: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
10509:

Line 10510: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

10506: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10507: IS
10508: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
10509:
10510: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10511: l_batch_step_rec gme_batch_steps%ROWTYPE;
10512: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10513: l_batch_header_rec gme_batch_header%ROWTYPE;
10514: l_calc_batch_start_date DATE;

Line 10511: l_batch_step_rec gme_batch_steps%ROWTYPE;

10507: IS
10508: l_api_name CONSTANT VARCHAR2 (30) := 'COMPLETE_STEP';
10509:
10510: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10511: l_batch_step_rec gme_batch_steps%ROWTYPE;
10512: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10513: l_batch_header_rec gme_batch_header%ROWTYPE;
10514: l_calc_batch_start_date DATE;
10515:

Line 10975: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

10971: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
10972: ,x_message_count OUT NOCOPY NUMBER
10973: ,x_message_list OUT NOCOPY VARCHAR2
10974: ,x_return_status OUT NOCOPY VARCHAR2
10975: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
10976: ,p_batch_no IN VARCHAR2
10977: ,p_org_code IN VARCHAR2
10978: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10979: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

Line 10980: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

10976: ,p_batch_no IN VARCHAR2
10977: ,p_org_code IN VARCHAR2
10978: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
10979: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
10980: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
10981: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10982: IS
10983: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10984:

Line 10985: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

10981: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab)
10982: IS
10983: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10984:
10985: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10986: l_batch_step_rec gme_batch_steps%ROWTYPE;
10987: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10988: l_batch_header_rec gme_batch_header%ROWTYPE;
10989:

Line 10986: l_batch_step_rec gme_batch_steps%ROWTYPE;

10982: IS
10983: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
10984:
10985: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
10986: l_batch_step_rec gme_batch_steps%ROWTYPE;
10987: l_in_batch_header_rec gme_batch_header%ROWTYPE;
10988: l_batch_header_rec gme_batch_header%ROWTYPE;
10989:
10990: l_exception_material_tbl gme_common_pvt.exceptions_tab;

Line 11608: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

11604: ,p_commit IN VARCHAR2
11605: ,p_org_code IN VARCHAR2
11606: ,p_batch_no IN VARCHAR2 := NULL
11607: ,p_add IN VARCHAR2 := 'N'
11608: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
11609: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
11610: ,x_message_count OUT NOCOPY NUMBER
11611: ,x_message_list OUT NOCOPY VARCHAR2
11612: ,x_return_status OUT NOCOPY VARCHAR2)

Line 11609: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

11605: ,p_org_code IN VARCHAR2
11606: ,p_batch_no IN VARCHAR2 := NULL
11607: ,p_add IN VARCHAR2 := 'N'
11608: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
11609: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
11610: ,x_message_count OUT NOCOPY NUMBER
11611: ,x_message_list OUT NOCOPY VARCHAR2
11612: ,x_return_status OUT NOCOPY VARCHAR2)
11613:

Line 11618: l_batch_step_rec gme_batch_steps%ROWTYPE;

11614: IS
11615: l_api_name CONSTANT VARCHAR2 (30)
11616: := 'UPDATE_STEP';
11617: l_batch_header gme_batch_header%ROWTYPE;
11618: l_batch_step_rec gme_batch_steps%ROWTYPE;
11619: l_batch_step_rec2 gme_batch_steps%ROWTYPE;
11620: l_return_status VARCHAR2 (2);
11621: l_step_status NUMBER;
11622: l_record_changed NUMBER;

Line 11619: l_batch_step_rec2 gme_batch_steps%ROWTYPE;

11615: l_api_name CONSTANT VARCHAR2 (30)
11616: := 'UPDATE_STEP';
11617: l_batch_header gme_batch_header%ROWTYPE;
11618: l_batch_step_rec gme_batch_steps%ROWTYPE;
11619: l_batch_step_rec2 gme_batch_steps%ROWTYPE;
11620: l_return_status VARCHAR2 (2);
11621: l_step_status NUMBER;
11622: l_record_changed NUMBER;
11623: