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.QA_SOLUTION_DISPOSITION_PKG dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 170: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval

166:
167: l_source_code VARCHAR2(30);
168:
169: CURSOR group_cur IS
170: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
171: FROM DUAL;
172:
173: -- Bug 3019869. Changed the below cursor to wip_job cursor.
174: -- Records will not reside in WJSI if the MRP Debug mode

Line 180: FROM WIP_ENTITIES we, WIP_JOB_SCHEDULE_INTERFACE wjsi

176:
177: /*
178: CURSOR job_cur IS
179: SELECT we.wip_entity_id
180: FROM WIP_ENTITIES we, WIP_JOB_SCHEDULE_INTERFACE wjsi
181: WHERE wjsi.process_status = 4
182: AND wjsi.group_id = l_group_id
183: AND we.wip_entity_id = wjsi.wip_entity_id;
184: */

Line 420: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(

416:
417:
418: -- Bug 2720431. Added p_job_mrp_net_quantity as NET_QUANTITY.
419:
420: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
421: PRIMARY_ITEM_ID,
422: SOURCE_CODE,
423: LOAD_TYPE,
424: PROCESS_PHASE,

Line 2885: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval

2881: l_status_type NUMBER;
2882:
2883:
2884: CURSOR group_cur IS
2885: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
2886: FROM DUAL;
2887:
2888: CURSOR job_cur IS
2889: SELECT wip_entity_id

Line 3364: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE

3360:
3361: END IF;
3362:
3363:
3364: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
3365: (
3366: SOURCE_CODE,
3367: LAST_UPDATE_DATE,
3368: LAST_UPDATED_BY,

Line 3399: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3395: 3,
3396: p_status_type,
3397: p_job_name,
3398: p_wip_entity_id,
3399: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3400: 2,
3401: 1,
3402: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3403: ) returning header_id into l_header_id;

Line 3402: WIP_JOB_SCHEDULE_INTERFACE_S.nextval

3398: p_wip_entity_id,
3399: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3400: 2,
3401: 1,
3402: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3403: ) returning header_id into l_header_id;
3404:
3405:
3406: INSERT INTO WIP_JOB_DTLS_INTERFACE

Line 3434: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3430: COUNT_POINT_TYPE
3431: )
3432: VALUES
3433: (
3434: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3435: p_group_id,
3436: p_wip_entity_id,
3437: p_organization_id,
3438: p_op_seq_num,

Line 3550: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE

3546: OPEN update_cur;
3547: FETCH update_cur INTO l_update_name;
3548: CLOSE update_cur;
3549:
3550: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
3551: (
3552: SOURCE_CODE,
3553: LAST_UPDATE_DATE,
3554: LAST_UPDATED_BY,

Line 3585: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3581: 3,
3582: p_status_type,
3583: p_job_name,
3584: p_wip_entity_id,
3585: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3586: 2,
3587: 1,
3588: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3589: ) returning header_id into l_header_id;

Line 3588: WIP_JOB_SCHEDULE_INTERFACE_S.nextval

3584: p_wip_entity_id,
3585: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3586: 2,
3587: 1,
3588: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3589: ) returning header_id into l_header_id;
3590:
3591:
3592: IF (p_op_type = 2) THEN

Line 3627: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3623: UOM_CODE
3624: )
3625: VALUES
3626: (
3627: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3628: p_group_id,
3629: p_organization_id,
3630: p_op_seq_num,
3631: 1, -- ( 1- Load Resource) LOAD_TYPE

Line 3692: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3688: UOM_CODE
3689: )
3690: VALUES
3691: (
3692: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3693: p_group_id,
3694: p_organization_id,
3695: p_op_seq_num,
3696: 1, -- ( 1- Load Resource) LOAD_TYPE