APPS.CUG_GENERIC_WF_PKG dependencies on CUG_INCIDNT_ATTR_VALS_VL

Line 69: SELECT incidnt_attr_val_id from CUG_INCIDNT_ATTR_VALS_VL

65: WHERE INCIDENT_TYPE_ID = l_incident_type_id;
66: l_CheckIfSRHdrInfoPresent_rec l_CheckIfSRHdrInfoPresent_csr%ROWTYPE;
67:
68: CURSOR l_CheckIfSRAttrPresent_csr IS
69: SELECT incidnt_attr_val_id from CUG_INCIDNT_ATTR_VALS_VL
70: WHERE INCIDENT_ID = l_request_id;
71: l_CheckIfSRAttrPresent_rec l_CheckIfSRAttrPresent_csr%ROWTYPE;
72:
73: CURSOR l_CheckIfTaskPresent_csr IS

Line 653: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE

649: l_DuplicateCheckAttrs_rec l_DuplicateCheckAttrs_csr%ROWTYPE;
650:
651:
652: CURSOR l_NewDupAttrValue_csr IS
653: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE
654: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
655: incident_id = l_request_id;
656:
657: CURSOR l_OldDupAttrValue_csr IS

Line 658: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE

654: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
655: incident_id = l_request_id;
656:
657: CURSOR l_OldDupAttrValue_csr IS
658: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE
659: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
660: incident_id = l_IncidentId_rec.Incident_Id;
661:
662: CURSOR l_OldDupAttrValue_noLoc_csr IS

Line 663: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE

659: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
660: incident_id = l_IncidentId_rec.Incident_Id;
661:
662: CURSOR l_OldDupAttrValue_noLoc_csr IS
663: SELECT sr_attribute_value FROM cug_incidnt_attr_vals_vl WHERE
664: sr_attribute_code = l_DuplicateCheckAttrs_rec.sr_attribute_code AND
665: incident_id = l_IncidentId_noLoc_rec.Incident_Id;
666:
667:

Line 766: l_sql_stmt := 'select sr_attribute_value from cug_incidnt_attr_vals_vl where sr_attribute_code = '

762: LOOP
763: FETCH l_DuplicateCheckAttrs_csr into l_DuplicateCheckAttrs_rec;
764: EXIT WHEN l_DuplicateCheckAttrs_csr%NOTFOUND;
765:
766: l_sql_stmt := 'select sr_attribute_value from cug_incidnt_attr_vals_vl where sr_attribute_code = '
767: || l_DuplicateCheckAttrs_rec.sr_attribute_code || ' and incident_id = :incident_id';
768:
769: OPEN l_NewDupAttrValue_csr;
770: FETCH l_NewDupAttrValue_csr into l_SRAttribute_value_new;

Line 832: l_sql_stmt := 'select sr_attribute_value from cug_incidnt_attr_vals_vl where sr_attribute_code = '

828: LOOP
829: FETCH l_DuplicateCheckAttrs_csr into l_DuplicateCheckAttrs_rec;
830: EXIT WHEN l_DuplicateCheckAttrs_csr%NOTFOUND;
831:
832: l_sql_stmt := 'select sr_attribute_value from cug_incidnt_attr_vals_vl where sr_attribute_code = '
833: || l_DuplicateCheckAttrs_rec.sr_attribute_code || ' and incident_id = :incident_id';
834:
835: OPEN l_NewDupAttrValue_csr;
836: FETCH l_NewDupAttrValue_csr into l_SRAttribute_value_new;

Line 1095: SELECT SR_ATTRIBUTE_VALUE FROM CUG_INCIDNT_ATTR_VALS_VL WHERE

1091:
1092:
1093: CURSOR c_SRAttr_Value_csr
1094: IS
1095: SELECT SR_ATTRIBUTE_VALUE FROM CUG_INCIDNT_ATTR_VALS_VL WHERE
1096: INCIDENT_ID = l_request_id AND
1097: SR_ATTRIBUTE_CODE = l_sr_attribute_code;
1098: l_SRAttr_Value_rec c_SRAttr_Value_csr%ROWTYPE;
1099: