[Home] [Help]
PACKAGE: APPS.PA_CI_DIR_COST_PUB
Source
1 package pa_ci_dir_cost_pub AUTHID CURRENT_USER AS
2 /* $Header: PAPCDCDS.pls 120.1 2010/10/07 21:25:47 rmunjulu noship $*/
3
4 subtype PaCiDirCostTblType is pa_ci_dir_cost_pvt.PaCiDirectCostDetailsTblType;
5 ---------------------------------------------------------------------------
6 -- GLOBAL MESSAGE CONSTANTS
7 ---------------------------------------------------------------------------
8 G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
9 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
10 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
11 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
12 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'PA_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
21
22 G_PKG_NAME CONSTANT VARCHAR2(200) := 'PA_CI_DIR_COST_PUB';
23
24 procedure insert_row(
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2,
30 p_bvid IN NUMBER,
31 p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
32 p_ci_id IN NUMBER,
33 p_project_id IN NUMBER,
34 p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
35 p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
36 p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
37 p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
38 p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
39 p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
40 p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
41 p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
42 p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
43 p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
44 p_burden_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
45 p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
46 p_effective_from_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(),
47 p_effective_to_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(),
48 p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
49 p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_2000_TBL_TYPE());
50
51
52 PROCEDURE update_row(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_bvid IN NUMBER,
59 p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
60 p_ci_id IN NUMBER,
61 p_project_id IN NUMBER,
62 p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
63 p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
64 p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
65 p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
66 p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
67 p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
68 p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
69 p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
70 p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
71 p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
72 p_burden_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
73 p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
74 p_effective_from_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
75 p_effective_to_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
76 p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
77 p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE);
78
79 PROCEDURE delete_row(
80 p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2,
85 p_dc_line_id_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
86 p_ci_id IN NUMBER,
87 p_project_id IN NUMBER,
88 p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
89 p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
90 p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
91 p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE);
92
93
94 end pa_ci_dir_cost_pub;