APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1089: FROM jty_trans_usg_pgm_details

1085: CURSOR c_trans_details( lp_source_id NUMBER
1086: ,lp_trans_id NUMBER) IS
1087: SELECT program_name
1088: ,real_time_trans_table_name
1089: FROM jty_trans_usg_pgm_details
1090: WHERE source_id = lp_source_id
1091: AND trans_type_id = lp_trans_id;
1092:
1093: TYPE l_rts_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_select%TYPE;

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

1093: TYPE l_rts_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_select%TYPE;
1094: TYPE l_rtf_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_from%TYPE;
1095: TYPE l_rtw_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_where%TYPE;
1096:
1097: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1098: TYPE l_trans_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.real_time_trans_table_name%TYPE;
1099:
1100: l_qual_usg_id_tbl g_qual_usg_id_tbl_type;
1101: l_rts_tbl l_rts_tbl_type;

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

1094: TYPE l_rtf_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_from%TYPE;
1095: TYPE l_rtw_tbl_type IS TABLE OF jtf_qual_usgs_all.real_time_where%TYPE;
1096:
1097: TYPE l_pgm_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.program_name%TYPE;
1098: TYPE l_trans_name_tbl_type IS TABLE OF jty_trans_usg_pgm_details.real_time_trans_table_name%TYPE;
1099:
1100: l_qual_usg_id_tbl g_qual_usg_id_tbl_type;
1101: l_rts_tbl l_rts_tbl_type;
1102: l_rtf_tbl l_rtf_tbl_type;

Line 1301: UPDATE jty_trans_usg_pgm_details

1297: l_realtime_sql := l_insert_stmt || l_qual_rules || l_group_by;
1298:
1299: /* if mode is date effective, update the column real_time_match_dea_sql */
1300: IF (p_mode = 'DATE EFFECTIVE') THEN
1301: UPDATE jty_trans_usg_pgm_details
1302: SET real_time_match_dea_sql = l_realtime_sql,
1303: last_update_date = sysdate
1304: WHERE source_id = p_source_id
1305: AND trans_type_id = p_trans_id

Line 1309: UPDATE jty_trans_usg_pgm_details

1305: AND trans_type_id = p_trans_id
1306: AND program_name = l_pgm_name_tbl(i);
1307: ELSE
1308: /* if mode is total or incremental, update the column real_time_match_sql */
1309: UPDATE jty_trans_usg_pgm_details
1310: SET real_time_match_sql = l_realtime_sql,
1311: last_update_date = sysdate
1312: WHERE source_id = p_source_id
1313: AND trans_type_id = p_trans_id