[Home] [Help]
53: --DATATYPE ID 6 = LOBS
54: --Cursor to get the SR attachemnts
55: CURSOR l_SRAtt_csr
56: IS
57: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
58: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
59: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
60: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
61: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
86:
87: --Cursor to get the task attachemnts
88: CURSOR l_TaskAtt_csr
89: IS
90: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
91: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
92: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
93: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
94: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
119:
120: --Bug 5726888
121: --Cursor to get the Signature attachemnts
122: CURSOR c_Signature IS
123: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
124: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
125: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
126: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
127: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
478: PROCEDURE INSERT_ALL_ACC_RECORDS (p_user_id IN NUMBER )
479: IS
480: --Cursor to get the SR attachemnts
481: CURSOR c_SRAtt (b_user_id NUMBER) IS
482: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
483: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
484: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
485: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
486: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
507: AND acc.user_id = b_user_id;
508:
509: --Cursor to get the task attachemnts
510: CURSOR c_TaskAtt (b_user_id NUMBER) IS
511: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
512: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
513: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
514: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
515: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
536: AND acc.user_id = b_user_id;
537:
538: --Cursor to get the Signature attachemnts
539: CURSOR c_Signature (b_user_id NUMBER) IS
540: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
541: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
542: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
543: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
544: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
855:
856: CURSOR l_signature_csr(b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
857: b_lang IN VARCHAR)
858: IS
859: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
860: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
861: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
862: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
863: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
891: -- get SR attachments
892: CURSOR l_SRAtt_csr (b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
893: b_lang VARCHAR)
894: IS
895: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
896: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
897: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
898: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
899: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
930: --get the task attachemnts
931: CURSOR l_TaskAtt_csr (b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
932: b_lang IN VARCHAR)
933: IS
934: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
935: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
936: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
937: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
938: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
1473: --for this is the file id sent from client may not be proper and so we allow the server to generate the file id
1474: CURSOR l_SRAtt_csr (b_incident_id IN NUMBER, b_user_id IN NUMBER,
1475: b_data_typeid IN NUMBER)
1476: IS
1477: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1478: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1479: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1480: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1481: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
1509: --Cursor to get the task attachemnts
1510: CURSOR l_TaskAtt_csr(b_task_id IN NUMBER, b_user_id IN NUMBER,
1511: b_data_typeid IN NUMBER)
1512: IS
1513: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1514: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1515: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1516: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1517: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
1545: --Bug 5726888
1546: --Cursor to get the Signature attachemnts
1547: CURSOR c_Signature (b_debrief_id IN NUMBER, b_user_id IN NUMBER,
1548: b_data_typeid IN NUMBER) IS
1549: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1550: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1551: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1552: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
1553: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,