APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_CONC_REQ_SUMM

Line 124: FROM jty_conc_req_summ a

120: WHERE a.terr_id = b.terr_id
121: AND b.source_id = p_source_id
122: AND a.start_date_active >
123: (SELECT max(end_date)
124: FROM jty_conc_req_summ a
125: WHERE a.program_name = 'JTY_STAR'
126: AND a.param1 = to_char(p_source_id)
127: AND a.retcode = 0)
128: AND a.start_date_active < sysdate

Line 179: FROM jty_conc_req_summ a

175: WHERE a.terr_id = b.terr_id
176: AND b.source_id = p_source_id
177: AND a.end_date_active >
178: (SELECT max(end_date)
179: FROM jty_conc_req_summ a
180: WHERE a.program_name = 'JTY_STAR'
181: AND a.param1 = to_char(p_source_id)
182: AND a.retcode = 0)
183: AND a.end_date_active < sysdate ) S

Line 394: FROM jty_conc_req_summ a

390:
391:
392: SELECT to_date(param3, 'dd/mm/yyyy hh24:mi:ss'),to_date(param4, 'dd/mm/yyyy hh24:mi:ss')
393: into l_dea_incr_start_date,l_dea_incr_end_date
394: FROM jty_conc_req_summ a
395: WHERE a.program_name = 'JTY_STAR'
396: AND a.param1 = to_char(p_source_id)
397: AND a.param2 = 'DATE EFFECTIVE'
398: AND a.retcode = 0

Line 918: FROM jty_conc_req_summ a

914: IF (p_mode = 'DEA INCREMENTAL') THEN
915:
916: SELECT to_date(param3, 'dd/mm/yyyy hh24:mi:ss'),to_date(param4, 'dd/mm/yyyy hh24:mi:ss')
917: into l_param_start_date,l_param_end_date
918: FROM jty_conc_req_summ a
919: WHERE a.program_name = 'JTY_STAR'
920: AND a.param1 = to_char(p_source_id)
921: AND a.param2 = 'DATE EFFECTIVE'
922: AND a.retcode = 0

Line 940: FROM jty_conc_req_summ a

936: IF (p_mode = 'INCREMENTAL') THEN
937: BEGIN
938: SELECT count(*)
939: INTO l_count
940: FROM jty_conc_req_summ a
941: WHERE a.program_name = 'JTY_STAR'
942: AND a.param1 = p_source_id
943: AND a.param2 = 'TOTAL'
944: AND a.retcode = 0;

Line 980: FROM jty_conc_req_summ a

976: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
977: BEGIN
978: SELECT count(*)
979: INTO l_count
980: FROM jty_conc_req_summ a
981: WHERE a.program_name = 'JTY_STAR'
982: AND a.param1 = p_source_id
983: AND a.param2 = 'DATE EFFECTIVE'
984: AND a.retcode = 0;

Line 1225: UPDATE JTY_CONC_REQ_SUMM

1221: retcode := 0;
1222: errbuf := null;
1223: l_end_date := SYSDATE;
1224:
1225: UPDATE JTY_CONC_REQ_SUMM
1226: SET requested_by = l_user_id
1227: ,request_date = l_start_date
1228: ,responsibility_application_id = l_resp_appl_id
1229: ,responsibility_id = l_resp_id

Line 1249: INSERT INTO JTY_CONC_REQ_SUMM (

1245: AND retcode = retcode
1246: AND param2 = p_mode;
1247:
1248: IF (SQL%ROWCOUNT = 0) THEN
1249: INSERT INTO JTY_CONC_REQ_SUMM (
1250: conc_req_id
1251: ,requested_by
1252: ,request_date
1253: ,responsibility_application_id

Line 1273: jty_conc_req_summ_s.nextval

1269: ,request_id
1270: ,conc_program_id
1271: ,object_version_number)
1272: VALUES (
1273: jty_conc_req_summ_s.nextval
1274: ,l_user_id
1275: ,l_start_date
1276: ,l_resp_appl_id
1277: ,l_resp_id