APPS.HR_DELIVERY_METHODS_API dependencies on PER_PERSON_DLVRY_METHODS

Line 51: l_delivery_method_id per_person_dlvry_methods.delivery_method_id%TYPE;

47: ) is
48: --
49: -- Declare cursors and local variables
50: --
51: l_delivery_method_id per_person_dlvry_methods.delivery_method_id%TYPE;
52: l_proc varchar2(72) := g_package||'create_delivery_method';
53: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
54: l_effective_date date;
55: --

Line 53: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;

49: -- Declare cursors and local variables
50: --
51: l_delivery_method_id per_person_dlvry_methods.delivery_method_id%TYPE;
52: l_proc varchar2(72) := g_package||'create_delivery_method';
53: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
54: l_effective_date date;
55: --
56: begin
57: --

Line 299: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;

295: --
296: -- Declare cursors and local variables
297: --
298: l_proc varchar2(72) := g_package||'update_delivery_method';
299: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
300: l_ovn per_person_dlvry_methods.object_version_number%TYPE := p_object_version_number;
301: l_effective_date date;
302: --
303: begin

Line 300: l_ovn per_person_dlvry_methods.object_version_number%TYPE := p_object_version_number;

296: -- Declare cursors and local variables
297: --
298: l_proc varchar2(72) := g_package||'update_delivery_method';
299: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
300: l_ovn per_person_dlvry_methods.object_version_number%TYPE := p_object_version_number;
301: l_effective_date date;
302: --
303: begin
304: --

Line 504: from PER_PERSON_DLVRY_METHODS

500:
501: -- dparthas
502: CURSOR get_person_info IS
503: select person_id
504: from PER_PERSON_DLVRY_METHODS
505: where DELIVERY_METHOD_ID = p_delivery_method_id ;
506: --dparthas
507: --
508: -- Declare cursors and local variables

Line 511: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;

507: --
508: -- Declare cursors and local variables
509: --
510: l_proc varchar2(72) := g_package||'delete_delivery_method';
511: l_object_version_number per_person_dlvry_methods.object_version_number%TYPE;
512: l_person_id number := -1;
513: --
514: begin
515: --