APPS.HR_ORG_INFORMATION_TYPES_PKG dependencies on FND_APPLICATION

Line 11: from FND_APPLICATION

7: cursor CSR_APPLICATION (
8: X_APPLICATION_SHORT_NAME in VARCHAR2
9: ) is
10: select APPLICATION_ID
11: from FND_APPLICATION
12: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
13: X_APPLICATION CSR_APPLICATION%rowtype;
14: begin
15: open CSR_APPLICATION(X_APPLICATION_SHORT_NAME);

Line 47: X_FND_APPLICATION_ID in NUMBER,

43: X_ORG_INFORMATION_TYPE in VARCHAR2,
44: X_DESTINATION in VARCHAR2,
45: X_LEGISLATION_CODE in VARCHAR2,
46: X_NAVIGATION_METHOD in VARCHAR2,
47: X_FND_APPLICATION_ID in NUMBER,
48: X_DESCRIPTION in VARCHAR2,
49: X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2,
50: X_CREATION_DATE in DATE,
51: X_CREATED_BY in NUMBER,

Line 62: FND_APPLICATION_ID,

58: ORG_INFORMATION_TYPE,
59: DESTINATION,
60: LEGISLATION_CODE,
61: NAVIGATION_METHOD,
62: FND_APPLICATION_ID,
63: DESCRIPTION,
64: DISPLAYED_ORG_INFORMATION_TYPE,
65: CREATION_DATE,
66: CREATED_BY,

Line 75: X_FND_APPLICATION_ID,

71: X_ORG_INFORMATION_TYPE,
72: X_DESTINATION,
73: X_LEGISLATION_CODE,
74: X_NAVIGATION_METHOD,
75: X_FND_APPLICATION_ID,
76: X_DESCRIPTION,
77: X_DISPLAYED_ORG_INFORMATION_TP,
78: X_CREATION_DATE,
79: X_CREATED_BY,

Line 120: X_FND_APPLICATION_ID in NUMBER,

116: X_ORG_INFORMATION_TYPE in VARCHAR2,
117: X_DESTINATION in VARCHAR2,
118: X_LEGISLATION_CODE in VARCHAR2,
119: X_NAVIGATION_METHOD in VARCHAR2,
120: X_FND_APPLICATION_ID in NUMBER,
121: X_DESCRIPTION in VARCHAR2,
122: X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2
123: ) is
124: cursor CSR_ORG_INFORMATION_TYPE (

Line 130: ,FND_APPLICATION_ID

126: ) is
127: select DESTINATION
128: ,LEGISLATION_CODE
129: ,NAVIGATION_METHOD
130: ,FND_APPLICATION_ID
131: ,DESCRIPTION
132: from HR_ORG_INFORMATION_TYPES
133: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
134: for update of ORG_INFORMATION_TYPE nowait;

Line 192: X_FND_APPLICATION_ID in NUMBER,

188: X_ORG_INFORMATION_TYPE in VARCHAR2,
189: X_DESTINATION in VARCHAR2,
190: X_LEGISLATION_CODE in VARCHAR2,
191: X_NAVIGATION_METHOD in VARCHAR2,
192: X_FND_APPLICATION_ID in NUMBER,
193: X_DESCRIPTION in VARCHAR2,
194: X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2,
195: X_LAST_UPDATE_DATE in DATE,
196: X_LAST_UPDATED_BY in NUMBER,

Line 204: FND_APPLICATION_ID = X_FND_APPLICATION_ID,

200: update HR_ORG_INFORMATION_TYPES set
201: DESTINATION = X_DESTINATION,
202: LEGISLATION_CODE = X_LEGISLATION_CODE,
203: NAVIGATION_METHOD = X_NAVIGATION_METHOD,
204: FND_APPLICATION_ID = X_FND_APPLICATION_ID,
205: DESCRIPTION = X_DESCRIPTION,
206: DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,