APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_DTLS

Line 79: SELECT ar_cmgt_cf_dtls_s.nextval

75: x_errmsg := 'Incorrect Date Format for Data Point Id :'||p_data_point_id;
76: return;
77: END;
78:
79: SELECT ar_cmgt_cf_dtls_s.nextval
80: INTO p_case_folder_detail_id
81: FROM dual;
82:
83: INSERT INTO ar_cmgt_cf_dtls

Line 83: INSERT INTO ar_cmgt_cf_dtls

79: SELECT ar_cmgt_cf_dtls_s.nextval
80: INTO p_case_folder_detail_id
81: FROM dual;
82:
83: INSERT INTO ar_cmgt_cf_dtls
84: ( case_folder_detail_id,
85: case_folder_id,
86: data_point_id,
87: sequence_number,

Line 255: UPDATE ar_cmgt_cf_dtls

251: p_resultout OUT NOCOPY VARCHAR2) IS
252: BEGIN
253: p_resultout := 0;
254:
255: UPDATE ar_cmgt_cf_dtls
256: SET score = nvl(p_score,score),
257: data_point_value = nvl(p_data_point_value, data_point_value),
258: last_updated_by = fnd_global.user_id,
259: last_update_date = sysdate,

Line 330: UPDATE ar_cmgt_cf_dtls

326: IS
327: BEGIN
328: x_resultout := 0;
329:
330: UPDATE ar_cmgt_cf_dtls
331: SET score = nvl(p_score,score),
332: data_point_value = nvl(p_data_point_value, data_point_value),
333: last_updated_by = fnd_global.user_id,
334: last_update_date = sysdate,

Line 688: l_seq_num AR_CMGT_CF_DTLS.CASE_FOLDER_DETAIL_ID%TYPE;

684: TYPE list_of_ids IS VARRAY(50000) OF list_change_id;
685: rec_changed_ids list_of_ids := list_of_ids();
686: counter BINARY_INTEGER;
687: counter1 BINARY_INTEGER;
688: l_seq_num AR_CMGT_CF_DTLS.CASE_FOLDER_DETAIL_ID%TYPE;
689:
690: CURSOR select_dtls IS
691: SELECT case_folder_id,
692: DATA_POINT_ID,

Line 700: FROM AR_CMGT_CF_DTLS

696: CASE_FOLDER_DETAIL_ID,
697: SEQUENCE_NUMBER,
698: PARENT_DATA_POINT_ID,
699: PARENT_CF_DETAIL_ID
700: FROM AR_CMGT_CF_DTLS
701: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id;
702:
703: BEGIN
704:

Line 737: SELECT ar_cmgt_cf_dtls_s.NEXTVAL

733: FOR select_dtls_rec IN select_dtls
734: LOOP
735: BEGIN
736:
737: SELECT ar_cmgt_cf_dtls_s.NEXTVAL
738: INTO l_seq_num
739: FROM dual;
740:
741: --store the parent_rec_id and corrosponding seq_num_id

Line 756: INSERT INTO AR_CMGT_CF_DTLS

752:
753:
754: --insert the records into case folder details.
755:
756: INSERT INTO AR_CMGT_CF_DTLS
757: (CASE_FOLDER_ID,
758: DATA_POINT_ID,
759: LAST_UPDATED_BY,
760: LAST_UPDATE_DATE,

Line 785: FROM AR_CMGT_CF_DTLS

781: l_seq_num,
782: SEQUENCE_NUMBER,
783: PARENT_DATA_POINT_ID,
784: PARENT_CF_DETAIL_ID
785: FROM AR_CMGT_CF_DTLS
786: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id
787: AND CASE_FOLDER_DETAIL_ID = select_dtls_rec.CASE_FOLDER_DETAIL_ID);
788:
789:

Line 821: UPDATE ar_cmgt_cf_dtls

817: l_rec_changed := rec_changed_ids(counter1);
818: counter1 := counter1 + 1 ;
819: --update the values of parent cf detail id
820:
821: UPDATE ar_cmgt_cf_dtls
822: SET parent_cf_detail_id = l_rec_changed.changed
823: WHERE case_folder_id = l_case_folders_id
824: AND PARENT_CF_DETAIL_ID = l_rec_changed.parent;
825:

Line 1745: update ar_cmgt_cf_dtls

1741: P_RESULT:=0;
1742: BEGIN
1743: --update the included in checklist flag to "Y"
1744:
1745: update ar_cmgt_cf_dtls
1746: set included_in_checklist = 'Y'
1747: where case_folder_id=P_CASE_FOLDER_ID
1748: and (data_point_id=P_DATA_POINT_ID
1749: OR PARENT_DATA_POINT_ID =P_DATA_POINT_ID);

Line 1776: update ar_cmgt_cf_dtls

1772: P_RESULT:=0;
1773: BEGIN
1774: --update the included in checklist flag to "Y"
1775:
1776: update ar_cmgt_cf_dtls
1777: set included_in_checklist = 'N'
1778: where case_folder_id=P_CASE_FOLDER_ID
1779: and data_point_id=P_DATA_POINT_ID;
1780: