APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_AGING_DTLS

Line 538: INSERT INTO AR_CMGT_CF_AGING_DTLS

534: p_amount IN NUMBER,
535: p_error_msg OUT NOCOPY VARCHAR2,
536: p_resultout OUT NOCOPY VARCHAR2) IS
537: BEGIN
538: INSERT INTO AR_CMGT_CF_AGING_DTLS
539: (
540: case_folder_id,
541: last_updated_by,
542: last_update_date,

Line 576: UPDATE AR_CMGT_CF_AGING_DTLS

572: p_amount IN NUMBER,
573: p_error_msg OUT NOCOPY VARCHAR2,
574: p_resultout OUT NOCOPY VARCHAR2) IS
575: BEGIN
576: UPDATE AR_CMGT_CF_AGING_DTLS
577: SET last_updated_by = fnd_global.user_id,
578: last_update_date = sysdate,
579: last_update_login = fnd_global.login_id,
580: amount = p_amount

Line 883: INSERT INTO AR_CMGT_CF_AGING_DTLS

879: THEN
880:
881: BEGIN
882:
883: INSERT INTO AR_CMGT_CF_AGING_DTLS
884: (CASE_FOLDER_ID,
885: LAST_UPDATED_BY,
886: LAST_UPDATE_DATE,
887: LAST_UPDATE_LOGIN,

Line 904: FROM AR_CMGT_CF_AGING_DTLS

900: AGING_BUCKET_ID,
901: AGING_BUCKET_LINE_ID,
902: AMOUNT,
903: COUNT
904: FROM AR_CMGT_CF_AGING_DTLS
905: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id);
906:
907: EXCEPTION
908: WHEN OTHERS