APPS.AMS_TCOP_SUMMARIZATION_PKG dependencies on AMS_TCOP_CONTACT_SUM_DTL_S

Line 188: --SELECT AMS_TCOP_CONTACT_SUM_DTL_S.nextval

184: FROM DUAL;
185:
186: --CURSOR C_GET_CONTACT_SUM_DTL_NEXT_SEQ
187: --IS
188: --SELECT AMS_TCOP_CONTACT_SUM_DTL_S.nextval
189: --FROM DUAL;
190:
191: CURSOR C_GET_CHNL_SUM_NEXT_SEQ
192: IS

Line 345: -- AMS_TCOP_CONTACT_SUM_DTL.summary_dtl_id

341: --FETCH C_GET_CONTACT_SUM_DTL_NEXT_SEQ
342: --INTO l_sequence_id;
343: --CLOSE C_GET_CONTACT_SUM_DTL_NEXT_SEQ;
344:
345: -- AMS_TCOP_CONTACT_SUM_DTL.summary_dtl_id
346: --l_contact_sum_id_dtl_list (i) := l_sequence_id;
347:
348:
349: -- set Loop variables

Line 414: AMS_TCOP_CONTACT_SUM_DTL_S.nextval,

410: )
411: VALUES
412: (
413: --l_contact_sum_id_dtl_list(i),
414: AMS_TCOP_CONTACT_SUM_DTL_S.nextval,
415: l_contact_sum_id_list_for_dtl(i),
416: l_schedule_id_list(i),
417: sysdate,
418: FND_GLOBAL.USER_ID,

Line 643: SELECT AMS_TCOP_CONTACT_SUM_DTL_S.NEXTVAL

639: );
640:
641: CURSOR C_GET_SUM_DTL_SEQ
642: IS
643: SELECT AMS_TCOP_CONTACT_SUM_DTL_S.NEXTVAL
644: FROM DUAL;
645:
646: CURSOR C_GET_CONTACT_SUM_SEQ
647: IS