[Home] [Help]
1: PACKAGE BODY HZ_GEOGRAPHY_IDENTIFIERS_PKG AS
2: /*$Header: ARHGIDTB.pls 115.2 2003/02/19 00:26:53 smattegu noship $ */
3:
4: PROCEDURE Insert_Row (
5: x_rowid IN OUT NOCOPY VARCHAR2,
23: --dbms_output.put_line.PUT_LINE('before identifier insert in tblhandler');
24: --dbms_output.put_line.PUT_LINE('geography_id '||to_char(x_geography_id)||',subtype '||x_identifier_subtype||',value '||x_identifier_value ||',provider '||x_geo_data_provider||', version '||to_char(x_object_version_number));
25: --dbms_output.put_line.PUT_LINE('type '||x_identifier_type||',p_flag '||x_primary_flag||',use '||x_geography_use|| ',geo_type '||x_geography_type);
26:
27: INSERT INTO HZ_GEOGRAPHY_IDENTIFIERS (
28: geography_id,
29: identifier_subtype,
30: identifier_value,
31: geo_data_provider,
121: x_program_login_id IN NUMBER
122: ) IS
123: BEGIN
124:
125: UPDATE HZ_GEOGRAPHY_IDENTIFIERS
126: SET
127: geography_id =
128: DECODE(x_geography_id,
129: NULL, geography_id,
230: x_request_id IN NUMBER
231: ) IS
232:
233: CURSOR c IS
234: SELECT * FROM hz_geography_identifiers
235: WHERE rowid = x_rowid
236: FOR UPDATE NOWAIT;
237: Recinfo c%ROWTYPE;
238:
362: x_geography_type,
363: x_created_by_module,
364: x_application_id,
365: x_program_login_id
366: FROM HZ_GEOGRAPHY_IDENTIFIERS
367: WHERE geography_id = x_geography_id
368: AND identifier_subtype = x_identifier_subtype
369: AND identifier_value = x_identifier_value
370: AND language_code = x_language_code
389: x_identifier_type IN VARCHAR2
390: ) IS
391: BEGIN
392:
393: DELETE FROM HZ_GEOGRAPHY_IDENTIFIERS
394: WHERE geography_id = x_geography_id
395: AND identifier_subtype = x_identifier_subtype
396: AND identifier_value = x_identifier_value
397: AND language_code = x_language_code
402: END IF;
403:
404: END Delete_Row;
405:
406: END HZ_GEOGRAPHY_IDENTIFIERS_PKG;