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.JTY_ASSIGN_BULK_PUB dependencies on JTY_TRANS_USG_PGM_SQL

Line 130: FROM jty_trans_usg_pgm_sql tus

126:
127: BEGIN
128: SELECT incr_reassign_sql
129: INTO l_seeded_sql
130: FROM jty_trans_usg_pgm_sql tus
131: WHERE tus.source_id = p_source_id
132: AND tus.trans_type_id = p_trans_id
133: AND tus.program_name = p_program_name
134: AND tus.enabled_flag = 'Y';

Line 137: x_msg_data := 'No active row in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

133: AND tus.program_name = p_program_name
134: AND tus.enabled_flag = 'Y';
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN
137: x_msg_data := 'No active row in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
138: ' program name : ' || p_program_name;
139: RAISE;
140: END;
141:

Line 149: x_msg_data := 'No active transaction sql in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' ||

145: RAISE L_SEED_DATA_NOTFOUND;
146: END IF;
147:
148: IF (l_seeded_sql IS NULL) THEN
149: x_msg_data := 'No active transaction sql in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' ||
150: p_trans_id || ' program name : ' || p_program_name;
151: RAISE L_SEED_DATA_NOTFOUND;
152: END IF;
153:

Line 370: FROM jty_trans_usg_pgm_sql tus

366: SELECT decode(p_mode, 'TOTAL', tus.batch_total_sql
367: , 'INCREMENTAL', tus.batch_incr_sql
368: , 'DATE EFFECTIVE', decode(tus.use_total_for_dea_flag, 'Y', tus.batch_total_sql, tus.batch_dea_sql))
369: INTO l_seeded_sql
370: FROM jty_trans_usg_pgm_sql tus
371: WHERE tus.source_id = p_source_id
372: AND tus.trans_type_id = p_trans_id
373: AND tus.program_name = p_program_name
374: AND tus.enabled_flag = 'Y';

Line 377: x_msg_data := 'No active row in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||

373: AND tus.program_name = p_program_name
374: AND tus.enabled_flag = 'Y';
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: x_msg_data := 'No active row in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
378: ' program name : ' || p_program_name;
379: RAISE;
380: END;
381:

Line 389: x_msg_data := 'No active transaction sql in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' ||

385: RAISE L_SEED_DATA_NOTFOUND;
386: END IF;
387:
388: IF (l_seeded_sql IS NULL) THEN
389: x_msg_data := 'No active transaction sql in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' ||
390: p_trans_id || ' program name : ' || p_program_name;
391: RAISE L_SEED_DATA_NOTFOUND;
392: END IF;
393: