1 PACKAGE Pji_Rep_Dflt_Drilldown_Txn AS
2 /* $Header: PJIRX13S.pls 120.0 2005/05/29 13:01:38 appldev noship $ */
3
4 TYPE number_nestedtb IS TABLE OF NUMBER;
5
6 /*
7 ** History
8 ** 04-FEB-2004 EPASQUIN Created
9 **
10 ** This procedure derives default values for the parameters used in the
11 ** drilldown to transactions pages.
12 **
13 */
14 PROCEDURE derive_parameters(
15 p_project_id NUMBER
16 ,p_calendar_type VARCHAR2
17 ,p_calendar_id NUMBER
18 ,p_time_id NUMBER
19 ,p_wbs_element_id NUMBER
20 ,p_rbs_element_id NUMBER
21 ,p_commitment_flag VARCHAR2
22 ,p_time_flag VARCHAR2
23 ,x_start_date OUT NOCOPY DATE
24 ,x_end_date OUT NOCOPY DATE
25 ,x_task_id OUT NOCOPY NUMBER
26 ,x_rev_categ_code OUT NOCOPY VARCHAR2
27 ,x_event_type_id OUT NOCOPY NUMBER
28 ,x_event_type OUT NOCOPY VARCHAR2
29 ,x_inventory_item_ids OUT NOCOPY VARCHAR2
30 ,x_org_id OUT NOCOPY NUMBER
31 ,x_expenditure_category_id OUT NOCOPY NUMBER
32 ,x_expenditure_type_id OUT NOCOPY NUMBER
33 ,x_item_category_id OUT NOCOPY NUMBER
34 ,x_job_id OUT NOCOPY NUMBER
35 ,x_person_type_id OUT NOCOPY NUMBER
36 ,x_person_id OUT NOCOPY NUMBER
37 ,x_non_labor_resource_id OUT NOCOPY NUMBER
38 ,x_bom_equipment_resource_id OUT NOCOPY NUMBER
39 ,x_bom_labor_resource_id OUT NOCOPY NUMBER
40 ,x_vendor_id OUT NOCOPY NUMBER
41 ,x_resource_class_id OUT NOCOPY NUMBER
42 ,x_resource_class_code OUT NOCOPY VARCHAR2
43 ,x_person_type OUT NOCOPY VARCHAR2
44 ,x_expenditure_type OUT NOCOPY VARCHAR2
45 ,x_prg_project_id OUT NOCOPY NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 /*
52 ** History
53 ** 13-JUL-2004 EPASQUIN Created
54 **
55 ** This procedure determines whether the events and costs table have to
56 ** be displayed in the TransactionEventsCosts drilldown page.
57 **
58 */
59 PROCEDURE determine_events_costs_display(
60 p_wbs_element_id NUMBER
61 ,x_task_id OUT NOCOPY NUMBER
62 ,x_show_costs_flag OUT NOCOPY VARCHAR2
63 ,x_show_events_flag OUT NOCOPY VARCHAR2
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 );
68
69 END Pji_Rep_Dflt_Drilldown_Txn;