DBA Data[Home] [Help]

APPS.PA_CI_DIR_COST_PVT dependencies on PA_API

Line 8: dc_line_id NUMBER := PA_API.G_MISS_NUM

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

Line 9: ,ci_id NUMBER := PA_API.G_MISS_NUM

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

Line 10: ,project_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

Line 11: ,task_id NUMBER := PA_API.G_MISS_NUM

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

Line 12: ,expenditure_type PA_CI_DIRECT_COST_DETAILS.EXPENDITURE_TYPE%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

Line 13: ,resource_list_member_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
17: ,planning_resource_rate NUMBER := PA_API.G_MISS_NUM

Line 14: ,unit_of_measure PA_CI_DIRECT_COST_DETAILS.UNIT_OF_MEASURE%TYPE := PA_API.G_MISS_CHAR

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

Line 15: ,currency_code PA_CI_DIRECT_COST_DETAILS.CURRENCY_CODE%TYPE := PA_API.G_MISS_CHAR

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

Line 16: ,quantity 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

Line 17: ,planning_resource_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

Line 18: ,raw_cost 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

Line 19: ,burdened_cost 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

Line 20: ,raw_cost_rate NUMBER := PA_API.G_MISS_NUM

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

Line 21: ,burden_cost_rate 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
25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR

Line 22: ,resource_assignment_id 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
26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR

Line 23: ,effective_from PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_FROM%TYPE := PA_API.G_MISS_DATE

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

Line 24: ,effective_to PA_CI_DIRECT_COST_DETAILS.EFFECTIVE_TO%TYPE := PA_API.G_MISS_DATE

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

Line 25: ,change_reason_code PA_CI_DIRECT_COST_DETAILS.CHANGE_REASON_CODE%TYPE := PA_API.G_MISS_CHAR

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

Line 26: ,change_description PA_CI_DIRECT_COST_DETAILS.CHANGE_DESCRIPTION%TYPE := PA_API.G_MISS_CHAR

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

Line 27: ,created_by 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
31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);

Line 28: ,creation_date PA_CI_DIRECT_COST_DETAILS.CREATION_DATE%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);
32: GMissPaCiDirectCostDetailsRec PaCiDirectCostDetailsRecType;

Line 29: ,last_update_by NUMBER := PA_API.G_MISS_NUM

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

Line 30: ,last_update_date PA_CI_DIRECT_COST_DETAILS.LAST_UPDATE_DATE%TYPE := PA_API.G_MISS_DATE

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;

Line 31: ,last_update_login NUMBER := PA_API.G_MISS_NUM);

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: ---------------------------------------------------------------------------

Line 38: G_FND_APP CONSTANT VARCHAR2(200) := PA_API.G_FND_APP;

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;

Line 39: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := PA_API.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 40: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_DELETED;

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;

Line 41: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := PA_API.G_FORM_RECORD_CHANGED;

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;

Line 42: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := PA_API.G_RECORD_LOGICALLY_DELETED;

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;

Line 43: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := PA_API.G_REQUIRED_VALUE;

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;

Line 44: G_INVALID_VALUE CONSTANT VARCHAR2(200) := PA_API.G_INVALID_VALUE;

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';

Line 45: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_COL_NAME_TOKEN;

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';

Line 46: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_PARENT_TABLE_TOKEN;

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';

Line 47: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := PA_API.G_CHILD_TABLE_TOKEN;

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:

Line 61: G_APP_NAME CONSTANT VARCHAR2(3) := PA_API.G_APP_NAME;

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:

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 86: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);

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,

Line 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,

Line 98: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 110: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);

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,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);

Line 120: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 134: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);

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,

Line 137: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);

Line 152: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 157: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);

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,

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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,

Line 179: px_error_tbl IN OUT NOCOPY PA_API.ERROR_TBL_TYPE);

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,

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT PA_API.G_FALSE,

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);