APPS.PA_DRAFT_REVENUES_PKG dependencies on PA_DRAFT_REVENUES

Line 1: package body pa_draft_revenues_pkg as

1: package body pa_draft_revenues_pkg as
2: /* $Header: PAXRVUTB.pls 120.2 2007/12/08 19:18:57 jjgeorge ship $ */
3:
4: procedure INITIALIZE is
5: begin

Line 26: from pa_draft_revenues

22: into dummy
23: from sys.dual
24: where exists (
25: select null
26: from pa_draft_revenues
27: where project_id = X_project_id
28: and draft_revenue_num = X_draft_revenue_num
29: and released_date is null
30: and NVL(generation_error_flag, 'N') = 'N');

Line 40: from pa_draft_revenues_all where project_id = X_project_id and

36: return FALSE;
37: end;
38: /** bug 2343583 **/
39: Select nvl(adjusting_revenue_flag,'N') into adj_flag
40: from pa_draft_revenues_all where project_id = X_project_id and
41: draft_revenue_num = X_draft_revenue_num;
42: begin
43: select null
44: into dummy

Line 48: from pa_draft_revenues

44: into dummy
45: from sys.dual
46: where not exists (
47: select null
48: from pa_draft_revenues
49: where project_id = X_project_id
50: and draft_revenue_num < X_draft_revenue_num
51: and released_date is null
52: and nvl(adjusting_revenue_flag,'N') = adj_flag );

Line 81: from pa_draft_revenues

77: into dummy
78: from sys.dual
79: where exists (
80: select null
81: from pa_draft_revenues
82: where project_id = X_project_id
83: and draft_revenue_num = X_draft_revenue_num
84: and released_date is not null
85: and transfer_status_code in ('P', 'R'));

Line 96: from pa_draft_revenues_all where project_id = X_project_id and

92: end;
93:
94: /** bug 2343583 **/
95: Select nvl(adjusting_revenue_flag,'N') into adj_flag
96: from pa_draft_revenues_all where project_id = X_project_id and
97: draft_revenue_num = X_draft_revenue_num;
98:
99: begin
100: select null

Line 105: from pa_draft_revenues

101: into dummy
102: from sys.dual
103: where not exists (
104: select null
105: from pa_draft_revenues
106: where project_id = X_project_id
107: and draft_revenue_num > X_draft_revenue_num
108: and released_date is not null
109: and nvl(adjusting_revenue_flag,'N') = adj_flag );

Line 168: from pa_draft_revenues

164: into dummy
165: from sys.dual
166: where not exists (
167: select null
168: from pa_draft_revenues
169: where project_id = X_project_id
170: and draft_revenue_num = X_draft_revenue_num
171: and (nvl(resource_accumulated_flag, 'N') = 'Y'
172: or nvl(accumulated_flag, 'N') = 'Y'));

Line 193: update pa_draft_revenues

189: if not allow_release(X_PROJECT_ID, X_DRAFT_REVENUE_NUM) then
190: X_err_code := 1;
191: else
192: begin
193: update pa_draft_revenues
194: set released_date = sysdate,
195: last_update_date = sysdate,
196: last_updated_by = fnd_global.user_id,
197: last_update_login = fnd_global.login_id

Line 217: update pa_draft_revenues

213: if not allow_unrelease(X_PROJECT_ID, X_DRAFT_REVENUE_NUM) then
214: X_err_code := 1;
215: else
216: begin
217: update pa_draft_revenues
218: set released_date = NULL,
219: last_update_date = sysdate,
220: last_updated_by = fnd_global.user_id,
221: last_update_login = fnd_global.login_id

Line 232: end pa_draft_revenues_pkg;

228: X_err_code := 0;
229: end if;
230: end UNRELEASE;
231:
232: end pa_draft_revenues_pkg;