[Home] [Help]
PACKAGE: APPS.PA_PROCESS_CI_LINES_PKG
Source
1 package pa_process_ci_lines_pkg AUTHID CURRENT_USER AS
2 /* $Header: PAPPCILS.pls 120.1 2010/10/07 21:28:09 rmunjulu noship $*/
3
4 TYPE info_rec IS RECORD(LINE_ID NUMBER,
5 PROJECT_ID NUMBER,
6 TASK_ID NUMBER,
7 CURRENCY_CODE VARCHAR2(30),
8 RLMI_ID NUMBER,
9 RES_ASSGN_ID NUMBER,
10 QUANTITY NUMBER,
11 RAW_COST NUMBER);
12
13 TYPE info_rec_tbl IS TABLE OF INFO_REC index by binary_integer;
14
15 SUBTYPE g_pa_num_tbl IS SYSTEM.pa_num_tbl_type;
16 SUBTYPE g_PA_DATE_TBL IS SYSTEM.PA_DATE_TBL_TYPE;
17 SUBTYPE g_PA_VARCHAR2_1_TBL IS SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
18 SUBTYPE g_PA_VARCHAR2_15_TBL IS SYSTEM.PA_VARCHAR2_15_TBL_TYPE;
19 SUBTYPE g_PA_VARCHAR2_30_TBL IS SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
20 SUBTYPE g_PA_VARCHAR2_80_TBL IS SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
21 SUBTYPE g_PA_VARCHAR2_100_TBL IS SYSTEM.PA_VARCHAR2_100_TBL_TYPE;
22 SUBTYPE g_PA_VARCHAR2_150_TBL IS SYSTEM.PA_VARCHAR2_150_TBL_TYPE;
23 SUBTYPE g_PA_VARCHAR2_240_TBL IS SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
24
25 g_pkg_name constant varchar2(30) := 'PA_PROCESS_CI_LINES_PKG';
26
27 procedure process_planning_lines(p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_calling_context IN VARCHAR2,
33 p_action_type IN VARCHAR2,
34 p_bvid IN NUMBER,
35 p_ci_id IN NUMBER,
36 p_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
37 p_project_id IN NUMBER,
38 p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
39 p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
40 p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
41 p_res_assgn_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
42 p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
43 DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44 p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
45 DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
46 );
47
48 procedure insert_planning_transaction(p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 P_BVID IN NUMBER,
54 P_PROJECT_ID IN NUMBER,
55 P_TASK_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
56 P_RLMI_ID_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
57 P_CURRENCY_CODE_TBL IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
58 P_QUANTITY_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
59 P_RAW_COST_TBL IN SYSTEM.PA_NUM_TBL_TYPE
60 );
61
62 procedure delete_planning_transaction(p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_bvid IN number,
68 p_project_id IN NUMBER,
69 p_task_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
70 p_currency_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE,
71 p_rlmi_tbl IN SYSTEM.PA_NUM_TBL_TYPE
72 );
73
74 procedure update_planning_transaction(p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_bvid IN NUMBER,
80 p_project_id in NUMBER,
81 p_task_id_tbl in SYSTEM.PA_NUM_TBL_TYPE,
82 p_effective_from_tbl in SYSTEM.PA_DATE_TBL_TYPE,
83 p_effective_to_tbl in SYSTEM.PA_DATE_TBL_TYPE,
84 p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
85 p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
86 p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
87 p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
88 );
89
90 end pa_process_ci_lines_pkg;