APPS.JTS_RESPONSIBILITY_PUB dependencies on FND_RESP_FUNCTIONS

Line 360: SELECT 'Y' FROM FND_RESP_FUNCTIONS

356: l_api_version_number CONSTANT NUMBER := 1.0;
357: --l_rowid VARCHAR2(50);
358:
359: CURSOR c_dup_key IS
360: SELECT 'Y' FROM FND_RESP_FUNCTIONS
361: WHERE application_id = p_app_id
362: AND responsibility_id = p_resp_id
363: AND action_id = p_action_id
364: AND rule_type = p_rule_type;

Line 434: FND_RESP_FUNCTIONS_PKG.INSERT_ROW(

430: FND_MSG_PUB.Add;
431: raise FND_API.G_EXC_ERROR;
432: END IF;
433:
434: FND_RESP_FUNCTIONS_PKG.INSERT_ROW(
435: X_ROWID => x_rowid,
436: X_APPLICATION_ID => p_app_id,
437: X_RESPONSIBILITY_ID => p_resp_id,
438: X_ACTION_ID => p_action_id,

Line 495: SELECT 'Y' FROM FND_RESP_FUNCTIONS

491: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Resp_Functions';
492: l_api_version_number CONSTANT NUMBER := 1.0;
493:
494: CURSOR c_found IS
495: SELECT 'Y' FROM FND_RESP_FUNCTIONS
496: WHERE application_id = p_app_id
497: AND responsibility_id = p_resp_id
498: AND action_id = p_action_id
499: AND rule_type = p_rule_type;

Line 569: FND_RESP_FUNCTIONS_PKG.DELETE_ROW(

565: FND_MSG_PUB.Add;
566: raise FND_API.G_EXC_ERROR;
567: END IF;
568:
569: FND_RESP_FUNCTIONS_PKG.DELETE_ROW(
570: X_APPLICATION_ID => p_app_id,
571: X_RESPONSIBILITY_ID => p_resp_id,
572: X_RULE_TYPE => p_rule_type,
573: X_ACTION_ID => p_action_id);