DBA Data[Home] [Help]

PACKAGE: APPS.HRDPP_UPDATE_LOCATION

Source


1 package hrdpp_UPDATE_LOCATION as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2007/01/03 23:01:44
4  * Generated for API: HR_LOCATION_API.UPDATE_LOCATION
5  */
6 --
7 g_generator_version constant varchar2(128) default '$Revision: 120.4  $';
8 --
9 
10 function dc(p in date) return varchar2;
11 pragma restrict_references(dc,WNDS);
12 
13 function d(p in varchar2) return date;
14 pragma restrict_references(d,WNDS);
15 function n(p in varchar2) return number;
16 pragma restrict_references(n,WNDS);
17 function dd(p in date,i in varchar2) return varchar2;
18 pragma restrict_references(dd,WNDS);
19 function nd(p in number,i in varchar2) return varchar2;
20 pragma restrict_references(nd,WNDS);
21 --
22 procedure insert_batch_lines
23 (p_batch_id      in number
24 ,p_data_pump_batch_line_id in number default null
25 ,p_data_pump_business_grp_name in varchar2 default null
26 ,p_user_sequence in number default null
27 ,p_link_value    in number default null
28 ,P_EFFECTIVE_DATE in date
29 ,P_LANGUAGE_CODE in varchar2
30 ,P_LOCATION_CODE in varchar2
31 ,P_DESCRIPTION in varchar2 default null
32 ,P_TIMEZONE_CODE in varchar2 default null
33 ,P_TP_HEADER_ID in number default null
34 ,I_TP_HEADER_ID in varchar2 default 'N'
35 ,P_ECE_TP_LOCATION_CODE in varchar2 default null
36 ,P_ADDRESS_LINE_1 in varchar2 default null
37 ,P_ADDRESS_LINE_2 in varchar2 default null
38 ,P_ADDRESS_LINE_3 in varchar2 default null
39 ,P_BILL_TO_SITE_FLAG in varchar2 default null
40 ,P_COUNTRY in varchar2 default null
41 ,P_IN_ORGANIZATION_FLAG in varchar2 default null
42 ,P_INACTIVE_DATE in date default null
43 ,I_INACTIVE_DATE in varchar2 default 'N'
44 ,P_OPERATING_UNIT_ID in number default null
45 ,I_OPERATING_UNIT_ID in varchar2 default 'N'
46 ,P_INVENTORY_ORGANIZATION_ID in number default null
47 ,I_INVENTORY_ORGANIZATION_ID in varchar2 default 'N'
48 ,P_OFFICE_SITE_FLAG in varchar2 default null
49 ,P_POSTAL_CODE in varchar2 default null
50 ,P_RECEIVING_SITE_FLAG in varchar2 default null
51 ,P_REGION_1 in varchar2 default null
52 ,P_REGION_2 in varchar2 default null
53 ,P_REGION_3 in varchar2 default null
54 ,P_SHIP_TO_SITE_FLAG in varchar2 default null
55 ,P_STYLE in varchar2 default null
56 ,P_TAX_NAME in varchar2 default null
57 ,P_TELEPHONE_NUMBER_1 in varchar2 default null
58 ,P_TELEPHONE_NUMBER_2 in varchar2 default null
59 ,P_TELEPHONE_NUMBER_3 in varchar2 default null
60 ,P_TOWN_OR_CITY in varchar2 default null
61 ,P_LOC_INFORMATION13 in varchar2 default null
62 ,P_LOC_INFORMATION14 in varchar2 default null
63 ,P_LOC_INFORMATION15 in varchar2 default null
64 ,P_LOC_INFORMATION16 in varchar2 default null
65 ,P_LOC_INFORMATION17 in varchar2 default null
66 ,P_LOC_INFORMATION18 in varchar2 default null
67 ,P_LOC_INFORMATION19 in varchar2 default null
68 ,P_LOC_INFORMATION20 in varchar2 default null
69 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
70 ,P_ATTRIBUTE1 in varchar2 default null
71 ,P_ATTRIBUTE2 in varchar2 default null
72 ,P_ATTRIBUTE3 in varchar2 default null
73 ,P_ATTRIBUTE4 in varchar2 default null
74 ,P_ATTRIBUTE5 in varchar2 default null
75 ,P_ATTRIBUTE6 in varchar2 default null
76 ,P_ATTRIBUTE7 in varchar2 default null
77 ,P_ATTRIBUTE8 in varchar2 default null
78 ,P_ATTRIBUTE9 in varchar2 default null
79 ,P_ATTRIBUTE10 in varchar2 default null
80 ,P_ATTRIBUTE11 in varchar2 default null
81 ,P_ATTRIBUTE12 in varchar2 default null
82 ,P_ATTRIBUTE13 in varchar2 default null
83 ,P_ATTRIBUTE14 in varchar2 default null
84 ,P_ATTRIBUTE15 in varchar2 default null
85 ,P_ATTRIBUTE16 in varchar2 default null
86 ,P_ATTRIBUTE17 in varchar2 default null
87 ,P_ATTRIBUTE18 in varchar2 default null
88 ,P_ATTRIBUTE19 in varchar2 default null
89 ,P_ATTRIBUTE20 in varchar2 default null
90 ,P_GLOBAL_ATTRIBUTE_CATEGORY in varchar2 default null
91 ,P_GLOBAL_ATTRIBUTE1 in varchar2 default null
92 ,P_GLOBAL_ATTRIBUTE2 in varchar2 default null
93 ,P_GLOBAL_ATTRIBUTE3 in varchar2 default null
94 ,P_GLOBAL_ATTRIBUTE4 in varchar2 default null
95 ,P_GLOBAL_ATTRIBUTE5 in varchar2 default null
96 ,P_GLOBAL_ATTRIBUTE6 in varchar2 default null
97 ,P_GLOBAL_ATTRIBUTE7 in varchar2 default null
98 ,P_GLOBAL_ATTRIBUTE8 in varchar2 default null
99 ,P_GLOBAL_ATTRIBUTE9 in varchar2 default null
100 ,P_GLOBAL_ATTRIBUTE10 in varchar2 default null
101 ,P_GLOBAL_ATTRIBUTE11 in varchar2 default null
102 ,P_GLOBAL_ATTRIBUTE12 in varchar2 default null
103 ,P_GLOBAL_ATTRIBUTE13 in varchar2 default null
104 ,P_GLOBAL_ATTRIBUTE14 in varchar2 default null
105 ,P_GLOBAL_ATTRIBUTE15 in varchar2 default null
106 ,P_GLOBAL_ATTRIBUTE16 in varchar2 default null
107 ,P_GLOBAL_ATTRIBUTE17 in varchar2 default null
108 ,P_GLOBAL_ATTRIBUTE18 in varchar2 default null
109 ,P_GLOBAL_ATTRIBUTE19 in varchar2 default null
110 ,P_GLOBAL_ATTRIBUTE20 in varchar2 default null
111 ,P_DESIGNATED_RECEIVER_NAME in varchar2 default null
112 ,P_SHIP_TO_LOCATION_CODE in varchar2 default null);
113 --
114 procedure call
115 (p_business_group_id in number,
116 p_batch_line_id     in number);
117 end hrdpp_UPDATE_LOCATION;