DBA Data[Home] [Help]

APPS.WSH_ITM_PARAMETER_SETUPS_PKG dependencies on DUAL

Line 94: SELECT WSH_ITM_PARAMETER_SETUPS_S.NEXTVAL into l_parameter_id FROM dual;

90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: --dbms_output.put_line('begin api-2');
93:
94: SELECT WSH_ITM_PARAMETER_SETUPS_S.NEXTVAL into l_parameter_id FROM dual;
95:
96: insert into WSH_ITM_PARAMETER_SETUPS_B (
97: PARAMETER_ID,
98: PARAMETER_NAME,

Line 859: SELECT Sysdate INTO l_sysdate FROM dual;

855: IF (x_owner = 'SEED') THEN
856: l_user_id := 1;
857: END IF;
858: --
859: SELECT Sysdate INTO l_sysdate FROM dual;
860: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
861:
862:
863: update WSH_ITM_PARAMETER_SETUPS_B set