DBA Data[Home] [Help]

APPS.PA_CLIENT_EXT_FV_BUDGET_INT dependencies on DBMS_RANDOM

Line 111: ,ABS(MOD(dbms_random.random,999)) RECORD_NUMBER -- can be mappedto pbl.attribute2 also

107: SELECT
108: pia.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
109: ,'PROJECTS' SOURCE
110: ,grp_id GROUP_ID -- can be mapped to pbl.attribute1 also
111: ,ABS(MOD(dbms_random.random,999)) RECORD_NUMBER -- can be mappedto pbl.attribute2 also
112: ,null ERROR_CODE
113: ,null ERROR_REASON
114: ,pbl.attribute3 BUDGET_LEVEL_ID
115: ,pbl.attribute4 BUDGETING_SEGMENTS

Line 178: SELECT ABS(MOD(dbms_random.random,999)),1003399 -- Please put the value of user_id as per your need.

174: x_interface_status := null;
175: x_rejection_code := null;
176:
177: -- Generating Group_id value from Env.
178: SELECT ABS(MOD(dbms_random.random,999)),1003399 -- Please put the value of user_id as per your need.
179: into l_VER_GROUP_ID,l_user_id
180: FROM dual;
181:
182: -- Insert one record for each budget version baseline into