APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_CONC_REQ_SUMM

Line 114: FROM jty_conc_req_summ a

110: WHERE a.terr_id = b.terr_id
111: AND b.source_id = p_source_id
112: AND a.start_date_active >
113: (SELECT max(end_date)
114: FROM jty_conc_req_summ a
115: WHERE a.program_name = 'JTY_STAR'
116: AND a.param1 = to_char(p_source_id)
117: AND a.retcode = 0)
118: AND a.start_date_active < sysdate

Line 169: FROM jty_conc_req_summ a

165: WHERE a.terr_id = b.terr_id
166: AND b.source_id = p_source_id
167: AND a.end_date_active >
168: (SELECT max(end_date)
169: FROM jty_conc_req_summ a
170: WHERE a.program_name = 'JTY_STAR'
171: AND a.param1 = to_char(p_source_id)
172: AND a.retcode = 0)
173: AND a.end_date_active < sysdate ) S

Line 687: FROM jty_conc_req_summ a

683: IF (p_mode = 'INCREMENTAL') THEN
684: BEGIN
685: SELECT count(*)
686: INTO l_count
687: FROM jty_conc_req_summ a
688: WHERE a.program_name = 'JTY_STAR'
689: AND a.param1 = p_source_id
690: AND a.param2 = 'TOTAL'
691: AND a.retcode = 0;

Line 927: UPDATE JTY_CONC_REQ_SUMM

923: retcode := 0;
924: errbuf := null;
925: l_end_date := SYSDATE;
926:
927: UPDATE JTY_CONC_REQ_SUMM
928: SET requested_by = l_user_id
929: ,request_date = l_start_date
930: ,responsibility_application_id = l_resp_appl_id
931: ,responsibility_id = l_resp_id

Line 951: INSERT INTO JTY_CONC_REQ_SUMM (

947: AND retcode = retcode
948: AND param2 = p_mode;
949:
950: IF (SQL%ROWCOUNT = 0) THEN
951: INSERT INTO JTY_CONC_REQ_SUMM (
952: conc_req_id
953: ,requested_by
954: ,request_date
955: ,responsibility_application_id

Line 975: jty_conc_req_summ_s.nextval

971: ,request_id
972: ,conc_program_id
973: ,object_version_number)
974: VALUES (
975: jty_conc_req_summ_s.nextval
976: ,l_user_id
977: ,l_start_date
978: ,l_resp_appl_id
979: ,l_resp_id