APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1103: FROM jty_trans_usg_pgm_details

1099: CURSOR c_trans_details( lp_source_id NUMBER
1100: ,lp_trans_id NUMBER) IS
1101: SELECT program_name
1102: ,real_time_trans_table_name
1103: FROM jty_trans_usg_pgm_details
1104: WHERE source_id = lp_source_id
1105: AND trans_type_id = lp_trans_id;
1106:
1107: TYPE l_rts_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_select%TYPE;

Line 1111: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;

1107: TYPE l_rts_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_select%TYPE;
1108: TYPE l_rtf_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_from%TYPE;
1109: TYPE l_rtw_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_where%TYPE;
1110:
1111: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1112: TYPE l_trans_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.real_time_trans_table_name%TYPE;
1113:
1114: l_qual_usg_id_tbl g_qual_usg_id_tbl_type;
1115: l_rts_tbl l_rts_tbl_type;

Line 1112: TYPE l_trans_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.real_time_trans_table_name%TYPE;

1108: TYPE l_rtf_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_from%TYPE;
1109: TYPE l_rtw_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_where%TYPE;
1110:
1111: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1112: TYPE l_trans_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.real_time_trans_table_name%TYPE;
1113:
1114: l_qual_usg_id_tbl g_qual_usg_id_tbl_type;
1115: l_rts_tbl l_rts_tbl_type;
1116: l_rtf_tbl l_rtf_tbl_type;

Line 1340: UPDATE jty_trans_usg_pgm_details

1336: l_realtime_sql := l_insert_stmt || l_qual_rules || l_group_by;
1337:
1338: /* if mode is date effective, update the column real_time_match_dea_sql */
1339: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
1340: UPDATE jty_trans_usg_pgm_details
1341: SET real_time_match_dea_sql = l_realtime_sql,
1342: last_update_date = sysdate
1343: WHERE source_id = p_source_id
1344: AND trans_type_id = p_trans_id

Line 1348: UPDATE jty_trans_usg_pgm_details

1344: AND trans_type_id = p_trans_id
1345: AND program_name = l_pgm_name_tbl(i);
1346: ELSE
1347: /* if mode is total or incremental, update the column real_time_match_sql */
1348: UPDATE jty_trans_usg_pgm_details
1349: SET real_time_match_sql = l_realtime_sql,
1350: last_update_date = sysdate
1351: WHERE source_id = p_source_id
1352: AND trans_type_id = p_trans_id