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.MIGRATE_BATCH dependencies on PM_BTCH_HDR_BAK

Line 85: g_batch_id pm_btch_hdr_bak.batch_id%TYPE;

81: -- G. Muratore - 06/09/2005 Bug 4249832 Removed hard coded schemas per gscc.
82: /***********************************************************/
83:
84: g_resource pm_oprn_dtl.resources%TYPE;
85: g_batch_id pm_btch_hdr_bak.batch_id%TYPE;
86: g_min_capacity NUMBER;
87: g_max_capacity NUMBER;
88: g_capacity_uom VARCHAR2 (4);
89: g_mig_date DATE := NULL;

Line 188: UPDATE pm_btch_hdr_bak

184: l_pos NUMBER := 0;
185: BEGIN
186: l_pos := 1;
187:
188: UPDATE pm_btch_hdr_bak
189: SET in_use = 0
190: WHERE in_use IS NULL OR
191: in_use NOT in (0,100);
192:

Line 476: pm_btch_hdr_bak bhdr

472: INTO v_actual_cost_ind
473: FROM cm_cmpt_dtl ccd,
474: cm_acst_led acl,
475: pm_matl_dtl_bak bdtl,
476: pm_btch_hdr_bak bhdr
477: WHERE ccd.cmpntcost_id = acl.cmpntcost_id AND
478: ccd.delete_mark = 0 AND
479: acl.source_ind = 0 AND
480: acl.transline_id = bdtl.line_id AND

Line 495: p_table_name => 'cm_cmpt_dtl, cm_acst_led, pm_matl_dtl_bak, pm_btch_hdr_bak',

491: END IF;
492: EXCEPTION
493: WHEN OTHERS THEN
494: insert_message (
495: p_table_name => 'cm_cmpt_dtl, cm_acst_led, pm_matl_dtl_bak, pm_btch_hdr_bak',
496: p_procedure_name => 'get_actual_cost_ind',
497: p_parameters => p_batch_id,
498: p_message => SQLERRM || ' with pos = ' || l_pos,
499: p_error_type => 'D'

Line 665: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,

661: RAISE;
662: END get_activity_id;
663:
664: FUNCTION get_rsrc_offset (
665: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
666: p_batchstep_no IN pm_rout_dtl.batchstep_no%TYPE,
667: p_activity IN pm_oprn_dtl.activity%TYPE,
668: p_offset IN pm_oprn_dtl.offset_interval%TYPE
669: )

Line 706: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,

702: RAISE;
703: END get_rsrc_offset;
704:
705: PROCEDURE get_capacity (
706: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
707: p_resources IN pm_oprn_dtl.resources%TYPE,
708: x_min_capacity OUT NOCOPY NUMBER,
709: x_max_capacity OUT NOCOPY NUMBER,
710: x_capacity_uom OUT NOCOPY VARCHAR2,

Line 715: v_batch_id pm_btch_hdr_bak.batch_id%TYPE

711: x_return_status OUT NOCOPY VARCHAR2
712: ) IS
713: CURSOR get_resource_capacity (
714: v_rsrc pm_oprn_dtl.resources%TYPE,
715: v_batch_id pm_btch_hdr_bak.batch_id%TYPE
716: ) IS
717: SELECT min_capacity,
718: max_capacity,
719: capacity_uom

Line 723: FROM pm_btch_hdr_bak

719: capacity_uom
720: FROM cr_rsrc_dtl
721: WHERE resources = v_rsrc AND
722: orgn_code = (SELECT plant_code
723: FROM pm_btch_hdr_bak
724: WHERE batch_id = v_batch_id);
725:
726: l_return_status VARCHAR2 (1);
727: l_pos NUMBER := 0;

Line 781: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,

777: RAISE;
778: END get_capacity;
779:
780: FUNCTION get_min_capacity (
781: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
782: p_rsrc pm_oprn_dtl.resources%TYPE
783: )
784: RETURN NUMBER IS
785: l_min_c NUMBER;

Line 838: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,

834: RAISE;
835: END get_min_capacity;
836:
837: FUNCTION get_max_capacity (
838: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
839: p_rsrc pm_oprn_dtl.resources%TYPE
840: )
841: RETURN NUMBER IS
842: l_min_c NUMBER;

Line 895: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,

891: RAISE;
892: END get_max_capacity;
893:
894: FUNCTION get_capacity_uom (
895: p_batch_id pm_btch_hdr_bak.batch_id%TYPE,
896: p_rsrc pm_oprn_dtl.resources%TYPE
897: )
898: RETURN VARCHAR2 IS
899: l_min_c NUMBER;

Line 960: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;

956: RETURN NUMBER IS
957: v_batch_status NUMBER;
958: v_qty NUMBER;
959: v_line_type pm_matl_dtl_bak.line_type%TYPE;
960: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
961: l_pos NUMBER := 0;
962: BEGIN
963: l_pos := 1;
964: SELECT batch_status, batch_type

Line 1040: v_plant_code pm_btch_hdr_bak.plant_code%TYPE;

1036: p_plan_qty IN NUMBER
1037: )
1038: RETURN NUMBER IS
1039: v_batch_status NUMBER;
1040: v_plant_code pm_btch_hdr_bak.plant_code%TYPE;
1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;
1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
1043: v_qty NUMBER;
1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;

Line 1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;

1037: )
1038: RETURN NUMBER IS
1039: v_batch_status NUMBER;
1040: v_plant_code pm_btch_hdr_bak.plant_code%TYPE;
1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;
1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
1043: v_qty NUMBER;
1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1045: v_line_no pm_matl_dtl_bak.line_no%TYPE;

Line 1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;

1038: RETURN NUMBER IS
1039: v_batch_status NUMBER;
1040: v_plant_code pm_btch_hdr_bak.plant_code%TYPE;
1041: v_batch_no pm_btch_hdr_bak.batch_no%TYPE;
1042: v_batch_type pm_btch_hdr_bak.batch_type%TYPE;
1043: v_qty NUMBER;
1044: v_line_type pm_matl_dtl_bak.line_type%TYPE;
1045: v_line_no pm_matl_dtl_bak.line_no%TYPE;
1046: l_pos NUMBER := 0;

Line 1242: l_batch_header pm_btch_hdr_bak%ROWTYPE;

1238: x_return_status OUT NOCOPY VARCHAR2,
1239: p_reverse_compl_def_txns IN BOOLEAN DEFAULT FALSE
1240: ) IS
1241: /* Local variables */
1242: l_batch_header pm_btch_hdr_bak%ROWTYPE;
1243: l_return_status VARCHAR2 (1);
1244: l_trans_is_reversed NUMBER;
1245: l_is_plain BOOLEAN;
1246: l_def_lot_id ic_tran_pnd.trans_id%TYPE;

Line 1275: FROM pm_btch_hdr_bak h, pm_matl_dtl_bak d

1271: h.batch_type,
1272: h.batch_no,
1273: d.line_no,
1274: d.line_id
1275: FROM pm_btch_hdr_bak h, pm_matl_dtl_bak d
1276: WHERE h.batch_status = 2 AND
1277: d.batch_id = h.batch_id AND
1278: d.line_type IN (-1, 1) AND
1279: d.in_use <

Line 2064: FROM pm_btch_hdr_bak;

2060: FUNCTION GME_data_exists RETURN BOOLEAN IS
2061:
2062: CURSOR cur_num_batches IS
2063: SELECT count(1)
2064: FROM pm_btch_hdr_bak;
2065:
2066: l_num_batches NUMBER;
2067: l_pos NUMBER;
2068: BEGIN

Line 2640: FROM pm_btch_hdr_bak

2636: attribute28,
2637: attribute29,
2638: attribute30,
2639: attribute_category
2640: FROM pm_btch_hdr_bak
2641: WHERE in_use < 100;
2642:
2643: insert_message (
2644: p_table_name => 'gme_batch_header',

Line 2653: UPDATE pm_btch_hdr_bak

2649: );
2650:
2651: /* If we get here, that means that the above insert was successful;
2652: let's indicate that the base batches were migrated */
2653: UPDATE pm_btch_hdr_bak
2654: SET in_use = in_use + 100
2655: WHERE in_use < 100;
2656: EXCEPTION
2657: WHEN OTHERS THEN

Line 2660: p_table_name => 'pm_btch_hdr_bak/gme_batch_header',

2656: EXCEPTION
2657: WHEN OTHERS THEN
2658: x_return_status := 'D';
2659: insert_message (
2660: p_table_name => 'pm_btch_hdr_bak/gme_batch_header',
2661: p_procedure_name => 'insert_batch_header',
2662: p_parameters => 'none',
2663: p_message => SQLERRM,
2664: p_error_type => x_return_status

Line 4212: FROM pm_matl_dtl_bak m, pm_btch_hdr_bak b

4208: PROCEDURE split_trans_line (x_return_status OUT NOCOPY VARCHAR2) IS
4209: CURSOR cur_get_materials IS
4210: SELECT b.batch_id,
4211: m.line_id
4212: FROM pm_matl_dtl_bak m, pm_btch_hdr_bak b
4213: WHERE m.in_use < 100 AND -- => only check for lines that were not migrated
4214: b.batch_id = m.batch_id AND
4215: b.batch_status IN (2, 3) AND
4216: b.batch_type = 0

Line 4225: l_batch_header pm_btch_hdr_bak%ROWTYPE;

4221: l_def_lot_id ic_tran_pnd.trans_id%TYPE;
4222: l_trans_id ic_tran_pnd.trans_id%TYPE;
4223: l_is_plain BOOLEAN;
4224: l_load_trans_fail BOOLEAN;
4225: l_batch_header pm_btch_hdr_bak%ROWTYPE;
4226: l_pos NUMBER := 0;
4227: l_flip_count NUMBER := 0;
4228: l_new_txn_count NUMBER := 0;
4229: l_return_status VARCHAR2 (1);

Line 4444: p_batch_row IN pm_btch_hdr_bak%ROWTYPE,

4440: RAISE;
4441: END split_trans_line;
4442:
4443: PROCEDURE load_trans (
4444: p_batch_row IN pm_btch_hdr_bak%ROWTYPE,
4445: x_return_status OUT NOCOPY VARCHAR2
4446: ) IS
4447: CURSOR c_get_init_reversal IS
4448: SELECT *

Line 4501: l_batch_id pm_btch_hdr_bak.batch_id%TYPE;

4497: ROWNUM = 1;
4498:
4499: l_api_name CONSTANT VARCHAR2 (30) := 'LOAD_TRANS';
4500: l_inv_exists NUMBER := 0;
4501: l_batch_id pm_btch_hdr_bak.batch_id%TYPE;
4502: l_doc_type ic_tran_pnd.doc_type%TYPE;
4503: init_revs c_get_init_reversal%ROWTYPE;
4504: match_revs c_get_match_reversal%ROWTYPE;
4505: l_last_txn c_get_cmplt_zero_def_txns%ROWTYPE;

Line 4508: l_batch_row pm_btch_hdr_bak%ROWTYPE;

4504: match_revs c_get_match_reversal%ROWTYPE;
4505: l_last_txn c_get_cmplt_zero_def_txns%ROWTYPE;
4506: l_current_txn c_get_cmplt_zero_def_txns%ROWTYPE;
4507: l_return_status VARCHAR2 (1) := FND_API.G_RET_STS_SUCCESS;
4508: l_batch_row pm_btch_hdr_bak%ROWTYPE;
4509: no_batch_id EXCEPTION;
4510: error_inserting_txn EXCEPTION;
4511: BEGIN
4512: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4524: FROM pm_btch_hdr_bak

4520:
4521: l_batch_id := p_batch_row.batch_id;
4522: SELECT *
4523: INTO l_batch_row
4524: FROM pm_btch_hdr_bak
4525: WHERE batch_id = l_batch_id;
4526:
4527: -- Detemine Transactional Doc Type
4528: -- 0 - PROD 10 - FPO

Line 4675: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,

4671: RAISE;
4672: END load_trans;
4673:
4674: PROCEDURE insert_inv_txns_gtmp (
4675: p_batch_id IN pm_btch_hdr_bak.batch_id%TYPE,
4676: p_doc_type IN ic_tran_pnd.doc_type%TYPE,
4677: x_return_status OUT NOCOPY VARCHAR2,
4678: p_trans_id IN ic_tran_pnd.trans_id%TYPE DEFAULT NULL
4679: ) IS

Line 4806: v_batch_id pm_btch_hdr_bak.batch_id%TYPE,

4802: l_whse_loct_ctl ic_whse_mst.whse_code%TYPE;
4803: l_def_lot_found BOOLEAN;
4804:
4805: CURSOR cur_get_def_trans (
4806: v_batch_id pm_btch_hdr_bak.batch_id%TYPE,
4807: v_line_id pm_matl_dtl_bak.line_id%TYPE,
4808: v_doc_type gme_inventory_txns_gtmp.doc_type%TYPE
4809: ) IS
4810: -- The following cursor does not look at lot_id and loct because these were already screened

Line 4836: FROM pm_btch_hdr_bak

4832:
4833: CURSOR cur_get_batch_info (v_batch_id IN NUMBER) IS
4834: SELECT batch_no,
4835: plant_code
4836: FROM pm_btch_hdr_bak
4837: WHERE batch_id = v_batch_id;
4838:
4839: get_batch_info cur_get_batch_info%ROWTYPE;
4840: get_trans_rec cur_get_def_trans%ROWTYPE;

Line 4842: l_batch_type pm_btch_hdr_bak.batch_type%TYPE;

4838:
4839: get_batch_info cur_get_batch_info%ROWTYPE;
4840: get_trans_rec cur_get_def_trans%ROWTYPE;
4841: l_tran_whse ps_whse_eff.whse_code%TYPE;
4842: l_batch_type pm_btch_hdr_bak.batch_type%TYPE;
4843: l_doc_type gme_inventory_txns_gtmp.doc_type%TYPE;
4844: l_pos NUMBER := 0;
4845: l_cnt NUMBER;
4846: BEGIN

Line 4863: FROM pm_btch_hdr_bak

4859: l_def_lot_found := FALSE;
4860: x_def_lot_id := 0;
4861: SELECT batch_type
4862: INTO l_batch_type
4863: FROM pm_btch_hdr_bak
4864: WHERE batch_id = l_matl_dtl.batch_id;
4865: l_pos := 4;
4866:
4867: IF (l_batch_type = 0) THEN