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_REPORT_PUB dependencies on JTF_RS_GROUPS_B

Line 120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,

116: and with is_displayed flag on.
117: * For each segment, identifies the ATTRIBUTEn field storing value for that segment and prints it.
118: */
119: PROCEDURE get_DFF_output
120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,
121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,

Line 121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,

117: * For each segment, identifies the ATTRIBUTEn field storing value for that segment and prints it.
118: */
119: PROCEDURE get_DFF_output
120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,
121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,

Line 122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,

118: */
119: PROCEDURE get_DFF_output
120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,
121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,

Line 123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,

119: PROCEDURE get_DFF_output
120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,
121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,

Line 124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,

120: ( p_attribute_category jtf_rs_groups_b.ATTRIBUTE_CATEGORY%TYPE,
121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,

Line 125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,

121: p_attribute1 jtf_rs_groups_b.ATTRIBUTE1%TYPE,
122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,

Line 126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,

122: p_attribute2 jtf_rs_groups_b.ATTRIBUTE2%TYPE,
123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,

Line 127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,

123: p_attribute3 jtf_rs_groups_b.ATTRIBUTE3%TYPE,
124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,

Line 128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,

124: p_attribute4 jtf_rs_groups_b.ATTRIBUTE4%TYPE,
125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,

Line 129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,

125: p_attribute5 jtf_rs_groups_b.ATTRIBUTE5%TYPE,
126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,

Line 130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,

126: p_attribute6 jtf_rs_groups_b.ATTRIBUTE6%TYPE,
127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,

Line 131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,

127: p_attribute7 jtf_rs_groups_b.ATTRIBUTE7%TYPE,
128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,
135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,

Line 132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,

128: p_attribute8 jtf_rs_groups_b.ATTRIBUTE8%TYPE,
129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,
135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,
136: p_indent NUMBER

Line 133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,

129: p_attribute9 jtf_rs_groups_b.ATTRIBUTE9%TYPE,
130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,
135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,
136: p_indent NUMBER
137: )

Line 134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,

130: p_attribute10 jtf_rs_groups_b.ATTRIBUTE10%TYPE,
131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,
135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,
136: p_indent NUMBER
137: )
138: IS

Line 135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,

131: p_attribute11 jtf_rs_groups_b.ATTRIBUTE11%TYPE,
132: p_attribute12 jtf_rs_groups_b.ATTRIBUTE12%TYPE,
133: p_attribute13 jtf_rs_groups_b.ATTRIBUTE13%TYPE,
134: p_attribute14 jtf_rs_groups_b.ATTRIBUTE14%TYPE,
135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,
136: p_indent NUMBER
137: )
138: IS
139: l_DFF_value jtf_rs_groups_b.ATTRIBUTE1%TYPE;

Line 139: l_DFF_value jtf_rs_groups_b.ATTRIBUTE1%TYPE;

135: p_attribute15 jtf_rs_groups_b.ATTRIBUTE15%TYPE,
136: p_indent NUMBER
137: )
138: IS
139: l_DFF_value jtf_rs_groups_b.ATTRIBUTE1%TYPE;
140: BEGIN
141: FOR i IN 1 .. all_segment_details_tab.count /* Loop over all the segments in the DFF defn. */
142: LOOP
143: IF (all_segment_details_tab(i).is_displayed AND (all_segment_details_tab(i).is_global OR all_segment_details_tab(i).context_code = p_attribute_category))

Line 1204: FROM jtf_rs_groups_b grp

1200: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1201: IS
1202: SELECT grp.start_date_active,
1203: grp.end_date_active
1204: FROM jtf_rs_groups_b grp
1205: WHERE grp.group_id = x_group_id;
1206:
1207: cursor c_check_usage(l_group_id number,
1208: l_usage varchar2)