APPS.CS_CIC_ATTRIBUTE_PUB dependencies on FND_GLOBAL

Line 333: l_create_attribute_note := l_new_constant || fnd_global.newline();

329: FROM Fnd_Lookup_values
330: WHERE Lookup_Code = 'CUG_SR_AUTONOTE_NEW'
331: AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
332: AND language = userenv('LANG');
333: l_create_attribute_note := l_new_constant || fnd_global.newline();
334: IF (p_address_summary IS NOT NULL) THEN
335: l_create_address_note := 'Incident Address' || fnd_global.newline() || p_address_summary;
336: ELSE
337: l_create_address_note := NULL;

Line 335: l_create_address_note := 'Incident Address' || fnd_global.newline() || p_address_summary;

331: AND Lookup_Type = 'CUG_SR_AUTONOTE_CONSTANT'
332: AND language = userenv('LANG');
333: l_create_attribute_note := l_new_constant || fnd_global.newline();
334: IF (p_address_summary IS NOT NULL) THEN
335: l_create_address_note := 'Incident Address' || fnd_global.newline() || p_address_summary;
336: ELSE
337: l_create_address_note := NULL;
338: END IF;
339: -- Set the WHO column values.

Line 398: l_create_attribute_note := l_create_attribute_note || l_attr_name || ' = ' || l_attr_value || fnd_global.newline();

394: l_attr_value := p_cic_attr_value(i);
395: l_attr_description := p_cic_attr_value(i); -- Added the code by spamujul for bug 12379451
396: END IF;
397:
398: l_create_attribute_note := l_create_attribute_note || l_attr_name || ' = ' || l_attr_value || fnd_global.newline();
399:
400: -- Generate the New Sequence # to store in INCIDNT_ATTR_VAL_ID.
401: SELECT CUG_INCIDNT_ATTR_VALS_B_S.nextval
402: INTO l_incident_attr_val_id

Line 575: l_new_values := l_new_values || fnd_global.newline();

571: l_ATTRIBUTE14 := NULL;
572: l_ATTRIBUTE15 := NULL;
573: l_ATTRIBUTE_CATEGORY := NULL;
574:
575: l_new_values := l_new_values || fnd_global.newline();
576: l_old_values := l_old_values || fnd_global.newline();
577:
578: IF p_incident_id IS NOT NULL THEN
579:

Line 576: l_old_values := l_old_values || fnd_global.newline();

572: l_ATTRIBUTE15 := NULL;
573: l_ATTRIBUTE_CATEGORY := NULL;
574:
575: l_new_values := l_new_values || fnd_global.newline();
576: l_old_values := l_old_values || fnd_global.newline();
577:
578: IF p_incident_id IS NOT NULL THEN
579:
580: FOR i IN p_incident_attr_val_id.FIRST .. p_incident_attr_val_id.LAST

Line 615: l_old_values := l_old_values || l_attr_name ||'=' || l_old_attr_values || fnd_global.newline() ;

611: FROM cug_incidnt_attr_vals_vl
612: WHERE INCIDNT_ATTR_VAL_ID = p_incident_attr_val_id(i);
613:
614: --- Update Attribute ---
615: l_old_values := l_old_values || l_attr_name ||'=' || l_old_attr_values || fnd_global.newline() ;
616: l_new_values := l_new_values || l_attr_name ||'=' || l_attr_value || fnd_global.newline() ;
617:
618: IF NVL(p_cic_attr_value(i),'XXX') <> NVL(l_old_attr_values,'XXX') THEN
619: l_update_note_flag := 'Y';

Line 616: l_new_values := l_new_values || l_attr_name ||'=' || l_attr_value || fnd_global.newline() ;

612: WHERE INCIDNT_ATTR_VAL_ID = p_incident_attr_val_id(i);
613:
614: --- Update Attribute ---
615: l_old_values := l_old_values || l_attr_name ||'=' || l_old_attr_values || fnd_global.newline() ;
616: l_new_values := l_new_values || l_attr_name ||'=' || l_attr_value || fnd_global.newline() ;
617:
618: IF NVL(p_cic_attr_value(i),'XXX') <> NVL(l_old_attr_values,'XXX') THEN
619: l_update_note_flag := 'Y';
620: END IF;

Line 660: l_update_attribute_note := l_new_values || fnd_global.newline() || l_old_values;

656:
657: END IF;
658: END LOOP;
659:
660: l_update_attribute_note := l_new_values || fnd_global.newline() || l_old_values;
661: IF l_update_note_flag <> 'N' THEN
662: -- Create Update Attribute Note --
663: CREATE_CIC_ATTRIBUTE_NOTE ( p_incident_id,
664: l_update_attribute_note,