APPS.MIGRATE_BATCH dependencies on PM_HIST_HDR

Line 516: FROM pm_hist_hdr

512: 0
513: ) -- for those customers (IMCO and maybe others) who have manually reopened
514: -- batches via sqlplus and then closed through the application.
515: INTO v_gl_posted_ind
516: FROM pm_hist_hdr
517: WHERE batch_id = p_batch_id AND
518: new_status = 4;
519: l_pos := 2;
520: RETURN v_gl_posted_ind;

Line 524: p_table_name => 'pm_hist_hdr',

520: RETURN v_gl_posted_ind;
521: EXCEPTION
522: WHEN OTHERS THEN
523: insert_message (
524: p_table_name => 'pm_hist_hdr',
525: p_procedure_name => 'get_gl_posted_ind',
526: p_parameters => p_batch_id,
527: p_message => SQLERRM || ' with pos = ' || l_pos,
528: p_error_type => 'D'

Line 2333: IF (is_table_migrated (p_table_name => 'PM_HIST_HDR') = FALSE) THEN

2329: COMMIT;
2330: END IF;
2331: END IF;
2332:
2333: IF (is_table_migrated (p_table_name => 'PM_HIST_HDR') = FALSE) THEN
2334: l_pos := 16;
2335: insert_batch_history (x_return_status => l_return_status);
2336: l_pos := 17;
2337:

Line 2343: p_table_name => 'PM_HIST_HDR',

2339: RAISE error_detail;
2340: END IF;
2341:
2342: set_table_migrated (
2343: p_table_name => 'PM_HIST_HDR',
2344: x_return_status => l_return_status
2345: );
2346:
2347: IF p_commit THEN

Line 3892: FROM pm_hist_hdr

3888: program_application_id,
3889: program_id,
3890: request_id,
3891: program_update_date
3892: FROM pm_hist_hdr
3893: WHERE orig_status < 100;
3894:
3895: insert_message (
3896: p_table_name => 'gme_batch_history',

Line 3903: UPDATE pm_hist_hdr

3899: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3900: p_error_type => 'P'
3901: );
3902:
3903: UPDATE pm_hist_hdr
3904: SET orig_status = orig_status + 100
3905: WHERE orig_status < 100;
3906: EXCEPTION
3907: WHEN OTHERS THEN