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.CSD_HV_WIP_JOB_PVT dependencies on WIP_JOB_DTLS_INTERFACE

Line 196: wip_job_dtls_interface wjdi

192: from
193: wip_interface_errors_v wie,
194: wip_job_schedule_interface wjsi,
195: wip_entities we,
196: wip_job_dtls_interface wjdi
197: where wie.interface_id = wjsi.interface_id
198: and we.wip_entity_id = wjsi.wip_entity_id
199: and wjsi.group_id = wjdi.group_id
200: and wjsi.group_id = p_group_id;

Line 524: -- wip_job_dtls_interface table.

520: END insert_job_header;
521:
522:
523: -- This procedure accepts job details information and inserts it into
524: -- wip_job_dtls_interface table.
525:
526: PROCEDURE insert_job_details
527: (
528: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,

Line 528: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,

524: -- wip_job_dtls_interface table.
525:
526: PROCEDURE insert_job_details
527: (
528: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,
529: x_return_status OUT NOCOPY VARCHAR2
530: )
531: IS
532:

Line 534: -- into wip_job_dtls_interface

530: )
531: IS
532:
533: -- Job Record to hold the Job Details information being inserted
534: -- into wip_job_dtls_interface
535:
536: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;
537:
538:

Line 536: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;

532:
533: -- Job Record to hold the Job Details information being inserted
534: -- into wip_job_dtls_interface
535:
536: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;
537:
538:
539: -- variables used for FND_LOG debug messages
540:

Line 596: INSERT INTO wip_job_dtls_interface

592:
593:
594: BEGIN
595:
596: INSERT INTO wip_job_dtls_interface
597: (last_updated_by,
598: last_update_date,
599: last_update_login,
600: created_by,

Line 724: -- into wip_job_dtls_interface

720: )
721: IS
722:
723: -- Job Record to hold the Job Details information being inserted
724: -- into wip_job_dtls_interface
725:
726: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;
727:
728:

Line 2530: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

2526:
2527: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2528: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2529: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2530: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2531:
2532:
2533:
2534: l_table NUMBER;

Line 3715: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

3711: -- and wip_cost_txn_interface data
3712:
3713: l_wip_cost_txn_interface_rec wip_cost_txn_interface%ROWTYPE;
3714: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
3715: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
3716:
3717:
3718: l_last_update_date DATE;
3719: l_last_updated_by NUMBER;

Line 4210: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

4206:
4207:
4208: -- Job Records to hold the Job header and details information
4209: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
4210: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
4211:
4212:
4213: l_creation_date DATE;
4214: l_last_update_date DATE;

Line 4678: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

4674:
4675: -- Job Records to hold the Job header and details information
4676:
4677: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
4678: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
4679:
4680:
4681: l_creation_date DATE;
4682: l_last_update_date DATE;

Line 5078: -- Constants Used for Inserting into wip_job_dtls_interface

5074: -- Constants Used for Inserting into wip_job_schedule_interface,
5075: -- These are the values needed for WIP Mass Load to pick up the records
5076: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- load type for update non standard discrete job
5077:
5078: -- Constants Used for Inserting into wip_job_dtls_interface
5079: lc_load_op_type CONSTANT NUMBER := 3; -- load type for operations
5080: lc_substitution_add_type CONSTANT NUMBER := 2; -- indicates add record (vs. change=3 or delete=1)
5081: lc_substitution_change_type CONSTANT NUMBER := 3; -- indicates change record (vs. add=2 or delete=1)
5082: lc_process_validation_phase CONSTANT NUMBER := 2; -- must be 2 for WIP to pick up record

Line 5087: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

5083: lc_process_pending_status CONSTANT NUMBER := 1; -- must be 1 for WIP to pick up record
5084:
5085: -- Job Records to hold the Job header and details information
5086: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
5087: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
5088:
5089: -- variables for WHO columns
5090: l_creation_date DATE;
5091: l_last_update_date DATE;

Line 5156: -- set job details (operations) info - required columns in wip_job_dtls_interface table

5152: l_job_header_rec.header_id := l_job_header_rec.group_id;
5153: l_job_header_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;
5154: l_job_header_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;
5155:
5156: -- set job details (operations) info - required columns in wip_job_dtls_interface table
5157: l_job_details_rec.group_id := l_job_header_rec.group_id;
5158: l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
5159: l_job_details_rec.operation_seq_num := p_op_dtls_tbl(op_ctr).operation_seq_num;
5160: l_job_details_rec.backflush_flag := p_op_dtls_tbl(op_ctr).backflush_flag;

Line 5170: -- set job details (operations) info - optional columns in wip_job_dtls_interface table

5166: l_job_details_rec.minimum_transfer_quantity := p_op_dtls_tbl(op_ctr).minimum_transfer_quantity;
5167: l_job_details_rec.process_phase := lc_process_validation_phase;
5168: l_job_details_rec.process_status := lc_process_pending_status;
5169:
5170: -- set job details (operations) info - optional columns in wip_job_dtls_interface table
5171: l_job_details_rec.description := p_op_dtls_tbl(op_ctr).description;
5172:
5173: -- set job details (operations) info - not set in columns in wip_job_dtls_interface table
5174: l_job_details_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;

Line 5173: -- set job details (operations) info - not set in columns in wip_job_dtls_interface table

5169:
5170: -- set job details (operations) info - optional columns in wip_job_dtls_interface table
5171: l_job_details_rec.description := p_op_dtls_tbl(op_ctr).description;
5172:
5173: -- set job details (operations) info - not set in columns in wip_job_dtls_interface table
5174: l_job_details_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;
5175: l_job_details_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;
5176:
5177: IF p_op_dtls_tbl(op_ctr).new_row = 'Y' THEN