4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- PA_CI_DIRECT_COST_DETAILS Record Spec
7: TYPE PaCiDirectCostDetailsRecType IS RECORD (
8: dc_line_id NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: -- PA_CI_DIRECT_COST_DETAILS Record Spec
7: TYPE PaCiDirectCostDetailsRecType IS RECORD (
8: dc_line_id NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
6: -- PA_CI_DIRECT_COST_DETAILS Record Spec
7: TYPE PaCiDirectCostDetailsRecType IS RECORD (
8: dc_line_id NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
7: TYPE PaCiDirectCostDetailsRecType IS RECORD (
8: dc_line_id NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
8: dc_line_id NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
9: ,ci_id NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
10: ,project_id NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
11: ,task_id NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%TYPE := PA_API.G_MISS_CHAR
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
13: ,resource_list_member_id NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
16: ,quantity NUMBER := PA_API.G_MISS_NUM
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
18: ,raw_cost NUMBER := PA_API.G_MISS_NUM
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
19: ,burdened_cost NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
21: ,burden_cost_rate NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
22: ,resource_assignment_id NUMBER := PA_API.G_MISS_NUM
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);
24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);
32: GMissPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);
32: GMissPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;
33: TYPE PaCiDirectCostDetailsTblType IS TABLE OF PaCiDirectCostDetailsRecType
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);
32: GMissPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;
33: TYPE PaCiDirectCostDetailsTblType IS TABLE OF PaCiDirectCostDetailsRecType
34: INDEX BY BINARY_INTEGER;
27: ,created_by NUMBER := PA_API.G_MISS_NUM
28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%TYPE := PA_API.G_MISS_DATE
29: ,last_update_by NUMBER := PA_API.G_MISS_NUM
30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);
32: GMissPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;
33: TYPE PaCiDirectCostDetailsTblType IS TABLE OF PaCiDirectCostDetailsRecType
34: INDEX BY BINARY_INTEGER;
35: ---------------------------------------------------------------------------
34: INDEX BY BINARY_INTEGER;
35: ---------------------------------------------------------------------------
36: -- GLOBAL MESSAGE CONSTANTS
37: ---------------------------------------------------------------------------
38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
35: ---------------------------------------------------------------------------
36: -- GLOBAL MESSAGE CONSTANTS
37: ---------------------------------------------------------------------------
38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
36: -- GLOBAL MESSAGE CONSTANTS
37: ---------------------------------------------------------------------------
38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
37: ---------------------------------------------------------------------------
38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
48: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
48: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
49: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
48: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
49: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
50: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;
44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;
45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;
46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;
47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;
48: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
49: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
50: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
51:
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'PA_CI_DIR_COST_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := PA_API.G_APP_NAME;
62: ---------------------------------------------------------------------------
63: -- Procedures and Functions
64: ---------------------------------------------------------------------------
65:
67: PROCEDURE change_version;
68: PROCEDURE api_copy;
69: PROCEDURE insert_row(
70: p_api_version IN NUMBER,
71: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2,
75: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
76: XPaCiDirectCostDetailsRec OUT NOCOPY PaCiDirectCostDetailsRecType);
77: /*
78: PROCEDURE insert_row(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
85: XPaCiDirectCostDetailsTbl OUT NOCOPY PaCiDirectCostDetailsTblType,
86: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
87: */
88: PROCEDURE insert_row(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
86: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
87: */
88: PROCEDURE insert_row(
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
94: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
95: XPaCiDirectCostDetailsTbl OUT NOCOPY PaCiDirectCostDetailsTblType);
96: PROCEDURE lock_row(
97: p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
101: x_msg_data OUT NOCOPY VARCHAR2,
102: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
103: PROCEDURE lock_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
110: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
111: PROCEDURE lock_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
109: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
110: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
111: PROCEDURE lock_row(
112: p_api_version IN NUMBER,
113: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2,
117: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType);
116: x_msg_data OUT NOCOPY VARCHAR2,
117: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType);
118: PROCEDURE update_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
124: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType,
125: XPaCiDirectCostDetailsRec OUT NOCOPY PaCiDirectCostDetailsRecType);
126: PROCEDURE update_row(
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
129: x_return_status OUT NOCOPY VARCHAR2,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
130: x_msg_count OUT NOCOPY NUMBER,
131: x_msg_data OUT NOCOPY VARCHAR2,
132: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
133: XPaCiDirectCostDetailsTbl OUT NOCOPY PaCiDirectCostDetailsTblType,
134: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
135: PROCEDURE update_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
133: XPaCiDirectCostDetailsTbl OUT NOCOPY PaCiDirectCostDetailsTblType,
134: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
135: PROCEDURE update_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
141: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
142: XPaCiDirectCostDetailsTbl OUT NOCOPY PaCiDirectCostDetailsTblType);
143: PROCEDURE delete_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
150: PROCEDURE delete_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
157: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
158: PROCEDURE delete_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
156: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
157: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
158: PROCEDURE delete_row(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType);
163: x_msg_data OUT NOCOPY VARCHAR2,
164: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType);
165: PROCEDURE validate_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_pa_ci_direct_cost1 IN PaCiDirectCostDetailsRecType);
172: PROCEDURE validate_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
179: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
180: PROCEDURE validate_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
178: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType,
179: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);
180: PROCEDURE validate_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: PPaCiDirectCostDetailsTbl IN PaCiDirectCostDetailsTblType);