eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ADJ_ELEMENTS_PKG dependencies on FND_API

Line 17: := FND_API.G_MISS_NUM

13:
14: PROCEDURE Insert_Row
15: ( px_adj_element_id IN OUT NOCOPY pa_fp_adj_elements.adj_element_id%TYPE --File.Sql.39 bug 4440895
16: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
21: := FND_API.G_MISS_NUM

Line 19: := FND_API.G_MISS_NUM

15: ( px_adj_element_id IN OUT NOCOPY pa_fp_adj_elements.adj_element_id%TYPE --File.Sql.39 bug 4440895
16: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
23: := FND_API.G_MISS_NUM

Line 21: := FND_API.G_MISS_NUM

17: := FND_API.G_MISS_NUM
18: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
25: := FND_API.G_MISS_CHAR

Line 23: := FND_API.G_MISS_NUM

19: := FND_API.G_MISS_NUM
20: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
27: := FND_API.G_MISS_CHAR

Line 25: := FND_API.G_MISS_CHAR

21: := FND_API.G_MISS_NUM
22: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
23: := FND_API.G_MISS_NUM
24: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
27: := FND_API.G_MISS_CHAR
28: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 27: := FND_API.G_MISS_CHAR

23: := FND_API.G_MISS_NUM
24: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
25: := FND_API.G_MISS_CHAR
26: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
27: := FND_API.G_MISS_CHAR
28: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
29: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
30: IS
31: CURSOR C2 IS SELECT pa_fp_adj_elements_s.nextval FROM sys.dual;

Line 34: (px_adj_element_id = FND_API.G_MISS_NUM) THEN

30: IS
31: CURSOR C2 IS SELECT pa_fp_adj_elements_s.nextval FROM sys.dual;
32: BEGIN
33: IF (px_adj_element_id IS NULL) OR
34: (px_adj_element_id = FND_API.G_MISS_NUM) THEN
35: OPEN C2;
36: FETCH C2 INTO px_adj_element_id;
37: CLOSE C2;
38: END IF;

Line 59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)

55: ,fnd_global.user_id
56: ,fnd_global.login_id
57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)

Line 60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)

56: ,fnd_global.login_id
57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)
64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));

Line 61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)

57: ,fnd_global.user_id
58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)
64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));
65: EXCEPTION

Line 62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)

58: ,sysdate
59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)
64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));
65: EXCEPTION
66: WHEN OTHERS THEN

Line 63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)

59: ,DECODE( p_budget_version_id, FND_API.G_MISS_NUM, NULL, p_budget_version_id)
60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)
64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));
65: EXCEPTION
66: WHEN OTHERS THEN
67: FND_MSG_PUB.add_exc_msg( p_pkg_name

Line 64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));

60: ,DECODE( p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
61: ,DECODE( p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
62: ,DECODE( p_resource_assignment_id, FND_API.G_MISS_NUM, NULL, p_resource_assignment_id)
63: ,DECODE( p_adjustment_reason_code, FND_API.G_MISS_CHAR, NULL, p_adjustment_reason_code)
64: ,DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR, NULL, p_adjustment_comments));
65: EXCEPTION
66: WHEN OTHERS THEN
67: FND_MSG_PUB.add_exc_msg( p_pkg_name
68: => 'PA_FP_ADJ_ELEMENTS_PKG.Insert_Row'

Line 71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: FND_MSG_PUB.add_exc_msg( p_pkg_name
68: => 'PA_FP_ADJ_ELEMENTS_PKG.Insert_Row'
69: ,p_procedure_name
70: => PA_DEBUG.G_Err_Stack);
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: RAISE;
73: END Insert_Row;
74:
75: PROCEDURE update_row

Line 77: := FND_API.G_MISS_NUM

73: END Insert_Row;
74:
75: PROCEDURE update_row
76: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
77: := FND_API.G_MISS_NUM
78: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
79: := FND_API.G_MISS_NUM
80: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
81: := FND_API.G_MISS_NUM

Line 79: := FND_API.G_MISS_NUM

75: PROCEDURE update_row
76: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
77: := FND_API.G_MISS_NUM
78: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
79: := FND_API.G_MISS_NUM
80: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
83: := FND_API.G_MISS_NUM

Line 81: := FND_API.G_MISS_NUM

77: := FND_API.G_MISS_NUM
78: ,p_resource_assignment_id IN pa_fp_adj_elements.RESOURCE_ASSIGNMENT_ID%TYPE
79: := FND_API.G_MISS_NUM
80: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
85: := FND_API.G_MISS_NUM

Line 83: := FND_API.G_MISS_NUM

79: := FND_API.G_MISS_NUM
80: ,p_budget_version_id IN pa_fp_adj_elements.budget_version_id%TYPE
81: := FND_API.G_MISS_NUM
82: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
87: := FND_API.G_MISS_CHAR

Line 85: := FND_API.G_MISS_NUM

81: := FND_API.G_MISS_NUM
82: ,p_project_id IN pa_fp_adj_elements.project_id%TYPE
83: := FND_API.G_MISS_NUM
84: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
89: := FND_API.G_MISS_CHAR

Line 87: := FND_API.G_MISS_CHAR

83: := FND_API.G_MISS_NUM
84: ,p_task_id IN pa_fp_adj_elements.task_id%TYPE
85: := FND_API.G_MISS_NUM
86: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_row_id IN ROWID
91: := NULL

Line 89: := FND_API.G_MISS_CHAR

85: := FND_API.G_MISS_NUM
86: ,p_adjustment_reason_code IN pa_fp_adj_elements.ADJUSTMENT_REASON_CODE%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_adjustment_comments IN pa_fp_adj_elements.ADJUSTMENT_COMMENTS%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_row_id IN ROWID
91: := NULL
92: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
93: IS

Line 100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,

96: SET
97: last_update_login = fnd_global.login_id
98: ,last_updated_by = fnd_global.user_id
99: ,last_update_date = sysdate
100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,
101: adj_element_id, p_adj_element_id)
102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,
103: budget_version_id, p_budget_version_id)
104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,

Line 102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,

98: ,last_updated_by = fnd_global.user_id
99: ,last_update_date = sysdate
100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,
101: adj_element_id, p_adj_element_id)
102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,
103: budget_version_id, p_budget_version_id)
104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
105: p_project_id)
106: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)

Line 104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,

100: ,adj_element_id = DECODE( p_adj_element_id, FND_API.G_MISS_NUM,
101: adj_element_id, p_adj_element_id)
102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,
103: budget_version_id, p_budget_version_id)
104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
105: p_project_id)
106: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
107: ,resource_assignment_id = DECODE( p_resource_assignment_id,
108: FND_API.G_MISS_NUM,

Line 106: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)

102: ,budget_version_id = DECODE( p_budget_version_id, FND_API.G_MISS_NUM,
103: budget_version_id, p_budget_version_id)
104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
105: p_project_id)
106: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
107: ,resource_assignment_id = DECODE( p_resource_assignment_id,
108: FND_API.G_MISS_NUM,
109: resource_assignment_id,
110: p_resource_assignment_id)

Line 108: FND_API.G_MISS_NUM,

104: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
105: p_project_id)
106: ,task_id = DECODE( p_task_id, FND_API.G_MISS_NUM, task_id, p_task_id)
107: ,resource_assignment_id = DECODE( p_resource_assignment_id,
108: FND_API.G_MISS_NUM,
109: resource_assignment_id,
110: p_resource_assignment_id)
111: ,adjustment_reason_code = DECODE( p_adjustment_reason_code,
112: FND_API.G_MISS_CHAR,

Line 112: FND_API.G_MISS_CHAR,

108: FND_API.G_MISS_NUM,
109: resource_assignment_id,
110: p_resource_assignment_id)
111: ,adjustment_reason_code = DECODE( p_adjustment_reason_code,
112: FND_API.G_MISS_CHAR,
113: adjustment_reason_code,
114: p_adjustment_reason_code)
115: ,adjustment_comments = DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR,
116: adjustment_comments, p_adjustment_comments)

Line 115: ,adjustment_comments = DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR,

111: ,adjustment_reason_code = DECODE( p_adjustment_reason_code,
112: FND_API.G_MISS_CHAR,
113: adjustment_reason_code,
114: p_adjustment_reason_code)
115: ,adjustment_comments = DECODE( p_adjustment_comments, FND_API.G_MISS_CHAR,
116: adjustment_comments, p_adjustment_comments)
117: WHERE adj_element_id = p_adj_element_id;
118:
119: IF (SQL%NOTFOUND) THEN

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118:
119: IF (SQL%NOTFOUND) THEN
120: PA_UTILS.Add_message ( p_app_short_name => 'PA'
121: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: END IF;
124:
125: EXCEPTION
126: WHEN OTHERS THEN

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

127: FND_MSG_PUB.add_exc_msg( p_pkg_name
128: => 'PA_FP_ADJ_ELEMENTS_PKG.Update_Row'
129: ,p_procedure_name
130: => PA_DEBUG.G_Err_Stack);
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: RAISE;
133: END Update_Row;
134:
135: PROCEDURE Delete_Row

Line 137: := FND_API.G_MISS_NUM

133: END Update_Row;
134:
135: PROCEDURE Delete_Row
136: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_row_id IN ROWID
139: := NULL
140: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
141: IS

Line 144: p_adj_element_id <> FND_API.G_MISS_NUM) THEN

140: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
141: IS
142: BEGIN
143: IF (p_adj_element_id IS NOT NULL OR
144: p_adj_element_id <> FND_API.G_MISS_NUM) THEN
145:
146: DELETE FROM pa_fp_adj_elements
147: WHERE adj_element_id = p_adj_element_id;
148:

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154:
155: IF (SQL%NOTFOUND) THEN
156: PA_UTILS.Add_message ( p_app_short_name => 'PA'
157: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: END IF;
160:
161: EXCEPTION
162: WHEN OTHERS THEN

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

163: FND_MSG_PUB.add_exc_msg( p_pkg_name
164: => 'PA_FP_ADJ_ELEMENTS_PKG.Delete_Row'
165: ,p_procedure_name
166: => PA_DEBUG.G_Err_Stack);
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: RAISE;
169: END Delete_Row;
170:
171: PROCEDURE Lock_Row

Line 173: := FND_API.G_MISS_NUM

169: END Delete_Row;
170:
171: PROCEDURE Lock_Row
172: ( p_adj_element_id IN pa_fp_adj_elements.adj_element_id%TYPE
173: := FND_API.G_MISS_NUM
174: ,p_row_id IN ROWID
175: := NULL
176: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
177: IS

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

188: FND_MSG_PUB.add_exc_msg( p_pkg_name
189: => 'PA_FP_ADJ_ELEMENTS_PKG.Lock_Row'
190: ,p_procedure_name
191: => PA_DEBUG.G_Err_Stack);
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: RAISE;
194: END Lock_Row;
195:
196: End pa_fp_adj_elements_pkg;