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 2901: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval

2897: l_status_type NUMBER;
2898:
2899:
2900: CURSOR group_cur IS
2901: SELECT WIP_JOB_SCHEDULE_INTERFACE_S.nextval
2902: FROM DUAL;
2903:
2904: CURSOR job_cur IS
2905: SELECT wip_entity_id

Line 3380: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE

3376:
3377: END IF;
3378:
3379:
3380: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
3381: (
3382: SOURCE_CODE,
3383: LAST_UPDATE_DATE,
3384: LAST_UPDATED_BY,

Line 3415: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3411: 3,
3412: p_status_type,
3413: p_job_name,
3414: p_wip_entity_id,
3415: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3416: 2,
3417: 1,
3418: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3419: ) returning header_id into l_header_id;

Line 3418: WIP_JOB_SCHEDULE_INTERFACE_S.nextval

3414: p_wip_entity_id,
3415: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3416: 2,
3417: 1,
3418: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3419: ) returning header_id into l_header_id;
3420:
3421:
3422: INSERT INTO WIP_JOB_DTLS_INTERFACE

Line 3450: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3446: COUNT_POINT_TYPE
3447: )
3448: VALUES
3449: (
3450: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3451: p_group_id,
3452: p_wip_entity_id,
3453: p_organization_id,
3454: p_op_seq_num,

Line 3566: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE

3562: OPEN update_cur;
3563: FETCH update_cur INTO l_update_name;
3564: CLOSE update_cur;
3565:
3566: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
3567: (
3568: SOURCE_CODE,
3569: LAST_UPDATE_DATE,
3570: LAST_UPDATED_BY,

Line 3601: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3597: 3,
3598: p_status_type,
3599: p_job_name,
3600: p_wip_entity_id,
3601: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3602: 2,
3603: 1,
3604: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3605: ) returning header_id into l_header_id;

Line 3604: WIP_JOB_SCHEDULE_INTERFACE_S.nextval

3600: p_wip_entity_id,
3601: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3602: 2,
3603: 1,
3604: WIP_JOB_SCHEDULE_INTERFACE_S.nextval
3605: ) returning header_id into l_header_id;
3606:
3607:
3608: IF (p_op_type = 2) THEN

Line 3643: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3639: UOM_CODE
3640: )
3641: VALUES
3642: (
3643: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3644: p_group_id,
3645: p_organization_id,
3646: p_op_seq_num,
3647: 1, -- ( 1- Load Resource) LOAD_TYPE

Line 3708: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,

3704: UOM_CODE
3705: )
3706: VALUES
3707: (
3708: WIP_JOB_SCHEDULE_INTERFACE_S.nextval,
3709: p_group_id,
3710: p_organization_id,
3711: p_op_seq_num,
3712: 1, -- ( 1- Load Resource) LOAD_TYPE