APPS.GME_REOPEN_BATCH_PVT dependencies on GME_BATCH_HEADER

Line 49: p_batch_header_rec IN gme_batch_header%ROWTYPE

45: E - Error
46: U - Unexpected error
47: ================================================================================*/
48: PROCEDURE reopen_batch (
49: p_batch_header_rec IN gme_batch_header%ROWTYPE
50: ,p_reopen_steps IN VARCHAR2 := 'F'
51: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
52: ,x_return_status OUT NOCOPY VARCHAR2)
53: IS

Line 51: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

47: ================================================================================*/
48: PROCEDURE reopen_batch (
49: p_batch_header_rec IN gme_batch_header%ROWTYPE
50: ,p_reopen_steps IN VARCHAR2 := 'F'
51: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
52: ,x_return_status OUT NOCOPY VARCHAR2)
53: IS
54: /* Cursor to get all the phantom batches except ones
55: which are release type of "Automatic by Step" and attached to steps */

Line 79: l_batch_header gme_batch_header%ROWTYPE;

75: l_ins_history gme_batch_history%ROWTYPE;
76: l_material_details gme_material_details%ROWTYPE;
77: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
78: l_phantom_ids gme_common_pvt.number_tab;
79: l_batch_header gme_batch_header%ROWTYPE;
80: l_in_batch_header gme_batch_header%ROWTYPE;
81: l_dummy NUMBER;
82: l_message_count NUMBER;
83: l_message_list VARCHAR2 (2000);

Line 80: l_in_batch_header gme_batch_header%ROWTYPE;

76: l_material_details gme_material_details%ROWTYPE;
77: l_material_details_tab gme_reopen_batch_pvt.material_details_tab;
78: l_phantom_ids gme_common_pvt.number_tab;
79: l_batch_header gme_batch_header%ROWTYPE;
80: l_in_batch_header gme_batch_header%ROWTYPE;
81: l_dummy NUMBER;
82: l_message_count NUMBER;
83: l_message_list VARCHAR2 (2000);
84: /* Added local variables */

Line 212: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header

208: FOR i IN 1 .. l_phantom_ids.COUNT LOOP
209: l_batch_header.batch_id := l_phantom_ids (i);
210:
211: /* Initialize batch header*/
212: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header
213: ,l_in_batch_header) ) THEN
214: RAISE batch_header_fetch_err;
215: END IF;
216:

Line 257: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN

253: x_batch_header_rec.actual_cost_ind := 'N';
254:
255: -- STEP-8: Update the batch step to the database
256:
257: IF NOT (gme_batch_header_dbl.update_row (x_batch_header_rec) ) THEN
258: x_batch_header_rec.batch_status := 4;
259: x_batch_header_rec.batch_close_date := l_batch_close_date;
260: RAISE batch_header_upd_err;
261: END IF;

Line 393: FROM gme_batch_header

389:
390: CURSOR c_posted_in_history (l_batch_id IN NUMBER)
391: IS
392: SELECT gl_posted_ind
393: FROM gme_batch_header
394: WHERE gl_posted_ind > 1
395: AND batch_status = 4
396: AND batch_id = l_batch_id;
397: BEGIN

Line 444: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)

440: period_not_found EXCEPTION;
441: period_not_open EXCEPTION;
442:
443: /*
444: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
445: IS
446: -- See if any of the matl lines has been costed and frozen.
447: SELECT COUNT (1)
448: FROM cm_cmpt_dtl cst

Line 451: ,gme_batch_header bh

447: SELECT COUNT (1)
448: FROM cm_cmpt_dtl cst
449: ,cm_acst_led aled
450: ,gme_material_details md
451: ,gme_batch_header bh
452: WHERE bh.batch_id = l_batch_id
453: AND bh.batch_id = md.batch_id
454: AND md.material_detail_id = aled.transline_id
455: AND aled.source_ind = 0

Line 461: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)

457: AND cst.rollover_ind = 1;
458: */
459:
460: -- Bug 10634518 - Frontport 11i bug 6853392 but also rework using R12 tables and joins per GMF team.
461: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
462: IS
463: SELECT COUNT(1)
464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d
465: WHERE bh.batch_id = l_batch_id

Line 464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d

460: -- Bug 10634518 - Frontport 11i bug 6853392 but also rework using R12 tables and joins per GMF team.
461: CURSOR c_get_period_info (l_batch_id IN gme_batch_header.batch_id%TYPE)
462: IS
463: SELECT COUNT(1)
464: FROM cm_cmpt_dtl cst, cm_acst_led aled, gme_material_details md, gme_batch_header bh, gmf_period_statuses d
465: WHERE bh.batch_id = l_batch_id
466: AND bh.batch_id = md.batch_id
467: AND md.material_detail_id = aled.transline_id
468: AND aled.source_ind = 0