[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,
413: PROCEDURE INSERT_ALL_ACC_RECORDS (p_user_id IN NUMBER )
414: IS
415: --Cursor to get the SR attachemnts
416: CURSOR c_SRAtt (b_user_id NUMBER) IS
417: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
418: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
419: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
420: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
421: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
442: AND acc.user_id = b_user_id;
443:
444: --Cursor to get the task attachemnts
445: CURSOR c_TaskAtt (b_user_id NUMBER) IS
446: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
447: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
448: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
449: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
450: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
471: AND acc.user_id = b_user_id;
472:
473: --Cursor to get the Signature attachemnts
474: CURSOR c_Signature (b_user_id NUMBER) IS
475: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
476: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
477: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
478: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
479: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
790:
791: CURSOR l_signature_csr(b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
792: b_lang IN VARCHAR)
793: IS
794: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
795: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
796: fndatt.entity_name, fndatt.pk1_value, fndatt.pk2_value,
797: fndatt.seq_num,asg.user_name,fnddoccat_tl.user_name,
798: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
826: -- get SR attachments
827: CURSOR l_SRAtt_csr (b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
828: b_lang VARCHAR)
829: IS
830: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
831: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
832: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
833: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
834: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
865: --get the task attachemnts
866: CURSOR l_TaskAtt_csr (b_task_assignment_id IN NUMBER, b_user_id IN NUMBER,
867: b_lang IN VARCHAR)
868: IS
869: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
870: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
871: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
872: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
873: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
1408: --for this is the file id sent from client may not be proper and so we allow the server to generate the file id
1409: CURSOR l_SRAtt_csr (b_incident_id IN NUMBER, b_user_id IN NUMBER,
1410: b_data_typeid IN NUMBER)
1411: IS
1412: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1413: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1414: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1415: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1416: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
1444: --Cursor to get the task attachemnts
1445: CURSOR l_TaskAtt_csr(b_task_id IN NUMBER, b_user_id IN NUMBER,
1446: b_data_typeid IN NUMBER)
1447: IS
1448: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1449: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1450: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1451: fndattdoc.seq_num, asg.user_name, fnddoccat_tl.user_name,
1452: fnddoc.usage_type, doctype.user_name, fnddoc.datatype_id,
1480: --Bug 5726888
1481: --Cursor to get the Signature attachemnts
1482: CURSOR c_Signature (b_debrief_id IN NUMBER, b_user_id IN NUMBER,
1483: b_data_typeid IN NUMBER) IS
1484: SELECT csm_fnd_lobs_acc_s.NEXTVAL, fnddoc.media_id, acc.user_id,
1485: fnddoccat_tl.name, fnddoc_tl.description, fnddoc_tl.language,
1486: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
1487: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
1488: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,