DBA Data[Home] [Help]

APPS.IGS_PE_CITIZENSHIPS_PKG dependencies on FND_API

Line 91: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

87: p_object_version_number IN OUT NOCOPY NUMBER,
88: p_Calling_From IN VARCHAR2
89: ) AS
90:
91: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
92: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;
93: lv_citizenship_id NUMBER;
94: lv_object_version_number NUMBER;
95: lv_citizenship_rec_type HZ_PERSON_INFO_V2PUB.citizenship_rec_type;

Line 92: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;

88: p_Calling_From IN VARCHAR2
89: ) AS
90:
91: lv_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
92: lv_commit VARCHAR2(1) := FND_API.G_FALSE ;
93: lv_citizenship_id NUMBER;
94: lv_object_version_number NUMBER;
95: lv_citizenship_rec_type HZ_PERSON_INFO_V2PUB.citizenship_rec_type;
96: lv_last_update_date DATE := p_last_update_date;

Line 134: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

130: IF p_return_status IN ('E','U') THEN
131: -- ssawhney bug 2338473
132: IF p_msg_count > 1 THEN
133: FOR i IN 1..p_msg_count LOOP
134: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
135: tmp_var1 := tmp_var1 || ' '|| tmp_var;
136: END LOOP;
137: p_msg_data := tmp_var1;
138: END IF;

Line 145: lv_citizenship_rec_type.birth_or_selected := NVL(p_birth_or_selected,FND_API.G_MISS_CHAR);

141: p_object_version_number := 1;
142: END IF;
143: ELSIF p_action = 'UPDATE' THEN
144:
145: lv_citizenship_rec_type.birth_or_selected := NVL(p_birth_or_selected,FND_API.G_MISS_CHAR);
146: lv_citizenship_rec_type.country_code := p_country_code;
147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);
148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);
149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);

Line 147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);

143: ELSIF p_action = 'UPDATE' THEN
144:
145: lv_citizenship_rec_type.birth_or_selected := NVL(p_birth_or_selected,FND_API.G_MISS_CHAR);
146: lv_citizenship_rec_type.country_code := p_country_code;
147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);
148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);
149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);
150: lv_citizenship_rec_type.party_id := p_party_id;
151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);

Line 148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);

144:
145: lv_citizenship_rec_type.birth_or_selected := NVL(p_birth_or_selected,FND_API.G_MISS_CHAR);
146: lv_citizenship_rec_type.country_code := p_country_code;
147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);
148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);
149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);
150: lv_citizenship_rec_type.party_id := p_party_id;
151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);
152: lv_citizenship_rec_type.citizenship_id := p_citizenship_id;

Line 149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);

145: lv_citizenship_rec_type.birth_or_selected := NVL(p_birth_or_selected,FND_API.G_MISS_CHAR);
146: lv_citizenship_rec_type.country_code := p_country_code;
147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);
148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);
149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);
150: lv_citizenship_rec_type.party_id := p_party_id;
151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);
152: lv_citizenship_rec_type.citizenship_id := p_citizenship_id;
153: lv_citizenship_rec_type.document_type := NVL(p_document_type,FND_API.G_MISS_CHAR);

Line 151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);

147: lv_citizenship_rec_type.date_disowned := NVL(p_date_disowned,FND_API.G_MISS_DATE);
148: lv_citizenship_rec_type.date_recognized := NVL(p_date_recognized,FND_API.G_MISS_DATE);
149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);
150: lv_citizenship_rec_type.party_id := p_party_id;
151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);
152: lv_citizenship_rec_type.citizenship_id := p_citizenship_id;
153: lv_citizenship_rec_type.document_type := NVL(p_document_type,FND_API.G_MISS_CHAR);
154:
155: IF p_Calling_From='SS' THEN

Line 153: lv_citizenship_rec_type.document_type := NVL(p_document_type,FND_API.G_MISS_CHAR);

149: lv_citizenship_rec_type.document_reference := NVL(p_document_reference,FND_API.G_MISS_CHAR);
150: lv_citizenship_rec_type.party_id := p_party_id;
151: lv_citizenship_rec_type.end_date := NVL(p_end_date,FND_API.G_MISS_DATE);
152: lv_citizenship_rec_type.citizenship_id := p_citizenship_id;
153: lv_citizenship_rec_type.document_type := NVL(p_document_type,FND_API.G_MISS_CHAR);
154:
155: IF p_Calling_From='SS' THEN
156: validate_date(p_date_recognized ,p_end_date ,p_party_id , p_citizenship_id , p_country_code );
157: END IF;

Line 174: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

170:
171: -- ssawhney bug 2338473
172: IF p_msg_count > 1 THEN
173: FOR i IN 1..p_msg_count LOOP
174: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
175: tmp_var1 := tmp_var1 || ' '|| tmp_var;
176: END LOOP;
177: p_msg_data := tmp_var1;
178: END IF;