APPS.CSP_REPAIR_PO_PVT dependencies on DUAL

Line 269: SELECT Sysdate INTO l_today FROM dual;

265: /** Initialize return status **/
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: /** User and login information **/
269: SELECT Sysdate INTO l_today FROM dual;
270: l_user_id := fnd_global.user_id;
271: l_login_id := fnd_global.login_id;
272:
273: ---- Start Step:1 ----

Line 410: FROM dual;

406: /*
407: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
408: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
409: INTO l_org_id
410: FROM dual;
411:
412: po_moac_utils_pvt.set_org_context(l_org_id);
413:
414: */

Line 737: from dual;

733: /** Create a WIB_JOB if there is no WIB_JOB created for this INTERNAL_ORDER so far **/
734:
735: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
736: into l_WIP_BATCH_ID
737: from dual;
738:
739: SELECT WIP_ENTITIES_S.NEXTVAL
740: INTO l_WIP_ENTITY_ID
741: FROM DUAL;

Line 741: FROM DUAL;

737: from dual;
738:
739: SELECT WIP_ENTITIES_S.NEXTVAL
740: INTO l_WIP_ENTITY_ID
741: FROM DUAL;
742:
743: Begin
744: SELECT CLASS_CODE
745: INTO L_CLASS_CODE

Line 1298: from dual;

1294: /*
1295:
1296: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1297: into l_WIP_BATCH_ID
1298: from dual;
1299:
1300: Begin
1301: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1302: LAST_UPDATE_DATE,

Line 1701: SELECT Sysdate INTO l_today FROM dual;

1697: /** Initialize return status **/
1698: x_return_status := FND_API.G_RET_STS_SUCCESS;
1699:
1700: /** User and login information **/
1701: SELECT Sysdate INTO l_today FROM dual;
1702: l_user_id := fnd_global.user_id;
1703: l_login_id := fnd_global.login_id;
1704:
1705: L_REPAIR_PO_HEADER_ID := P_REPAIR_PO_HEADER_ID;

Line 1884: from dual;

1880: ---------------End comment on NOV-29-2005 --------
1881: /*
1882: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1883: into l_WIP_BATCH_ID
1884: from dual;
1885:
1886: Begin
1887: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
1888: (