DBA Data[Home] [Help]

APPS.PA_PROJECT_VERIFY_PKG dependencies on PA_PROJECT_VERIFY_PKG

Line 1: PACKAGE BODY PA_PROJECT_VERIFY_PKG AS

1: PACKAGE BODY PA_PROJECT_VERIFY_PKG AS
2: /* $Header: PAXPRVRB.pls 120.3 2007/02/06 10:18:36 dthakker ship $ */
3:
4: PROCEDURE customer_exists
5: (x_project_id IN NUMBER,

Line 34: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.client_exists';

30: dummy number;
31: begin
32: x_err_code := 0;
33: x_old_stack := x_err_stack;
34: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.client_exists';
35: x_err_msgname := NULL;
36: x_err_stage := 'Checking client exists...';
37:
38: OPEN get_top_task_cust_enbled;

Line 81: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.contact_exists';

77: dummy number;
78: begin
79: x_err_code := 0;
80: x_old_stack := x_err_stack;
81: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.contact_exists';
82: x_err_msgname := NULL;
83: x_err_stage := 'Checking contact exists...';
84: SELECT NULL
85: INTO dummy

Line 217: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.category_required';

213: -- that have the total 100 percent flag enabled, but whose defined
214: -- defined class codes do not actually total 100
215: x_err_code := 0;
216: x_old_stack := x_err_stack;
217: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.category_required';
218: x_err_msgname := NULL;
219: x_err_stage := 'Checking required category exists...';
220:
221: OPEN C11;

Line 290: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.manager_exists';

286: AND PROJECT_ROLE_TYPE = 'PROJECT MANAGER';
287: BEGIN
288: x_err_code := 0;
289: x_old_stack := x_err_stack;
290: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.manager_exists';
291: x_err_msgname := NULL;
292: x_err_stage := 'Checking manager exists...';
293:
294: OPEN c1 ;

Line 360: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.revenue_budget';

356: dummy number;
357: begin
358: x_err_code := 0;
359: x_old_stack := x_err_stack;
360: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.revenue_budget';
361: x_err_msgname := NULL;
362: x_err_stage := 'Checking revenue budget exists...';
363: SELECT 'x' INTO dummy
364: FROM PA_BUDGET_VERSIONS bv,

Line 390: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.cost_budget';

386: dummy number;
387: begin
388: x_err_code := 0;
389: x_old_stack := x_err_stack;
390: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.cost_budget';
391: x_err_msgname := NULL;
392: x_err_stage := 'Checking cost budget exists...';
393: SELECT 'x' INTO dummy
394: FROM PA_BUDGET_VERSIONS bv,

Line 422: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.billing_event';

418: dummy number;
419: begin
420: x_err_code := 0;
421: x_old_stack := x_err_stack;
422: x_err_stack := x_err_stack ||'->PA_PROJECT_VERIFY_PKG.billing_event';
423: x_err_msgname := NULL;
424: x_eamt_token_name := 'EAMT';
425: x_eamt_token_value := 0;
426: /* Commented out for now,since the code is incorrectly referencing

Line 485: end PA_PROJECT_VERIFY_PKG;

481: when others then
482: x_err_code := SQLCODE;
483: end billing_event;
484:
485: end PA_PROJECT_VERIFY_PKG;