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 228: wip_job_dtls_interface wjdi

224: from
225: wip_interface_errors_v wie,
226: wip_job_schedule_interface wjsi,
227: wip_entities we,
228: wip_job_dtls_interface wjdi
229: where wie.interface_id = wjsi.interface_id
230: and we.wip_entity_id = wjsi.wip_entity_id
231: and wjsi.group_id = wjdi.group_id
232: and wjsi.group_id = p_group_id;

Line 562: -- wip_job_dtls_interface table.

558: END insert_job_header;
559:
560:
561: -- This procedure accepts job details information and inserts it into
562: -- wip_job_dtls_interface table.
563:
564: PROCEDURE insert_job_details
565: (
566: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,

Line 566: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,

562: -- wip_job_dtls_interface table.
563:
564: PROCEDURE insert_job_details
565: (
566: p_job_details_rec IN wip_job_dtls_interface%ROWTYPE,
567: x_return_status OUT NOCOPY VARCHAR2
568: )
569: IS
570:

Line 572: -- into wip_job_dtls_interface

568: )
569: IS
570:
571: -- Job Record to hold the Job Details information being inserted
572: -- into wip_job_dtls_interface
573:
574: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;
575:
576:

Line 574: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;

570:
571: -- Job Record to hold the Job Details information being inserted
572: -- into wip_job_dtls_interface
573:
574: l_job_details_rec wip_job_dtls_interface%ROWTYPE := p_job_details_rec;
575:
576:
577: -- variables used for FND_LOG debug messages
578:

Line 634: INSERT INTO wip_job_dtls_interface

630:
631:
632: BEGIN
633:
634: INSERT INTO wip_job_dtls_interface
635: (last_updated_by,
636: last_update_date,
637: last_update_login,
638: created_by,

Line 764: -- into wip_job_dtls_interface

760: )
761: IS
762:
763: -- Job Record to hold the Job Details information being inserted
764: -- into wip_job_dtls_interface
765:
766: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE := p_transactions_interface_rec;
767:
768:

Line 2868: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

2864:
2865: l_transactions_interface_rec mtl_transactions_interface%ROWTYPE;
2866: l_srl_nmbrs_interface_rec mtl_serial_numbers_interface%ROWTYPE;
2867: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
2868: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
2869:
2870:
2871:
2872: l_table NUMBER;

Line 4152: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

4148: -- and wip_cost_txn_interface data
4149:
4150: l_wip_cost_txn_interface_rec wip_cost_txn_interface%ROWTYPE;
4151: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
4152: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
4153:
4154:
4155: l_last_update_date DATE;
4156: l_last_updated_by NUMBER;

Line 4671: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

4667:
4668:
4669: -- Job Records to hold the Job header and details information
4670: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
4671: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
4672:
4673:
4674: l_creation_date DATE;
4675: l_last_update_date DATE;

Line 5474: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

5470:
5471: -- Job Records to hold the Job header and details information
5472:
5473: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
5474: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
5475:
5476:
5477: l_creation_date DATE;
5478: l_last_update_date DATE;

Line 5917: -- Constants Used for Inserting into wip_job_dtls_interface

5913: -- Constants Used for Inserting into wip_job_schedule_interface,
5914: -- These are the values needed for WIP Mass Load to pick up the records
5915: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- load type for update non standard discrete job
5916:
5917: -- Constants Used for Inserting into wip_job_dtls_interface
5918: lc_load_op_type CONSTANT NUMBER := 3; -- load type for operations
5919: lc_substitution_add_type CONSTANT NUMBER := 2; -- indicates add record (vs. change=3 or delete=1)
5920: lc_substitution_change_type CONSTANT NUMBER := 3; -- indicates change record (vs. add=2 or delete=1)
5921: lc_process_validation_phase CONSTANT NUMBER := 2; -- must be 2 for WIP to pick up record

Line 5926: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

5922: lc_process_pending_status CONSTANT NUMBER := 1; -- must be 1 for WIP to pick up record
5923:
5924: -- Job Records to hold the Job header and details information
5925: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
5926: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
5927:
5928: -- variables for WHO columns
5929: l_creation_date DATE;
5930: l_last_update_date DATE;

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

5991: l_job_header_rec.header_id := l_job_header_rec.group_id;
5992: l_job_header_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;
5993: l_job_header_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;
5994:
5995: -- set job details (operations) info - required columns in wip_job_dtls_interface table
5996: l_job_details_rec.group_id := l_job_header_rec.group_id;
5997: l_job_details_rec.parent_header_id := l_job_header_rec.group_id;
5998: l_job_details_rec.operation_seq_num := p_op_dtls_tbl(op_ctr).operation_seq_num;
5999: l_job_details_rec.backflush_flag := p_op_dtls_tbl(op_ctr).backflush_flag;

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

6005: l_job_details_rec.minimum_transfer_quantity := p_op_dtls_tbl(op_ctr).minimum_transfer_quantity;
6006: l_job_details_rec.process_phase := lc_process_validation_phase;
6007: l_job_details_rec.process_status := lc_process_pending_status;
6008:
6009: -- set job details (operations) info - optional columns in wip_job_dtls_interface table
6010: l_job_details_rec.description := p_op_dtls_tbl(op_ctr).description;
6011:
6012: -- set job details (operations) info - not set in columns in wip_job_dtls_interface table
6013: l_job_details_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;

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

6008:
6009: -- set job details (operations) info - optional columns in wip_job_dtls_interface table
6010: l_job_details_rec.description := p_op_dtls_tbl(op_ctr).description;
6011:
6012: -- set job details (operations) info - not set in columns in wip_job_dtls_interface table
6013: l_job_details_rec.organization_id := p_op_dtls_tbl(op_ctr).organization_id;
6014: l_job_details_rec.wip_entity_id := p_op_dtls_tbl(op_ctr).wip_entity_id;
6015:
6016: IF p_op_dtls_tbl(op_ctr).new_row = 'Y' THEN

Line 9172: -- Constants for WIP_JOB_DTLS_INTERFACE table

9168:
9169: -- Constants for WIP_JOB_SCHEDULE_INTERFACE table
9170: lc_non_std_update_load_type CONSTANT NUMBER := 3; -- update non-standard job
9171:
9172: -- Constants for WIP_JOB_DTLS_INTERFACE table
9173: lc_load_mtl_type CONSTANT NUMBER := 2; -- material
9174: lc_substitution_del_type CONSTANT NUMBER := 1; -- delete
9175:
9176:

Line 9179: l_job_details_rec wip_job_dtls_interface%ROWTYPE;

9175:
9176:
9177: -- Job Records to hold the Job header and details information
9178: l_job_header_rec wip_job_schedule_interface%ROWTYPE;
9179: l_job_details_rec wip_job_dtls_interface%ROWTYPE;
9180:
9181: -- wip
9182: l_wip_transaction_detail_id NUMBER := NULL;
9183: