eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on FND_API

Line 18: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

14: /*FOR INSERT IN JTF_RS_ROLE_RELATIONS */
15: --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED
16: PROCEDURE INSERT_REP_MANAGER(
17: P_API_VERSION IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 19: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

15: --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED
16: PROCEDURE INSERT_REP_MANAGER(
17: P_API_VERSION IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
20: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
21: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
22: X_MSG_COUNT OUT NOCOPY NUMBER,
23: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 30: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

26: --SHOULD BE CALLED from the api jtf_rs_groups_denorm.delete_resource_group_relate
27: -- not being used anymore
28: PROCEDURE INSERT_REP_MGR_PARENT(
29: P_API_VERSION IN NUMBER,
30: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 31: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

27: -- not being used anymore
28: PROCEDURE INSERT_REP_MGR_PARENT(
29: P_API_VERSION IN NUMBER,
30: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
32: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34: X_MSG_COUNT OUT NOCOPY NUMBER,
35: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 41: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

37:
38: --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED --only for migration
39: PROCEDURE INSERT_REP_MANAGER_MIGR(
40: P_API_VERSION IN NUMBER,
41: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 42: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

38: --SHOULD BE CALLED AFTER THE ROLE RELATE ROW HAS BEEN INSERTED --only for migration
39: PROCEDURE INSERT_REP_MANAGER_MIGR(
40: P_API_VERSION IN NUMBER,
41: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
42: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
43: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
44: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45: X_MSG_COUNT OUT NOCOPY NUMBER,
46: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

50: --FOR UPDATE on jtf_rs_ROLE_RELATE
51: --SHOULD BE CALLED AFTER THE TABLE HAS BEEN UPDATED
52: PROCEDURE UPDATE_REP_MANAGER(
53: P_API_VERSION IN NUMBER,
54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
57: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

51: --SHOULD BE CALLED AFTER THE TABLE HAS BEEN UPDATED
52: PROCEDURE UPDATE_REP_MANAGER(
53: P_API_VERSION IN NUMBER,
54: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
57: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
58: X_MSG_COUNT OUT NOCOPY NUMBER,
59: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 64: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

60:
61: -- FOR DELETE ON JTF_RS_ROLE_RELATE
62: PROCEDURE DELETE_MEMBERS(
63: P_API_VERSION IN NUMBER,
64: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
68: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 65: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

61: -- FOR DELETE ON JTF_RS_ROLE_RELATE
62: PROCEDURE DELETE_MEMBERS(
63: P_API_VERSION IN NUMBER,
64: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
65: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
66: P_ROLE_RELATE_ID IN JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,
67: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
68: X_MSG_COUNT OUT NOCOPY NUMBER,
69: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 76: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

72: --AFTER THE GROUP RELATION ROW HAS BEEN INSERTED
73: -- may not be used after 23-apr-2001
74: PROCEDURE INSERT_GRP_RELATIONS(
75: P_API_VERSION IN NUMBER,
76: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 77: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

73: -- may not be used after 23-apr-2001
74: PROCEDURE INSERT_GRP_RELATIONS(
75: P_API_VERSION IN NUMBER,
76: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
77: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
78: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
79: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80: X_MSG_COUNT OUT NOCOPY NUMBER,
81: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 86: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

82:
83: --when a insert is done in groups denorm
84: PROCEDURE INSERT_GRP_DENORM(
85: P_API_VERSION IN NUMBER,
86: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: P_GROUP_DENORM_ID IN NUMBER,
89: P_GROUP_ID IN NUMBER,
90: P_PARENT_GROUP_ID IN NUMBER,

Line 87: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

83: --when a insert is done in groups denorm
84: PROCEDURE INSERT_GRP_DENORM(
85: P_API_VERSION IN NUMBER,
86: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
87: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: P_GROUP_DENORM_ID IN NUMBER,
89: P_GROUP_ID IN NUMBER,
90: P_PARENT_GROUP_ID IN NUMBER,
91: P_START_DATE_ACTIVE IN DATE,

Line 104: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

100: -- SHOULD BE CALLED BEFORE THE DENORM RECORD IS ACTUALLY DELETED FROM THE TABLE
101: -- being used after 23 apr 2004
102: PROCEDURE DELETE_GROUP_DENORM(
103: P_API_VERSION IN NUMBER,
104: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 105: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

101: -- being used after 23 apr 2004
102: PROCEDURE DELETE_GROUP_DENORM(
103: P_API_VERSION IN NUMBER,
104: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
105: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
106: P_DENORM_GRP_ID IN JTF_RS_GROUPS_DENORM.DENORM_GRP_ID%TYPE,
107: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
108: X_MSG_COUNT OUT NOCOPY NUMBER,
109: X_MSG_DATA OUT NOCOPY VARCHAR2 );

Line 114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

110:
111: --to be called from jtf_rs_groups_denorm_pvt.update_groups
112: PROCEDURE DELETE_REP_MGR (
113: P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
117: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

111: --to be called from jtf_rs_groups_denorm_pvt.update_groups
112: PROCEDURE DELETE_REP_MGR (
113: P_API_VERSION IN NUMBER,
114: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
116: P_GROUP_ID IN JTF_RS_GROUPS_DENORM.GROUP_ID%TYPE,
117: P_PARENT_GROUP_ID IN JTF_RS_GROUPS_DENORM.PARENT_GROUP_ID%TYPE,
118: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
119: X_MSG_COUNT OUT NOCOPY NUMBER,