APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_VL

Line 16: FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

12: -- and sql/jtfrsbgd.sql(concurrent program to populate groups denorm)
13: -- and not a public function. It gives direct parent ID(ACTUAL_PARENT_ID)
14: -- for a given groups_drnorm table record, originally requested for
15: -- DBI perf. enhancement # 2759986
16: FUNCTION getDirectParent(p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
17: p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,
18: p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,
19: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,
20: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER;

Line 91: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

87: PROCEDURE DELETE_GRP_RELATIONS(
88: P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
92: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
93: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 92: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

88: P_API_VERSION IN NUMBER,
89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
92: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
93: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,
96: X_MSG_DATA OUT NOCOPY VARCHAR2);

Line 93: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

89: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_group_relate_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
92: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
93: p_related_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
94: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95: X_MSG_COUNT OUT NOCOPY NUMBER,
96: X_MSG_DATA OUT NOCOPY VARCHAR2);
97:

Line 105: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

101: PROCEDURE DELETE_GROUPS(
102: P_API_VERSION IN NUMBER,
103: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
104: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: p_group_id IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
106: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107: X_MSG_COUNT OUT NOCOPY NUMBER,
108: X_MSG_DATA OUT NOCOPY VARCHAR2);
109: