DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_DENORM_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 17: p_level JTF_RS_GROUPS_DENORM.DENORM_LEVEL%type,

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;
21:

Line 18: p_parent_group_id JTF_RS_GROUPS_DENORM.parent_group_id%type,

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;
21:
22: --to be called when a group is created

Line 19: p_start_date JTF_RS_GROUPS_DENORM.start_date_active%TYPE,

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;
21:
22: --to be called when a group is created
23: PROCEDURE CREATE_RES_GROUPS(

Line 20: p_end_date JTF_RS_GROUPS_DENORM.end_date_active%TYPE) RETURN NUMBER;

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;
21:
22: --to be called when a group is created
23: PROCEDURE CREATE_RES_GROUPS(
24: P_API_VERSION IN NUMBER,