DBA Data[Home] [Help]

APPS.IEX_CO_REPORT_CB_PVT dependencies on FND_GLOBAL

Line 76: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS2);

72: l_case_rec.party_type := initcap(l_party_rec.party_type);
73:
74: l_address := rtrim(l_party_rec.ADDRESS1);
75: IF(rtrim(l_party_rec.ADDRESS2) IS NOT NULL) THEN
76: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS2);
77: END IF;
78:
79: IF(rtrim(l_party_rec.ADDRESS3) IS NOT NULL) THEN
80: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS3);

Line 80: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS3);

76: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS2);
77: END IF;
78:
79: IF(rtrim(l_party_rec.ADDRESS3) IS NOT NULL) THEN
80: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS3);
81: END IF;
82:
83: IF(rtrim(l_party_rec.ADDRESS4) IS NOT NULL) THEN
84: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS4);

Line 84: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS4);

80: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS3);
81: END IF;
82:
83: IF(rtrim(l_party_rec.ADDRESS4) IS NOT NULL) THEN
84: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS4);
85: END IF;
86:
87: IF(rtrim(l_party_rec.street) IS NOT NULL) THEN
88: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.house_number || ' ' || l_party_rec.street || ' ' || l_party_rec.apartment_number;

Line 88: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.house_number || ' ' || l_party_rec.street || ' ' || l_party_rec.apartment_number;

84: l_address := l_address || fnd_global.local_chr(10) || rtrim(l_party_rec.ADDRESS4);
85: END IF;
86:
87: IF(rtrim(l_party_rec.street) IS NOT NULL) THEN
88: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.house_number || ' ' || l_party_rec.street || ' ' || l_party_rec.apartment_number;
89: END IF;
90: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.city || ' ' || l_party_rec.state || ' ' || l_party_rec.postal_code || ' ' || l_party_rec.country;
91: l_case_rec.party_address := l_address;
92: END LOOP;

Line 90: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.city || ' ' || l_party_rec.state || ' ' || l_party_rec.postal_code || ' ' || l_party_rec.country;

86:
87: IF(rtrim(l_party_rec.street) IS NOT NULL) THEN
88: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.house_number || ' ' || l_party_rec.street || ' ' || l_party_rec.apartment_number;
89: END IF;
90: l_address := l_address || fnd_global.local_chr(10) || l_party_rec.city || ' ' || l_party_rec.state || ' ' || l_party_rec.postal_code || ' ' || l_party_rec.country;
91: l_case_rec.party_address := l_address;
92: END LOOP;
93:
94: BEGIN