DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_HEADER

Line 30: ic_tran_pnd p, gme_batch_header hdr -- Bug 13706812 Add header table.

26: /* Bug 5620671 Added param completed ind */
27: CURSOR Cur_get_txns(v_completed_ind NUMBER) IS
28: SELECT p.*, m.new_batch_id, m.organization_id, m.new_batch_no, m.plant_code
29: FROM gme_batch_txns_mig t, gme_batch_mapping_mig m,
30: ic_tran_pnd p, gme_batch_header hdr -- Bug 13706812 Add header table.
31: WHERE t.batch_id = m.old_batch_id
32: AND p.trans_id = t.trans_id
33: AND NVL(t.migrated_ind,0) = 0
34: AND p.completed_ind = v_completed_ind

Line 41: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

37: ORDER BY m.organization_id, t.batch_id, p.line_id, p.trans_id;
38:
39: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,
40: ret_code OUT NOCOPY VARCHAR2);
41: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
42: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE);
43: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,
44: x_mtl_dtl OUT NOCOPY gme_common_pvt.material_details_tab);
45: PROCEDURE build_steps(p_steps_mig IN gme_post_migration.steps_mig_tab,

Line 42: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE);

38:
39: PROCEDURE recreate_open_batches(err_buf OUT NOCOPY VARCHAR2,
40: ret_code OUT NOCOPY VARCHAR2);
41: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
42: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE);
43: PROCEDURE build_mtl_dtl(p_mtl_dtl_mig IN gme_post_migration.mtl_dtl_mig_tab,
44: x_mtl_dtl OUT NOCOPY gme_common_pvt.material_details_tab);
45: PROCEDURE build_steps(p_steps_mig IN gme_post_migration.steps_mig_tab,
46: x_steps OUT NOCOPY gme_common_pvt.steps_tab);

Line 67: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

63: PROCEDURE create_batch_step_charges(p_old_batch_id IN NUMBER,
64: p_new_batch_id IN NUMBER);
65: PROCEDURE create_batch_step_transfers(p_old_batch_id IN NUMBER,
66: p_new_batch_id IN NUMBER);
67: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
68: p_batch_header IN gme_batch_header%ROWTYPE);
69: PROCEDURE create_phantom_links;
70: PROCEDURE release_batches;
71: PROCEDURE check_date(p_organization_id IN NUMBER,

Line 68: p_batch_header IN gme_batch_header%ROWTYPE);

64: p_new_batch_id IN NUMBER);
65: PROCEDURE create_batch_step_transfers(p_old_batch_id IN NUMBER,
66: p_new_batch_id IN NUMBER);
67: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
68: p_batch_header IN gme_batch_header%ROWTYPE);
69: PROCEDURE create_phantom_links;
70: PROCEDURE release_batches;
71: PROCEDURE check_date(p_organization_id IN NUMBER,
72: p_date IN DATE,