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 139: X_FND_APPLICATION_ID in NUMBER,

135: X_ORG_INFORMATION_TYPE in VARCHAR2,
136: X_DESTINATION in VARCHAR2,
137: X_LEGISLATION_CODE in VARCHAR2,
138: X_NAVIGATION_METHOD in VARCHAR2,
139: X_FND_APPLICATION_ID in NUMBER,
140: X_DESCRIPTION in VARCHAR2,
141: X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2
142: ) is
143: cursor CSR_ORG_INFORMATION_TYPE (

Line 149: ,FND_APPLICATION_ID

145: ) is
146: select DESTINATION
147: ,LEGISLATION_CODE
148: ,NAVIGATION_METHOD
149: ,FND_APPLICATION_ID
150: ,DESCRIPTION
151: from HR_ORG_INFORMATION_TYPES
152: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
153: for update of ORG_INFORMATION_TYPE nowait;

Line 211: X_FND_APPLICATION_ID in NUMBER,

207: X_ORG_INFORMATION_TYPE in VARCHAR2,
208: X_DESTINATION in VARCHAR2,
209: X_LEGISLATION_CODE in VARCHAR2,
210: X_NAVIGATION_METHOD in VARCHAR2,
211: X_FND_APPLICATION_ID in NUMBER,
212: X_DESCRIPTION in VARCHAR2,
213: X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2,
214: X_LAST_UPDATE_DATE in DATE,
215: X_LAST_UPDATED_BY in NUMBER,

Line 223: FND_APPLICATION_ID = X_FND_APPLICATION_ID,

219: update HR_ORG_INFORMATION_TYPES set
220: DESTINATION = X_DESTINATION,
221: LEGISLATION_CODE = X_LEGISLATION_CODE,
222: NAVIGATION_METHOD = X_NAVIGATION_METHOD,
223: FND_APPLICATION_ID = X_FND_APPLICATION_ID,
224: DESCRIPTION = X_DESCRIPTION,
225: DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
226: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
227: LAST_UPDATED_BY = X_LAST_UPDATED_BY,