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 127: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 128: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

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

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

Line 166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

162: /*UPDATE for Resource Synchronization*/
163:
164: PROCEDURE UPDATE_RESOURCE(
165: P_API_VERSION IN NUMBER,
166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
169: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
170: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,

Line 167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

163:
164: PROCEDURE UPDATE_RESOURCE(
165: P_API_VERSION IN NUMBER,
166: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
169: P_RESOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE,
170: P_CATEGORY IN JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE,
171: P_SOURCE_ID IN JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE DEFAULT NULL,

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

190: P_HOLD_PAYMENT IN JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE DEFAULT 'N',
191: P_COMP_SERVICE_TEAM_ID IN JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE DEFAULT NULL,
192: --P_LOCATION IN MDSYS.SDO_GEOMETRY DEFAULT NULL,
193: P_TRANSACTION_NUMBER IN NUMBER,
194: P_USER_ID IN JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
195: P_OBJECT_VERSION_NUMBER IN NUMBER,
196: P_RESOURCE_NAME IN JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE DEFAULT NULL,
197: P_SOURCE_NAME IN JTF_RS_RESOURCE_EXTNS.SOURCE_NAME%TYPE,
198: P_SOURCE_NUMBER IN JTF_RS_RESOURCE_EXTNS.SOURCE_NUMBER%TYPE DEFAULT NULL,

Line 240: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

236: --FOR DELETE
237:
238: PROCEDURE DELETE_RESOURCE(
239: P_API_VERSION IN NUMBER,
240: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: P_RESOURCE_ID IN NUMBER,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 241: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

237:
238: PROCEDURE DELETE_RESOURCE(
239: P_API_VERSION IN NUMBER,
240: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
241: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
242: P_RESOURCE_ID IN NUMBER,
243: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244: X_MSG_COUNT OUT NOCOPY NUMBER,
245: X_MSG_DATA OUT NOCOPY VARCHAR2 );