DBA Data[Home] [Help]

APPS.WSH_CC_PARAMETER_SETUPS_PKG dependencies on DUAL

Line 95: SELECT WSH_CC_PARAMETER_SETUPS_S.NEXTVAL into l_parameter_id FROM dual;

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

Line 853: SELECT Sysdate INTO l_sysdate FROM dual;

849: IF (x_owner = 'SEED') THEN
850: l_user_id := 1;
851: END IF;
852: --
853: SELECT Sysdate INTO l_sysdate FROM dual;
854: l_parameter_id := fnd_number.canonical_to_number(x_parameter_id);
855:
856:
857: update WSH_CC_PARAMETER_SETUPS_B set