APPS.HR_PROCESS_ADDRESS_SS dependencies on HR_TRANSACTION_API

Line 480: hr_transaction_api.create_transaction_step

476: END IF;
477: --
478: -- Create a transaction step
479: --
480: hr_transaction_api.create_transaction_step
481: (p_validate => false
482: ,p_creator_person_id => nvl(p_login_person_id, p_person_id) -- PB : Modification
483: ,p_transaction_id => l_transaction_id
484: ,p_api_name => g_package || '.PROCESS_API'

Line 1179: hr_transaction_api.create_transaction_step

1175: END IF;
1176: --
1177: -- Create a transaction step
1178: --
1179: hr_transaction_api.create_transaction_step
1180: (p_validate => false
1181: -- PB : For creating address for a contact use
1182: -- use login person id.
1183: --

Line 1710: hr_transaction_api.get_transaction_step_info

1706: -- item type and item key, therefore, we don't need to handle the multiple
1707: -- rows situation.
1708:
1709: FOR i in 1..l_count LOOP
1710: hr_transaction_api.get_transaction_step_info
1711: (p_item_type => p_item_type
1712: ,p_item_key => l_active_wf_items_tbl(i).active_item_key
1713: ,p_activity_id => l_active_wf_items_tbl(i).activity_id
1714: ,p_transaction_step_id => l_trans_step_id

Line 1898: hr_transaction_api.get_transaction_step_info

1894: -- transaction. This is used for re-display the Update page when a user
1895: -- clicks the Back button on the Review page to go back to the Update page
1896: -- to make further changes or to correct errors.
1897: -----------------------------------------------------------------------------
1898: hr_transaction_api.get_transaction_step_info
1899: (p_item_type => p_item_type
1900: ,p_item_key => p_item_key
1901: ,p_activity_id => p_activity_id
1902: ,p_transaction_step_id => l_trans_step_ids

Line 2084: p_person_id := hr_transaction_api.get_number_value

2080: p_effective_date:= to_date(
2081: hr_transaction_ss.get_wf_effective_date
2082: (p_transaction_step_id => p_transaction_step_id),g_date_format);
2083: --
2084: p_person_id := hr_transaction_api.get_number_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_PERSON_ID');
2087: --
2088: p_address_id := hr_transaction_api.get_number_value

Line 2088: p_address_id := hr_transaction_api.get_number_value

2084: p_person_id := hr_transaction_api.get_number_value
2085: (p_transaction_step_id => p_transaction_step_id
2086: ,p_name => 'P_PERSON_ID');
2087: --
2088: p_address_id := hr_transaction_api.get_number_value
2089: (p_transaction_step_id => p_transaction_step_id
2090: ,p_name => 'P_ADDRESS_ID');
2091: --
2092: p_object_version_number := hr_transaction_api.get_number_value

Line 2092: p_object_version_number := hr_transaction_api.get_number_value

2088: p_address_id := hr_transaction_api.get_number_value
2089: (p_transaction_step_id => p_transaction_step_id
2090: ,p_name => 'P_ADDRESS_ID');
2091: --
2092: p_object_version_number := hr_transaction_api.get_number_value
2093: (p_transaction_step_id => p_transaction_step_id
2094: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2095: --
2096: p_primary_flag := hr_transaction_api.get_varchar2_value

Line 2096: p_primary_flag := hr_transaction_api.get_varchar2_value

2092: p_object_version_number := hr_transaction_api.get_number_value
2093: (p_transaction_step_id => p_transaction_step_id
2094: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2095: --
2096: p_primary_flag := hr_transaction_api.get_varchar2_value
2097: (p_transaction_step_id => p_transaction_step_id
2098: ,p_name => 'P_PRIMARY_FLAG');
2099: -- startregistration anupam
2100: if p_primary_flag = 'T' then

Line 2105: p_style := hr_transaction_api.get_varchar2_value

2101: p_primary_flag :='N';
2102: end if;
2103: -- endregistration anupam
2104: --
2105: p_style := hr_transaction_api.get_varchar2_value
2106: (p_transaction_step_id => p_transaction_step_id
2107: ,p_name => 'P_STYLE');
2108:
2109: --

Line 2111: hr_transaction_api.get_date_value

2107: ,p_name => 'P_STYLE');
2108:
2109: --
2110: p_date_from :=
2111: hr_transaction_api.get_date_value
2112: (p_transaction_step_id => p_transaction_step_id
2113: ,p_name => 'P_DATE_FROM');
2114: --
2115: p_date_to :=

Line 2116: hr_transaction_api.get_date_value

2112: (p_transaction_step_id => p_transaction_step_id
2113: ,p_name => 'P_DATE_FROM');
2114: --
2115: p_date_to :=
2116: hr_transaction_api.get_date_value
2117: (p_transaction_step_id => p_transaction_step_id
2118: ,p_name => 'P_DATE_TO');
2119: --
2120: p_address_type :=

Line 2121: hr_transaction_api.get_varchar2_value

2117: (p_transaction_step_id => p_transaction_step_id
2118: ,p_name => 'P_DATE_TO');
2119: --
2120: p_address_type :=
2121: hr_transaction_api.get_varchar2_value
2122: (p_transaction_step_id => p_transaction_step_id
2123: ,p_name => 'P_ADDRESS_TYPE_CODE');
2124: --
2125: p_address_type_meaning :=

Line 2126: hr_transaction_api.get_varchar2_value

2122: (p_transaction_step_id => p_transaction_step_id
2123: ,p_name => 'P_ADDRESS_TYPE_CODE');
2124: --
2125: p_address_type_meaning :=
2126: hr_transaction_api.get_varchar2_value
2127: (p_transaction_step_id => p_transaction_step_id
2128: ,p_name => 'P_ADDRESS_TYPE');
2129:
2130: --

Line 2132: -- hr_transaction_api.get_varchar2_value

2128: ,p_name => 'P_ADDRESS_TYPE');
2129:
2130: --
2131: -- p_comments :=
2132: -- hr_transaction_api.get_varchar2_value
2133: -- (p_transaction_step_id => p_transaction_step_id
2134: -- ,p_name => 'P_COMMENTS');
2135: --
2136: p_address_line1 :=

Line 2137: hr_transaction_api.get_varchar2_value

2133: -- (p_transaction_step_id => p_transaction_step_id
2134: -- ,p_name => 'P_COMMENTS');
2135: --
2136: p_address_line1 :=
2137: hr_transaction_api.get_varchar2_value
2138: (p_transaction_step_id => p_transaction_step_id
2139: ,p_name => 'P_ADDRESS_LINE1');
2140: --
2141: p_address_line2 :=

Line 2142: hr_transaction_api.get_varchar2_value

2138: (p_transaction_step_id => p_transaction_step_id
2139: ,p_name => 'P_ADDRESS_LINE1');
2140: --
2141: p_address_line2 :=
2142: hr_transaction_api.get_varchar2_value
2143: (p_transaction_step_id => p_transaction_step_id
2144: ,p_name => 'P_ADDRESS_LINE2');
2145: --
2146: p_address_line3 :=

Line 2147: hr_transaction_api.get_varchar2_value

2143: (p_transaction_step_id => p_transaction_step_id
2144: ,p_name => 'P_ADDRESS_LINE2');
2145: --
2146: p_address_line3 :=
2147: hr_transaction_api.get_varchar2_value
2148: (p_transaction_step_id => p_transaction_step_id
2149: ,p_name => 'P_ADDRESS_LINE3');
2150: --
2151: p_town_or_city :=

Line 2152: hr_transaction_api.get_varchar2_value

2148: (p_transaction_step_id => p_transaction_step_id
2149: ,p_name => 'P_ADDRESS_LINE3');
2150: --
2151: p_town_or_city :=
2152: hr_transaction_api.get_varchar2_value
2153: (p_transaction_step_id => p_transaction_step_id
2154: ,p_name => 'P_CITY');
2155: --
2156: p_region_1 :=

Line 2157: hr_transaction_api.get_varchar2_value

2153: (p_transaction_step_id => p_transaction_step_id
2154: ,p_name => 'P_CITY');
2155: --
2156: p_region_1 :=
2157: hr_transaction_api.get_varchar2_value
2158: (p_transaction_step_id => p_transaction_step_id
2159: ,p_name => 'P_REGION1');
2160: --
2161: p_region_2 :=

Line 2162: hr_transaction_api.get_varchar2_value

2158: (p_transaction_step_id => p_transaction_step_id
2159: ,p_name => 'P_REGION1');
2160: --
2161: p_region_2 :=
2162: hr_transaction_api.get_varchar2_value
2163: (p_transaction_step_id => p_transaction_step_id
2164: ,p_name => 'P_REGION2');
2165: --
2166: p_region_3 :=

Line 2167: hr_transaction_api.get_varchar2_value

2163: (p_transaction_step_id => p_transaction_step_id
2164: ,p_name => 'P_REGION2');
2165: --
2166: p_region_3 :=
2167: hr_transaction_api.get_varchar2_value
2168: (p_transaction_step_id => p_transaction_step_id
2169: ,p_name => 'P_REGION3');
2170: --
2171: p_postal_code :=

Line 2172: hr_transaction_api.get_varchar2_value

2168: (p_transaction_step_id => p_transaction_step_id
2169: ,p_name => 'P_REGION3');
2170: --
2171: p_postal_code :=
2172: hr_transaction_api.get_varchar2_value
2173: (p_transaction_step_id => p_transaction_step_id
2174: ,p_name => 'P_POSTAL_CODE');
2175: --
2176: p_country :=

Line 2177: hr_transaction_api.get_varchar2_value

2173: (p_transaction_step_id => p_transaction_step_id
2174: ,p_name => 'P_POSTAL_CODE');
2175: --
2176: p_country :=
2177: hr_transaction_api.get_varchar2_value
2178: (p_transaction_step_id => p_transaction_step_id
2179: ,p_name => 'P_COUNTRY_CODE');
2180: --
2181: p_country_meaning :=

Line 2182: hr_transaction_api.get_varchar2_value

2178: (p_transaction_step_id => p_transaction_step_id
2179: ,p_name => 'P_COUNTRY_CODE');
2180: --
2181: p_country_meaning :=
2182: hr_transaction_api.get_varchar2_value
2183: (p_transaction_step_id => p_transaction_step_id
2184: ,p_name => 'P_COUNTRY');
2185: --
2186: p_telephone_number_1 :=

Line 2187: hr_transaction_api.get_varchar2_value

2183: (p_transaction_step_id => p_transaction_step_id
2184: ,p_name => 'P_COUNTRY');
2185: --
2186: p_telephone_number_1 :=
2187: hr_transaction_api.get_varchar2_value
2188: (p_transaction_step_id => p_transaction_step_id
2189: ,p_name => 'P_TELEPHONE_NUMBER1');
2190: --
2191: p_telephone_number_2 :=

Line 2192: hr_transaction_api.get_varchar2_value

2188: (p_transaction_step_id => p_transaction_step_id
2189: ,p_name => 'P_TELEPHONE_NUMBER1');
2190: --
2191: p_telephone_number_2 :=
2192: hr_transaction_api.get_varchar2_value
2193: (p_transaction_step_id => p_transaction_step_id
2194: ,p_name => 'P_TELEPHONE_NUMBER2');
2195: --
2196: p_telephone_number_3 :=

Line 2197: hr_transaction_api.get_varchar2_value

2193: (p_transaction_step_id => p_transaction_step_id
2194: ,p_name => 'P_TELEPHONE_NUMBER2');
2195: --
2196: p_telephone_number_3 :=
2197: hr_transaction_api.get_varchar2_value
2198: (p_transaction_step_id => p_transaction_step_id
2199: ,p_name => 'P_TELEPHONE_NUMBER3');
2200: --
2201: p_addr_attribute_category :=

Line 2202: hr_transaction_api.get_varchar2_value

2198: (p_transaction_step_id => p_transaction_step_id
2199: ,p_name => 'P_TELEPHONE_NUMBER3');
2200: --
2201: p_addr_attribute_category :=
2202: hr_transaction_api.get_varchar2_value
2203: (p_transaction_step_id => p_transaction_step_id
2204: ,p_name => 'P_ADDR_ATTRIBUTE_CATEGORY');
2205: --
2206: p_addr_attribute1 :=

Line 2207: hr_transaction_api.get_varchar2_value

2203: (p_transaction_step_id => p_transaction_step_id
2204: ,p_name => 'P_ADDR_ATTRIBUTE_CATEGORY');
2205: --
2206: p_addr_attribute1 :=
2207: hr_transaction_api.get_varchar2_value
2208: (p_transaction_step_id => p_transaction_step_id
2209: ,p_name => 'P_ADDR_ATTRIBUTE1');
2210: --
2211: p_addr_attribute2 :=

Line 2212: hr_transaction_api.get_varchar2_value

2208: (p_transaction_step_id => p_transaction_step_id
2209: ,p_name => 'P_ADDR_ATTRIBUTE1');
2210: --
2211: p_addr_attribute2 :=
2212: hr_transaction_api.get_varchar2_value
2213: (p_transaction_step_id => p_transaction_step_id
2214: ,p_name => 'P_ADDR_ATTRIBUTE2');
2215: --
2216: p_addr_attribute3 :=

Line 2217: hr_transaction_api.get_varchar2_value

2213: (p_transaction_step_id => p_transaction_step_id
2214: ,p_name => 'P_ADDR_ATTRIBUTE2');
2215: --
2216: p_addr_attribute3 :=
2217: hr_transaction_api.get_varchar2_value
2218: (p_transaction_step_id => p_transaction_step_id
2219: ,p_name => 'P_ADDR_ATTRIBUTE3');
2220: --
2221: p_addr_attribute4 :=

Line 2222: hr_transaction_api.get_varchar2_value

2218: (p_transaction_step_id => p_transaction_step_id
2219: ,p_name => 'P_ADDR_ATTRIBUTE3');
2220: --
2221: p_addr_attribute4 :=
2222: hr_transaction_api.get_varchar2_value
2223: (p_transaction_step_id => p_transaction_step_id
2224: ,p_name => 'P_ADDR_ATTRIBUTE4');
2225: --
2226: p_addr_attribute5 :=

Line 2227: hr_transaction_api.get_varchar2_value

2223: (p_transaction_step_id => p_transaction_step_id
2224: ,p_name => 'P_ADDR_ATTRIBUTE4');
2225: --
2226: p_addr_attribute5 :=
2227: hr_transaction_api.get_varchar2_value
2228: (p_transaction_step_id => p_transaction_step_id
2229: ,p_name => 'P_ADDR_ATTRIBUTE5');
2230: --
2231: p_addr_attribute6 :=

Line 2232: hr_transaction_api.get_varchar2_value

2228: (p_transaction_step_id => p_transaction_step_id
2229: ,p_name => 'P_ADDR_ATTRIBUTE5');
2230: --
2231: p_addr_attribute6 :=
2232: hr_transaction_api.get_varchar2_value
2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_name => 'P_ADDR_ATTRIBUTE6');
2235: --
2236: p_addr_attribute7 :=

Line 2237: hr_transaction_api.get_varchar2_value

2233: (p_transaction_step_id => p_transaction_step_id
2234: ,p_name => 'P_ADDR_ATTRIBUTE6');
2235: --
2236: p_addr_attribute7 :=
2237: hr_transaction_api.get_varchar2_value
2238: (p_transaction_step_id => p_transaction_step_id
2239: ,p_name => 'P_ADDR_ATTRIBUTE7');
2240: --
2241: p_addr_attribute8 :=

Line 2242: hr_transaction_api.get_varchar2_value

2238: (p_transaction_step_id => p_transaction_step_id
2239: ,p_name => 'P_ADDR_ATTRIBUTE7');
2240: --
2241: p_addr_attribute8 :=
2242: hr_transaction_api.get_varchar2_value
2243: (p_transaction_step_id => p_transaction_step_id
2244: ,p_name => 'P_ADDR_ATTRIBUTE8');
2245: --
2246: p_addr_attribute9 :=

Line 2247: hr_transaction_api.get_varchar2_value

2243: (p_transaction_step_id => p_transaction_step_id
2244: ,p_name => 'P_ADDR_ATTRIBUTE8');
2245: --
2246: p_addr_attribute9 :=
2247: hr_transaction_api.get_varchar2_value
2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_name => 'P_ADDR_ATTRIBUTE9');
2250: --
2251: p_addr_attribute10 :=

Line 2252: hr_transaction_api.get_varchar2_value

2248: (p_transaction_step_id => p_transaction_step_id
2249: ,p_name => 'P_ADDR_ATTRIBUTE9');
2250: --
2251: p_addr_attribute10 :=
2252: hr_transaction_api.get_varchar2_value
2253: (p_transaction_step_id => p_transaction_step_id
2254: ,p_name => 'P_ADDR_ATTRIBUTE10');
2255: --
2256: p_addr_attribute11 :=

Line 2257: hr_transaction_api.get_varchar2_value

2253: (p_transaction_step_id => p_transaction_step_id
2254: ,p_name => 'P_ADDR_ATTRIBUTE10');
2255: --
2256: p_addr_attribute11 :=
2257: hr_transaction_api.get_varchar2_value
2258: (p_transaction_step_id => p_transaction_step_id
2259: ,p_name => 'P_ADDR_ATTRIBUTE11');
2260: --
2261: p_addr_attribute12 :=

Line 2262: hr_transaction_api.get_varchar2_value

2258: (p_transaction_step_id => p_transaction_step_id
2259: ,p_name => 'P_ADDR_ATTRIBUTE11');
2260: --
2261: p_addr_attribute12 :=
2262: hr_transaction_api.get_varchar2_value
2263: (p_transaction_step_id => p_transaction_step_id
2264: ,p_name => 'P_ADDR_ATTRIBUTE12');
2265: --
2266: p_addr_attribute13 :=

Line 2267: hr_transaction_api.get_varchar2_value

2263: (p_transaction_step_id => p_transaction_step_id
2264: ,p_name => 'P_ADDR_ATTRIBUTE12');
2265: --
2266: p_addr_attribute13 :=
2267: hr_transaction_api.get_varchar2_value
2268: (p_transaction_step_id => p_transaction_step_id
2269: ,p_name => 'P_ADDR_ATTRIBUTE13');
2270: --
2271: p_addr_attribute14 :=

Line 2272: hr_transaction_api.get_varchar2_value

2268: (p_transaction_step_id => p_transaction_step_id
2269: ,p_name => 'P_ADDR_ATTRIBUTE13');
2270: --
2271: p_addr_attribute14 :=
2272: hr_transaction_api.get_varchar2_value
2273: (p_transaction_step_id => p_transaction_step_id
2274: ,p_name => 'P_ADDR_ATTRIBUTE14');
2275: --
2276: p_addr_attribute15 :=

Line 2277: hr_transaction_api.get_varchar2_value

2273: (p_transaction_step_id => p_transaction_step_id
2274: ,p_name => 'P_ADDR_ATTRIBUTE14');
2275: --
2276: p_addr_attribute15 :=
2277: hr_transaction_api.get_varchar2_value
2278: (p_transaction_step_id => p_transaction_step_id
2279: ,p_name => 'P_ADDR_ATTRIBUTE15');
2280: --
2281: p_addr_attribute16 :=

Line 2282: hr_transaction_api.get_varchar2_value

2278: (p_transaction_step_id => p_transaction_step_id
2279: ,p_name => 'P_ADDR_ATTRIBUTE15');
2280: --
2281: p_addr_attribute16 :=
2282: hr_transaction_api.get_varchar2_value
2283: (p_transaction_step_id => p_transaction_step_id
2284: ,p_name => 'P_ADDR_ATTRIBUTE16');
2285: --
2286: p_addr_attribute17 :=

Line 2287: hr_transaction_api.get_varchar2_value

2283: (p_transaction_step_id => p_transaction_step_id
2284: ,p_name => 'P_ADDR_ATTRIBUTE16');
2285: --
2286: p_addr_attribute17 :=
2287: hr_transaction_api.get_varchar2_value
2288: (p_transaction_step_id => p_transaction_step_id
2289: ,p_name => 'P_ADDR_ATTRIBUTE17');
2290: --
2291: p_addr_attribute18 :=

Line 2292: hr_transaction_api.get_varchar2_value

2288: (p_transaction_step_id => p_transaction_step_id
2289: ,p_name => 'P_ADDR_ATTRIBUTE17');
2290: --
2291: p_addr_attribute18 :=
2292: hr_transaction_api.get_varchar2_value
2293: (p_transaction_step_id => p_transaction_step_id
2294: ,p_name => 'P_ADDR_ATTRIBUTE18');
2295: --
2296: p_addr_attribute19 :=

Line 2297: hr_transaction_api.get_varchar2_value

2293: (p_transaction_step_id => p_transaction_step_id
2294: ,p_name => 'P_ADDR_ATTRIBUTE18');
2295: --
2296: p_addr_attribute19 :=
2297: hr_transaction_api.get_varchar2_value
2298: (p_transaction_step_id => p_transaction_step_id
2299: ,p_name => 'P_ADDR_ATTRIBUTE19');
2300: --
2301: p_addr_attribute20 :=

Line 2302: hr_transaction_api.get_varchar2_value

2298: (p_transaction_step_id => p_transaction_step_id
2299: ,p_name => 'P_ADDR_ATTRIBUTE19');
2300: --
2301: p_addr_attribute20 :=
2302: hr_transaction_api.get_varchar2_value
2303: (p_transaction_step_id => p_transaction_step_id
2304: ,p_name => 'P_ADDR_ATTRIBUTE20');
2305: --
2306:

Line 2309: hr_transaction_api.get_varchar2_value

2305: --
2306:
2307:
2308: p_add_information17 :=
2309: hr_transaction_api.get_varchar2_value
2310: (p_transaction_step_id => p_transaction_step_id
2311: ,p_name => 'P_ADD_INFORMATION17');
2312: --
2313:

Line 2316: hr_transaction_api.get_varchar2_value

2312: --
2313:
2314: --
2315: p_add_information18 :=
2316: hr_transaction_api.get_varchar2_value
2317: (p_transaction_step_id => p_transaction_step_id
2318: ,p_name => 'P_ADD_INFORMATION18');
2319: --
2320: --

Line 2322: hr_transaction_api.get_varchar2_value

2318: ,p_name => 'P_ADD_INFORMATION18');
2319: --
2320: --
2321: p_add_information19 :=
2322: hr_transaction_api.get_varchar2_value
2323: (p_transaction_step_id => p_transaction_step_id
2324: ,p_name => 'P_ADD_INFORMATION19');
2325: --
2326: --

Line 2328: hr_transaction_api.get_varchar2_value

2324: ,p_name => 'P_ADD_INFORMATION19');
2325: --
2326: --
2327: p_add_information20 :=
2328: hr_transaction_api.get_varchar2_value
2329: (p_transaction_step_id => p_transaction_step_id
2330: ,p_name => 'P_ADD_INFORMATION20');
2331: --
2332: --

Line 2334: hr_transaction_api.get_varchar2_value

2330: ,p_name => 'P_ADD_INFORMATION20');
2331: --
2332: --
2333: p_action :=
2334: hr_transaction_api.get_varchar2_value
2335: (p_transaction_step_id => p_transaction_step_id
2336: ,p_name => 'P_ACTION');
2337: --
2338: p_old_address_id := hr_transaction_api.get_number_value

Line 2338: p_old_address_id := hr_transaction_api.get_number_value

2334: hr_transaction_api.get_varchar2_value
2335: (p_transaction_step_id => p_transaction_step_id
2336: ,p_name => 'P_ACTION');
2337: --
2338: p_old_address_id := hr_transaction_api.get_number_value
2339: (p_transaction_step_id => p_transaction_step_id
2340: ,p_name => 'P_OLD_ADDRESS_ID');
2341:
2342: p_add_information13 :=

Line 2343: hr_transaction_api.get_varchar2_value

2339: (p_transaction_step_id => p_transaction_step_id
2340: ,p_name => 'P_OLD_ADDRESS_ID');
2341:
2342: p_add_information13 :=
2343: hr_transaction_api.get_varchar2_value
2344: (p_transaction_step_id => p_transaction_step_id
2345: ,p_name => 'P_ADD_INFORMATION13');
2346: --
2347: p_add_information14 :=

Line 2348: hr_transaction_api.get_varchar2_value

2344: (p_transaction_step_id => p_transaction_step_id
2345: ,p_name => 'P_ADD_INFORMATION13');
2346: --
2347: p_add_information14 :=
2348: hr_transaction_api.get_varchar2_value
2349: (p_transaction_step_id => p_transaction_step_id
2350: ,p_name => 'P_ADD_INFORMATION14');
2351: --
2352: p_add_information15 :=

Line 2353: hr_transaction_api.get_varchar2_value

2349: (p_transaction_step_id => p_transaction_step_id
2350: ,p_name => 'P_ADD_INFORMATION14');
2351: --
2352: p_add_information15 :=
2353: hr_transaction_api.get_varchar2_value
2354: (p_transaction_step_id => p_transaction_step_id
2355: ,p_name => 'P_ADD_INFORMATION15');
2356: --
2357: p_add_information16 :=

Line 2358: hr_transaction_api.get_varchar2_value

2354: (p_transaction_step_id => p_transaction_step_id
2355: ,p_name => 'P_ADD_INFORMATION15');
2356: --
2357: p_add_information16 :=
2358: hr_transaction_api.get_varchar2_value
2359: (p_transaction_step_id => p_transaction_step_id
2360: ,p_name => 'P_ADD_INFORMATION16');
2361: --
2362:

Line 2477: hr_transaction_api.get_number_value

2473: -- commenting the method call
2474: -- l_user_date_format := hr_util_misc_web.get_user_date_format;
2475:
2476: l_address.object_version_number :=
2477: hr_transaction_api.get_number_value
2478: (p_Transaction_step_id => p_transaction_step_id
2479: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2480:
2481: l_old_ovn :=

Line 2482: hr_transaction_api.get_number_value

2478: (p_Transaction_step_id => p_transaction_step_id
2479: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2480:
2481: l_old_ovn :=
2482: hr_transaction_api.get_number_value
2483: (p_Transaction_step_id => p_transaction_step_id
2484: ,p_name => 'P_OLD_OBJECT_VERSION_NUMBER');
2485:
2486: l_Address.address_id :=

Line 2487: hr_transaction_api.get_number_value

2483: (p_Transaction_step_id => p_transaction_step_id
2484: ,p_name => 'P_OLD_OBJECT_VERSION_NUMBER');
2485:
2486: l_Address.address_id :=
2487: hr_transaction_api.get_number_value
2488: (p_Transaction_step_id => p_transaction_step_id
2489: ,p_name => 'P_ADDRESS_ID');
2490:
2491: l_old_address_id :=

Line 2492: hr_transaction_api.get_number_value

2488: (p_Transaction_step_id => p_transaction_step_id
2489: ,p_name => 'P_ADDRESS_ID');
2490:
2491: l_old_address_id :=
2492: hr_transaction_api.get_number_value
2493: (p_Transaction_step_id => p_transaction_step_id
2494: ,p_name => 'P_OLD_ADDRESS_ID');
2495:
2496: l_action :=

Line 2497: hr_transaction_api.get_varchar2_value

2493: (p_Transaction_step_id => p_transaction_step_id
2494: ,p_name => 'P_OLD_ADDRESS_ID');
2495:
2496: l_action :=
2497: hr_transaction_api.get_varchar2_value
2498: (p_Transaction_step_id => p_transaction_step_id
2499: ,p_name => 'P_ACTION');
2500:
2501: IF hr_transaction_api.get_varchar2_value

Line 2501: IF hr_transaction_api.get_varchar2_value

2497: hr_transaction_api.get_varchar2_value
2498: (p_Transaction_step_id => p_transaction_step_id
2499: ,p_name => 'P_ACTION');
2500:
2501: IF hr_transaction_api.get_varchar2_value
2502: (p_Transaction_step_id => p_transaction_step_id
2503: ,p_name => 'P_PRADD_OVLAPVAL_OVERRIDE') = 'Y' THEN
2504: hr_utility.set_location( l_proc, 20);
2505: l_pradd_ovrlap := TRUE;

Line 2513: (hr_transaction_api.get_date_value

2509: END IF;
2510:
2511:
2512: l_address.date_from :=
2513: (hr_transaction_api.get_date_value
2514: (p_Transaction_step_id => p_transaction_step_id
2515: ,p_name => 'P_DATE_FROM'));
2516:
2517: l_address.date_to :=

Line 2518: (hr_transaction_api.get_date_value

2514: (p_Transaction_step_id => p_transaction_step_id
2515: ,p_name => 'P_DATE_FROM'));
2516:
2517: l_address.date_to :=
2518: (hr_transaction_api.get_date_value
2519: (p_Transaction_step_id => p_transaction_step_id
2520: ,p_name => 'P_DATE_TO'));
2521:
2522: l_address.person_id :=

Line 2523: hr_transaction_api.get_number_value

2519: (p_Transaction_step_id => p_transaction_step_id
2520: ,p_name => 'P_DATE_TO'));
2521:
2522: l_address.person_id :=
2523: hr_transaction_api.get_number_value
2524: (p_Transaction_step_id =>
2525: p_transaction_step_id
2526: ,p_name => 'P_PERSON_ID');
2527: --

Line 2540: hr_transaction_api.get_varchar2_value

2536: --
2537: -- StartRegistration
2538: --
2539: l_contact_or_person :=
2540: hr_transaction_api.get_varchar2_value
2541: (p_Transaction_step_id => p_transaction_step_id
2542: ,p_name => 'P_CONTACT_OR_PERSON');
2543: --
2544: if l_contact_or_person = 'CONTACT' or l_contact_or_person = 'EMER_CR_NEW_CONT' or l_contact_or_person = 'EMRG_OVRW_UPD' or l_contact_or_person = 'EMRG_OVRW_DEL' or l_contact_or_person = 'EMER_CR_NEW_REL'

Line 2621: hr_transaction_api.get_varchar2_value

2617: --
2618: end if;
2619: --
2620: l_address.primary_flag :=
2621: hr_transaction_api.get_varchar2_value
2622: (p_Transaction_step_id => p_transaction_step_id
2623: ,p_name => 'P_PRIMARY_FLAG');
2624: -- startregistration anupam
2625: -- For tertiary address from overview page we have T for primary flag

Line 2635: hr_transaction_api.get_varchar2_value

2631: -- endregistration anupam
2632:
2633:
2634: l_Address.style :=
2635: hr_transaction_api.get_varchar2_value
2636: (p_Transaction_step_id => p_transaction_step_id
2637: ,p_name => 'P_STYLE');
2638: l_address.address_type :=
2639: hr_transaction_api.get_varchar2_value

Line 2639: hr_transaction_api.get_varchar2_value

2635: hr_transaction_api.get_varchar2_value
2636: (p_Transaction_step_id => p_transaction_step_id
2637: ,p_name => 'P_STYLE');
2638: l_address.address_type :=
2639: hr_transaction_api.get_varchar2_value
2640: (p_Transaction_step_id => p_transaction_step_id
2641: ,p_name => 'P_ADDRESS_TYPE_CODE');
2642: l_Address.address_line1 :=
2643: hr_transaction_api.get_varchar2_value

Line 2643: hr_transaction_api.get_varchar2_value

2639: hr_transaction_api.get_varchar2_value
2640: (p_Transaction_step_id => p_transaction_step_id
2641: ,p_name => 'P_ADDRESS_TYPE_CODE');
2642: l_Address.address_line1 :=
2643: hr_transaction_api.get_varchar2_value
2644: (p_Transaction_step_id => p_transaction_step_id
2645: ,p_name => 'P_ADDRESS_LINE1');
2646: l_Address.address_line2 :=
2647: hr_transaction_api.get_varchar2_value

Line 2647: hr_transaction_api.get_varchar2_value

2643: hr_transaction_api.get_varchar2_value
2644: (p_Transaction_step_id => p_transaction_step_id
2645: ,p_name => 'P_ADDRESS_LINE1');
2646: l_Address.address_line2 :=
2647: hr_transaction_api.get_varchar2_value
2648: (p_Transaction_step_id => p_transaction_step_id
2649: ,p_name => 'P_ADDRESS_LINE2');
2650: l_Address.address_line3 :=
2651: hr_transaction_api.get_varchar2_value

Line 2651: hr_transaction_api.get_varchar2_value

2647: hr_transaction_api.get_varchar2_value
2648: (p_Transaction_step_id => p_transaction_step_id
2649: ,p_name => 'P_ADDRESS_LINE2');
2650: l_Address.address_line3 :=
2651: hr_transaction_api.get_varchar2_value
2652: (p_Transaction_step_id => p_transaction_step_id
2653: ,p_name => 'P_ADDRESS_LINE3');
2654: l_address.town_or_city :=
2655: hr_transaction_api.get_varchar2_value

Line 2655: hr_transaction_api.get_varchar2_value

2651: hr_transaction_api.get_varchar2_value
2652: (p_Transaction_step_id => p_transaction_step_id
2653: ,p_name => 'P_ADDRESS_LINE3');
2654: l_address.town_or_city :=
2655: hr_transaction_api.get_varchar2_value
2656: (p_Transaction_step_id => p_transaction_step_id
2657: ,p_name => 'P_CITY');
2658: l_address.region_1 :=
2659: hr_transaction_api.get_varchar2_value

Line 2659: hr_transaction_api.get_varchar2_value

2655: hr_transaction_api.get_varchar2_value
2656: (p_Transaction_step_id => p_transaction_step_id
2657: ,p_name => 'P_CITY');
2658: l_address.region_1 :=
2659: hr_transaction_api.get_varchar2_value
2660: (p_Transaction_step_id => p_transaction_step_id
2661: ,p_name => 'P_REGION1');
2662: l_address.region_2 :=
2663: hr_transaction_api.get_varchar2_value

Line 2663: hr_transaction_api.get_varchar2_value

2659: hr_transaction_api.get_varchar2_value
2660: (p_Transaction_step_id => p_transaction_step_id
2661: ,p_name => 'P_REGION1');
2662: l_address.region_2 :=
2663: hr_transaction_api.get_varchar2_value
2664: (p_Transaction_step_id => p_transaction_step_id
2665: ,p_name => 'P_REGION2');
2666: l_address.region_3 :=
2667: hr_transaction_api.get_varchar2_value

Line 2667: hr_transaction_api.get_varchar2_value

2663: hr_transaction_api.get_varchar2_value
2664: (p_Transaction_step_id => p_transaction_step_id
2665: ,p_name => 'P_REGION2');
2666: l_address.region_3 :=
2667: hr_transaction_api.get_varchar2_value
2668: (p_Transaction_step_id => p_transaction_step_id
2669: ,p_name => 'P_REGION3');
2670: l_address.postal_code :=
2671: hr_transaction_api.get_varchar2_value

Line 2671: hr_transaction_api.get_varchar2_value

2667: hr_transaction_api.get_varchar2_value
2668: (p_Transaction_step_id => p_transaction_step_id
2669: ,p_name => 'P_REGION3');
2670: l_address.postal_code :=
2671: hr_transaction_api.get_varchar2_value
2672: (p_Transaction_step_id => p_transaction_step_id
2673: ,p_name => 'P_POSTAL_CODE');
2674: l_address.country :=
2675: hr_transaction_api.get_varchar2_value

Line 2675: hr_transaction_api.get_varchar2_value

2671: hr_transaction_api.get_varchar2_value
2672: (p_Transaction_step_id => p_transaction_step_id
2673: ,p_name => 'P_POSTAL_CODE');
2674: l_address.country :=
2675: hr_transaction_api.get_varchar2_value
2676: (p_Transaction_step_id => p_transaction_step_id
2677: ,p_name => 'P_COUNTRY_CODE');
2678: l_address.telephone_number_1 :=
2679: hr_transaction_api.get_varchar2_value

Line 2679: hr_transaction_api.get_varchar2_value

2675: hr_transaction_api.get_varchar2_value
2676: (p_Transaction_step_id => p_transaction_step_id
2677: ,p_name => 'P_COUNTRY_CODE');
2678: l_address.telephone_number_1 :=
2679: hr_transaction_api.get_varchar2_value
2680: (p_Transaction_step_id => p_transaction_step_id
2681: ,p_name => 'P_TELEPHONE_NUMBER1');
2682: l_address.telephone_number_2 :=
2683: hr_transaction_api.get_varchar2_value

Line 2683: hr_transaction_api.get_varchar2_value

2679: hr_transaction_api.get_varchar2_value
2680: (p_Transaction_step_id => p_transaction_step_id
2681: ,p_name => 'P_TELEPHONE_NUMBER1');
2682: l_address.telephone_number_2 :=
2683: hr_transaction_api.get_varchar2_value
2684: (p_Transaction_step_id => p_transaction_step_id
2685: ,p_name => 'P_TELEPHONE_NUMBER2');
2686: l_address.telephone_number_3 :=
2687: hr_transaction_api.get_varchar2_value

Line 2687: hr_transaction_api.get_varchar2_value

2683: hr_transaction_api.get_varchar2_value
2684: (p_Transaction_step_id => p_transaction_step_id
2685: ,p_name => 'P_TELEPHONE_NUMBER2');
2686: l_address.telephone_number_3 :=
2687: hr_transaction_api.get_varchar2_value
2688: (p_Transaction_step_id => p_transaction_step_id
2689: ,p_name => 'P_TELEPHONE_NUMBER3');
2690:
2691: -- Now get all the Descriptive Flex fields

Line 2693: hr_transaction_api.get_varchar2_value

2689: ,p_name => 'P_TELEPHONE_NUMBER3');
2690:
2691: -- Now get all the Descriptive Flex fields
2692: l_address.addr_attribute_category :=
2693: hr_transaction_api.get_varchar2_value
2694: (p_Transaction_step_id => p_transaction_step_id
2695: ,p_name => 'P_ADDR_ATTRIBUTE_CATEGORY');
2696: l_address.addr_attribute1 :=
2697: hr_transaction_api.get_varchar2_value

Line 2697: hr_transaction_api.get_varchar2_value

2693: hr_transaction_api.get_varchar2_value
2694: (p_Transaction_step_id => p_transaction_step_id
2695: ,p_name => 'P_ADDR_ATTRIBUTE_CATEGORY');
2696: l_address.addr_attribute1 :=
2697: hr_transaction_api.get_varchar2_value
2698: (p_Transaction_step_id => p_transaction_step_id
2699: ,p_name => 'P_ADDR_ATTRIBUTE1');
2700: l_address.addr_attribute2 :=
2701: hr_transaction_api.get_varchar2_value

Line 2701: hr_transaction_api.get_varchar2_value

2697: hr_transaction_api.get_varchar2_value
2698: (p_Transaction_step_id => p_transaction_step_id
2699: ,p_name => 'P_ADDR_ATTRIBUTE1');
2700: l_address.addr_attribute2 :=
2701: hr_transaction_api.get_varchar2_value
2702: (p_Transaction_step_id => p_transaction_step_id
2703: ,p_name => 'P_ADDR_ATTRIBUTE2');
2704: l_address.addr_attribute3 :=
2705: hr_transaction_api.get_varchar2_value

Line 2705: hr_transaction_api.get_varchar2_value

2701: hr_transaction_api.get_varchar2_value
2702: (p_Transaction_step_id => p_transaction_step_id
2703: ,p_name => 'P_ADDR_ATTRIBUTE2');
2704: l_address.addr_attribute3 :=
2705: hr_transaction_api.get_varchar2_value
2706: (p_Transaction_step_id => p_transaction_step_id
2707: ,p_name => 'P_ADDR_ATTRIBUTE3');
2708: l_address.addr_attribute4 :=
2709: hr_transaction_api.get_varchar2_value

Line 2709: hr_transaction_api.get_varchar2_value

2705: hr_transaction_api.get_varchar2_value
2706: (p_Transaction_step_id => p_transaction_step_id
2707: ,p_name => 'P_ADDR_ATTRIBUTE3');
2708: l_address.addr_attribute4 :=
2709: hr_transaction_api.get_varchar2_value
2710: (p_Transaction_step_id => p_transaction_step_id
2711: ,p_name => 'P_ADDR_ATTRIBUTE4');
2712: l_address.addr_attribute5 :=
2713: hr_transaction_api.get_varchar2_value

Line 2713: hr_transaction_api.get_varchar2_value

2709: hr_transaction_api.get_varchar2_value
2710: (p_Transaction_step_id => p_transaction_step_id
2711: ,p_name => 'P_ADDR_ATTRIBUTE4');
2712: l_address.addr_attribute5 :=
2713: hr_transaction_api.get_varchar2_value
2714: (p_Transaction_step_id => p_transaction_step_id
2715: ,p_name => 'P_ADDR_ATTRIBUTE5');
2716: l_address.addr_attribute6 :=
2717: hr_transaction_api.get_varchar2_value

Line 2717: hr_transaction_api.get_varchar2_value

2713: hr_transaction_api.get_varchar2_value
2714: (p_Transaction_step_id => p_transaction_step_id
2715: ,p_name => 'P_ADDR_ATTRIBUTE5');
2716: l_address.addr_attribute6 :=
2717: hr_transaction_api.get_varchar2_value
2718: (p_Transaction_step_id => p_transaction_step_id
2719: ,p_name => 'P_ADDR_ATTRIBUTE6');
2720: l_address.addr_attribute7 :=
2721: hr_transaction_api.get_varchar2_value

Line 2721: hr_transaction_api.get_varchar2_value

2717: hr_transaction_api.get_varchar2_value
2718: (p_Transaction_step_id => p_transaction_step_id
2719: ,p_name => 'P_ADDR_ATTRIBUTE6');
2720: l_address.addr_attribute7 :=
2721: hr_transaction_api.get_varchar2_value
2722: (p_Transaction_step_id => p_transaction_step_id
2723: ,p_name => 'P_ADDR_ATTRIBUTE7');
2724: l_address.addr_attribute8 :=
2725: hr_transaction_api.get_varchar2_value

Line 2725: hr_transaction_api.get_varchar2_value

2721: hr_transaction_api.get_varchar2_value
2722: (p_Transaction_step_id => p_transaction_step_id
2723: ,p_name => 'P_ADDR_ATTRIBUTE7');
2724: l_address.addr_attribute8 :=
2725: hr_transaction_api.get_varchar2_value
2726: (p_Transaction_step_id => p_transaction_step_id
2727: ,p_name => 'P_ADDR_ATTRIBUTE8');
2728: l_address.addr_attribute9 :=
2729: hr_transaction_api.get_varchar2_value

Line 2729: hr_transaction_api.get_varchar2_value

2725: hr_transaction_api.get_varchar2_value
2726: (p_Transaction_step_id => p_transaction_step_id
2727: ,p_name => 'P_ADDR_ATTRIBUTE8');
2728: l_address.addr_attribute9 :=
2729: hr_transaction_api.get_varchar2_value
2730: (p_Transaction_step_id => p_transaction_step_id
2731: ,p_name => 'P_ADDR_ATTRIBUTE9');
2732: l_address.addr_attribute10 :=
2733: hr_transaction_api.get_varchar2_value

Line 2733: hr_transaction_api.get_varchar2_value

2729: hr_transaction_api.get_varchar2_value
2730: (p_Transaction_step_id => p_transaction_step_id
2731: ,p_name => 'P_ADDR_ATTRIBUTE9');
2732: l_address.addr_attribute10 :=
2733: hr_transaction_api.get_varchar2_value
2734: (p_Transaction_step_id => p_transaction_step_id
2735: ,p_name => 'P_ADDR_ATTRIBUTE10');
2736: l_address.addr_attribute11 :=
2737: hr_transaction_api.get_varchar2_value

Line 2737: hr_transaction_api.get_varchar2_value

2733: hr_transaction_api.get_varchar2_value
2734: (p_Transaction_step_id => p_transaction_step_id
2735: ,p_name => 'P_ADDR_ATTRIBUTE10');
2736: l_address.addr_attribute11 :=
2737: hr_transaction_api.get_varchar2_value
2738: (p_Transaction_step_id => p_transaction_step_id
2739: ,p_name => 'P_ADDR_ATTRIBUTE11');
2740: l_address.addr_attribute12 :=
2741: hr_transaction_api.get_varchar2_value

Line 2741: hr_transaction_api.get_varchar2_value

2737: hr_transaction_api.get_varchar2_value
2738: (p_Transaction_step_id => p_transaction_step_id
2739: ,p_name => 'P_ADDR_ATTRIBUTE11');
2740: l_address.addr_attribute12 :=
2741: hr_transaction_api.get_varchar2_value
2742: (p_Transaction_step_id => p_transaction_step_id
2743: ,p_name => 'P_ADDR_ATTRIBUTE12');
2744: l_address.addr_attribute13 :=
2745: hr_transaction_api.get_varchar2_value

Line 2745: hr_transaction_api.get_varchar2_value

2741: hr_transaction_api.get_varchar2_value
2742: (p_Transaction_step_id => p_transaction_step_id
2743: ,p_name => 'P_ADDR_ATTRIBUTE12');
2744: l_address.addr_attribute13 :=
2745: hr_transaction_api.get_varchar2_value
2746: (p_Transaction_step_id => p_transaction_step_id
2747: ,p_name => 'P_ADDR_ATTRIBUTE13');
2748: l_address.addr_attribute14 :=
2749: hr_transaction_api.get_varchar2_value

Line 2749: hr_transaction_api.get_varchar2_value

2745: hr_transaction_api.get_varchar2_value
2746: (p_Transaction_step_id => p_transaction_step_id
2747: ,p_name => 'P_ADDR_ATTRIBUTE13');
2748: l_address.addr_attribute14 :=
2749: hr_transaction_api.get_varchar2_value
2750: (p_Transaction_step_id => p_transaction_step_id
2751: ,p_name => 'P_ADDR_ATTRIBUTE14');
2752: l_address.addr_attribute15 :=
2753: hr_transaction_api.get_varchar2_value

Line 2753: hr_transaction_api.get_varchar2_value

2749: hr_transaction_api.get_varchar2_value
2750: (p_Transaction_step_id => p_transaction_step_id
2751: ,p_name => 'P_ADDR_ATTRIBUTE14');
2752: l_address.addr_attribute15 :=
2753: hr_transaction_api.get_varchar2_value
2754: (p_Transaction_step_id => p_transaction_step_id
2755: ,p_name => 'P_ADDR_ATTRIBUTE15');
2756: l_address.addr_attribute16 :=
2757: hr_transaction_api.get_varchar2_value

Line 2757: hr_transaction_api.get_varchar2_value

2753: hr_transaction_api.get_varchar2_value
2754: (p_Transaction_step_id => p_transaction_step_id
2755: ,p_name => 'P_ADDR_ATTRIBUTE15');
2756: l_address.addr_attribute16 :=
2757: hr_transaction_api.get_varchar2_value
2758: (p_Transaction_step_id => p_transaction_step_id
2759: ,p_name => 'P_ADDR_ATTRIBUTE16');
2760: l_address.addr_attribute17 :=
2761: hr_transaction_api.get_varchar2_value

Line 2761: hr_transaction_api.get_varchar2_value

2757: hr_transaction_api.get_varchar2_value
2758: (p_Transaction_step_id => p_transaction_step_id
2759: ,p_name => 'P_ADDR_ATTRIBUTE16');
2760: l_address.addr_attribute17 :=
2761: hr_transaction_api.get_varchar2_value
2762: (p_Transaction_step_id => p_transaction_step_id
2763: ,p_name => 'P_ADDR_ATTRIBUTE17');
2764: l_address.addr_attribute18 :=
2765: hr_transaction_api.get_varchar2_value

Line 2765: hr_transaction_api.get_varchar2_value

2761: hr_transaction_api.get_varchar2_value
2762: (p_Transaction_step_id => p_transaction_step_id
2763: ,p_name => 'P_ADDR_ATTRIBUTE17');
2764: l_address.addr_attribute18 :=
2765: hr_transaction_api.get_varchar2_value
2766: (p_Transaction_step_id => p_transaction_step_id
2767: ,p_name => 'P_ADDR_ATTRIBUTE18');
2768: l_address.addr_attribute19 :=
2769: hr_transaction_api.get_varchar2_value

Line 2769: hr_transaction_api.get_varchar2_value

2765: hr_transaction_api.get_varchar2_value
2766: (p_Transaction_step_id => p_transaction_step_id
2767: ,p_name => 'P_ADDR_ATTRIBUTE18');
2768: l_address.addr_attribute19 :=
2769: hr_transaction_api.get_varchar2_value
2770: (p_Transaction_step_id => p_transaction_step_id
2771: ,p_name => 'P_ADDR_ATTRIBUTE19');
2772: l_address.addr_attribute20 :=
2773: hr_transaction_api.get_varchar2_value

Line 2773: hr_transaction_api.get_varchar2_value

2769: hr_transaction_api.get_varchar2_value
2770: (p_Transaction_step_id => p_transaction_step_id
2771: ,p_name => 'P_ADDR_ATTRIBUTE19');
2772: l_address.addr_attribute20 :=
2773: hr_transaction_api.get_varchar2_value
2774: (p_Transaction_step_id => p_transaction_step_id
2775: ,p_name => 'P_ADDR_ATTRIBUTE20');
2776: l_address.add_information17 :=
2777: hr_transaction_api.get_varchar2_value

Line 2777: hr_transaction_api.get_varchar2_value

2773: hr_transaction_api.get_varchar2_value
2774: (p_Transaction_step_id => p_transaction_step_id
2775: ,p_name => 'P_ADDR_ATTRIBUTE20');
2776: l_address.add_information17 :=
2777: hr_transaction_api.get_varchar2_value
2778: (p_Transaction_step_id => p_transaction_step_id
2779: ,p_name => 'P_ADD_INFORMATION17');
2780: l_address.add_information18 :=
2781: hr_transaction_api.get_varchar2_value

Line 2781: hr_transaction_api.get_varchar2_value

2777: hr_transaction_api.get_varchar2_value
2778: (p_Transaction_step_id => p_transaction_step_id
2779: ,p_name => 'P_ADD_INFORMATION17');
2780: l_address.add_information18 :=
2781: hr_transaction_api.get_varchar2_value
2782: (p_Transaction_step_id => p_transaction_step_id
2783: ,p_name => 'P_ADD_INFORMATION18');
2784: l_address.add_information19 :=
2785: hr_transaction_api.get_varchar2_value

Line 2785: hr_transaction_api.get_varchar2_value

2781: hr_transaction_api.get_varchar2_value
2782: (p_Transaction_step_id => p_transaction_step_id
2783: ,p_name => 'P_ADD_INFORMATION18');
2784: l_address.add_information19 :=
2785: hr_transaction_api.get_varchar2_value
2786: (p_Transaction_step_id => p_transaction_step_id
2787: ,p_name => 'P_ADD_INFORMATION19');
2788: l_address.add_information20 :=
2789: hr_transaction_api.get_varchar2_value

Line 2789: hr_transaction_api.get_varchar2_value

2785: hr_transaction_api.get_varchar2_value
2786: (p_Transaction_step_id => p_transaction_step_id
2787: ,p_name => 'P_ADD_INFORMATION19');
2788: l_address.add_information20 :=
2789: hr_transaction_api.get_varchar2_value
2790: (p_Transaction_step_id => p_transaction_step_id
2791: ,p_name => 'P_ADD_INFORMATION20');
2792: l_address.add_information13 :=
2793: hr_transaction_api.get_varchar2_value

Line 2793: hr_transaction_api.get_varchar2_value

2789: hr_transaction_api.get_varchar2_value
2790: (p_Transaction_step_id => p_transaction_step_id
2791: ,p_name => 'P_ADD_INFORMATION20');
2792: l_address.add_information13 :=
2793: hr_transaction_api.get_varchar2_value
2794: (p_Transaction_step_id => p_transaction_step_id
2795: ,p_name => 'P_ADD_INFORMATION13');
2796: l_address.add_information14 :=
2797: hr_transaction_api.get_varchar2_value

Line 2797: hr_transaction_api.get_varchar2_value

2793: hr_transaction_api.get_varchar2_value
2794: (p_Transaction_step_id => p_transaction_step_id
2795: ,p_name => 'P_ADD_INFORMATION13');
2796: l_address.add_information14 :=
2797: hr_transaction_api.get_varchar2_value
2798: (p_Transaction_step_id => p_transaction_step_id
2799: ,p_name => 'P_ADD_INFORMATION14');
2800: l_address.add_information15 :=
2801: hr_transaction_api.get_varchar2_value

Line 2801: hr_transaction_api.get_varchar2_value

2797: hr_transaction_api.get_varchar2_value
2798: (p_Transaction_step_id => p_transaction_step_id
2799: ,p_name => 'P_ADD_INFORMATION14');
2800: l_address.add_information15 :=
2801: hr_transaction_api.get_varchar2_value
2802: (p_Transaction_step_id => p_transaction_step_id
2803: ,p_name => 'P_ADD_INFORMATION15');
2804: l_address.add_information16 :=
2805: hr_transaction_api.get_varchar2_value

Line 2805: hr_transaction_api.get_varchar2_value

2801: hr_transaction_api.get_varchar2_value
2802: (p_Transaction_step_id => p_transaction_step_id
2803: ,p_name => 'P_ADD_INFORMATION15');
2804: l_address.add_information16 :=
2805: hr_transaction_api.get_varchar2_value
2806: (p_Transaction_step_id => p_transaction_step_id
2807: ,p_name => 'P_ADD_INFORMATION16');
2808:
2809: