DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_EXTNS_AUD_PVT dependencies on FND_API

Line 16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

12:
13: /*FOR INSERT */
14: PROCEDURE INSERT_RESOURCE(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
19: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
20: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

13: /*FOR INSERT */
14: PROCEDURE INSERT_RESOURCE(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
19: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
20: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
21: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,

Line 53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

49:
50: /*INSERT for Resource Synchronization */
51: PROCEDURE INSERT_RESOURCE(
52: P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
56: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
57: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

50: /*INSERT for Resource Synchronization */
51: PROCEDURE INSERT_RESOURCE(
52: P_API_VERSION IN NUMBER,
53: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
54: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
56: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
57: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
58: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,

Line 128: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

124: /* FOR UPDATE*/
125:
126: PROCEDURE UPDATE_RESOURCE(
127: P_API_VERSION IN NUMBER,
128: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
131: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
132: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 129: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

125:
126: PROCEDURE UPDATE_RESOURCE(
127: P_API_VERSION IN NUMBER,
128: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
130: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
131: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
132: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
133: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,

Line 156: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

152: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
153: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
154: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
155: P_TRANSACTION_NUMBER IN NUMBER,
156: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
157: P_OBJECT_VERSION_NUMBER IN NUMBER,
158: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
159: X_MSG_COUNT OUT NOCOPY NUMBER,
160: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 174: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

170: /*UPDATE for Resource Synchronization*/
171:
172: PROCEDURE UPDATE_RESOURCE(
173: P_API_VERSION IN NUMBER,
174: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
176: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
177: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
178: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 175: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

171:
172: PROCEDURE UPDATE_RESOURCE(
173: P_API_VERSION IN NUMBER,
174: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
175: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
176: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
177: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
178: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
179: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,

Line 202: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

198: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
199: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
200: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
201: P_TRANSACTION_NUMBER IN NUMBER,
202: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
203: P_OBJECT_VERSION_NUMBER IN NUMBER,
204: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
205: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
206: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,

Line 249: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

245: --FOR DELETE
246:
247: PROCEDURE DELETE_RESOURCE(
248: P_API_VERSION IN NUMBER,
249: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: P_RESOURCE_ID IN NUMBER,
252: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
253: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 250: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

246:
247: PROCEDURE DELETE_RESOURCE(
248: P_API_VERSION IN NUMBER,
249: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
250: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: P_RESOURCE_ID IN NUMBER,
252: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
253: X_MSG_COUNT OUT NOCOPY NUMBER,
254: X_MSG_DATA OUT NOCOPY VARCHAR2 );