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_GROUP_RELATE_PUB dependencies on JTF_RS_GRP_RELATIONS

Line 54: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

50: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
53: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
54: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
55: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

52: P_GROUP_ID IN JTF_RS_GROUPS_B.GROUP_ID%TYPE,
53: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
54: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
55: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

53: P_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
54: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
55: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,

54: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
55: P_RELATED_GROUP_NUMBER IN JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE,
56: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
57: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

Line 62: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE

58: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_RELATE_ID OUT NOCOPY JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE
63: );
64:
65:
66: /* Procedure to update the resource group relation

Line 77: * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.

73: * @param p_commit Commit
74: * @param p_group_relate_id Group Relation Identifier
75: * @param p_start_date_active Date on which the group relation becomes active.
76: * @param p_end_date_active Date on which the group relation is no longer active.
77: * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.
78: * @param x_return_status Output parameter for return status
79: * @param x_msg_count Output parameter for number of user messages from this procedure
80: * @param x_msg_data Output parameter containing last user message from this procedure
81: * @rep:scope internal

Line 89: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

85: PROCEDURE update_resource_group_relate
86: (P_API_VERSION IN NUMBER,
87: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
90: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
91: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
92: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 90: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

86: (P_API_VERSION IN NUMBER,
87: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
90: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
91: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
92: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 91: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

87: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
90: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
91: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
92: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,
95: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 92: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

88: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
90: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
91: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
92: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
93: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
94: X_MSG_COUNT OUT NOCOPY NUMBER,
95: X_MSG_DATA OUT NOCOPY VARCHAR2
96: );

Line 108: * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.

104: * @param p_api_version API version
105: * @param p_init_msg_list Initialization of the message list
106: * @param p_commit Commit
107: * @param p_group_relate_id Group Relation Identifier
108: * @param p_object_version_num The object version number of the group relation derives from the jtf_rs_grp_relations table.
109: * @param x_return_status Output parameter for return status
110: * @param x_msg_count Output parameter for number of user messages from this procedure
111: * @param x_msg_data Output parameter containing last user message from this procedure
112: * @rep:scope internal

Line 120: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,

116: PROCEDURE delete_resource_group_relate
117: (P_API_VERSION IN NUMBER,
118: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
119: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
120: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID%TYPE,
121: P_OBJECT_VERSION_NUM IN JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
122: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
123: X_MSG_COUNT OUT NOCOPY NUMBER,
124: X_MSG_DATA OUT NOCOPY VARCHAR2