APPS.JTS_RESPONSIBILITY_PUB dependencies on FND_RESPONSIBILITY

Line 40: SELECT 'Y' FROM FND_RESPONSIBILITY

36: l_rowid VARCHAR2(50);
37: l_resp_id NUMBER;
38:
39: CURSOR c_dup_key IS
40: SELECT 'Y' FROM FND_RESPONSIBILITY
41: WHERE application_id = p_appl_id
42: AND responsibility_key = p_resp_key;
43: l_found_dup VARCHAR2(1) := 'N';
44:

Line 121: SELECT fnd_responsibility_s.nextval

117: raise FND_API.G_EXC_ERROR;
118: End if;
119:
120:
121: SELECT fnd_responsibility_s.nextval
122: INTO l_resp_id
123: FROM dual;
124: x_resp_id := l_resp_id;
125:

Line 126: FND_RESPONSIBILITY_PKG.INSERT_ROW(

122: INTO l_resp_id
123: FROM dual;
124: x_resp_id := l_resp_id;
125:
126: FND_RESPONSIBILITY_PKG.INSERT_ROW(
127: X_ROWID => l_rowid,
128: X_RESPONSIBILITY_ID => l_resp_id,
129: X_APPLICATION_ID => p_appl_id,
130: X_WEB_HOST_NAME => NULL,

Line 204: FROM FND_RESPONSIBILITY

200: l_api_version_number CONSTANT NUMBER := 1.0;
201:
202: CURSOR C_RESP IS
203: SELECT *
204: FROM FND_RESPONSIBILITY
205: WHERE responsibility_id = p_resp_id
206: AND application_id = p_appl_id
207: For Update NOWAIT;
208:

Line 289: FND_RESPONSIBILITY_PKG.UPDATE_ROW(

285: raise FND_API.G_EXC_ERROR;
286: End if;
287:
288:
289: FND_RESPONSIBILITY_PKG.UPDATE_ROW(
290: X_RESPONSIBILITY_ID => p_resp_id,
291: X_APPLICATION_ID => p_appl_id,
292: X_WEB_HOST_NAME => l_resp.WEB_HOST_NAME,
293: X_WEB_AGENT_NAME => l_resp.WEB_AGENT_NAME,