3: --
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_COMP_GRP_HIER_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpcghrb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11: --
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpcghrb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11: --
12: PROCEDURE get_comp_group_hier(
13: p_api_version IN NUMBER,
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11: --
12: PROCEDURE get_comp_group_hier(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,