APPS.CSP_REPAIR_PO_PVT dependencies on DUAL

Line 230: SELECT Sysdate INTO l_today FROM dual;

226: /** Initialize return status **/
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: /** User and login information **/
230: SELECT Sysdate INTO l_today FROM dual;
231: l_user_id := fnd_global.user_id;
232: l_login_id := fnd_global.login_id;
233:
234: ---- Start Step:1 ----

Line 371: FROM dual;

367: /*
368: SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL,
369: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
370: INTO l_org_id
371: FROM dual;
372:
373: po_moac_utils_pvt.set_org_context(l_org_id);
374:
375: */

Line 596: from dual;

592: /** Create a WIB_JOB if there is no WIB_JOB created for this INTERNAL_ORDER so far **/
593:
594: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
595: into l_WIP_BATCH_ID
596: from dual;
597:
598: SELECT WIP_ENTITIES_S.NEXTVAL
599: INTO l_WIP_ENTITY_ID
600: FROM DUAL;

Line 600: FROM DUAL;

596: from dual;
597:
598: SELECT WIP_ENTITIES_S.NEXTVAL
599: INTO l_WIP_ENTITY_ID
600: FROM DUAL;
601:
602: Begin
603: SELECT CLASS_CODE
604: INTO L_CLASS_CODE

Line 1041: from dual;

1037: /*
1038:
1039: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1040: into l_WIP_BATCH_ID
1041: from dual;
1042:
1043: Begin
1044: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE(
1045: LAST_UPDATE_DATE,

Line 1403: SELECT Sysdate INTO l_today FROM dual;

1399: /** Initialize return status **/
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: /** User and login information **/
1403: SELECT Sysdate INTO l_today FROM dual;
1404: l_user_id := fnd_global.user_id;
1405: l_login_id := fnd_global.login_id;
1406:
1407: L_REPAIR_PO_HEADER_ID := P_REPAIR_PO_HEADER_ID;

Line 1579: from dual;

1575: ---------------End comment on NOV-29-2005 --------
1576: /*
1577: select WIP_JOB_SCHEDULE_INTERFACE_S.nextval
1578: into l_WIP_BATCH_ID
1579: from dual;
1580:
1581: Begin
1582: INSERT INTO WIP_JOB_SCHEDULE_INTERFACE
1583: (