APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_TRANS_USG_PGM_SQL

Line 120: FROM jty_trans_usg_pgm_sql tus

116:
117: BEGIN
118: SELECT incr_reassign_sql
119: INTO l_seeded_sql
120: FROM jty_trans_usg_pgm_sql tus
121: WHERE tus.source_id = p_source_id
122: AND tus.trans_type_id = p_trans_id
123: AND tus.program_name = p_program_name
124: AND tus.enabled_flag = 'Y';

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

123: AND tus.program_name = p_program_name
124: AND tus.enabled_flag = 'Y';
125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127: x_msg_data := 'No active row in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' || p_trans_id ||
128: ' program name : ' || p_program_name;
129: RAISE;
130: END;
131:

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

135: RAISE L_SEED_DATA_NOTFOUND;
136: END IF;
137:
138: IF (l_seeded_sql IS NULL) THEN
139: x_msg_data := 'No active transaction sql in jty_trans_usg_pgm_sql corresponding to usage : ' || p_source_id || ' transaction : ' ||
140: p_trans_id || ' program name : ' || p_program_name;
141: RAISE L_SEED_DATA_NOTFOUND;
142: END IF;
143:

Line 369: FROM jty_trans_usg_pgm_sql tus

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

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

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

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

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