DBA Data[Home] [Help]

APPS.PA_ALTERNATE_TASK_PVT dependencies on PA_NUM_TBL_TYPE

Line 10: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

6: * with the unique combination of Proj element and Cost code.
7: *
8: */
9: Procedure Create_Alt_Task(
10: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
11: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
12: p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
13: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
14: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),

Line 11: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

7: *
8: */
9: Procedure Create_Alt_Task(
10: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
11: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
12: p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
13: p_attribute1 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
14: p_attribute2 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),
15: p_attribute3 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE(),

Line 38: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

34: * In this it needs to validate whether the alternate task can be deleted or not.
35: *
36: */
37: PROCEDURE Delete_Alt_Task(
38: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
39: X_Return_Status OUT NOCOPY Varchar2,
40: X_Msg_Data OUT NOCOPY Varchar2,
41: X_Msg_Count OUT NOCOPY Number);
42:

Line 49: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

45: * existing for the given proj element and the cost code.
46: *
47: */
48: Procedure Validate_Alt_Tasks_Gen(
49: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
50: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
51: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE );
52:
53: /*

Line 50: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

46: *
47: */
48: Procedure Validate_Alt_Tasks_Gen(
49: p_Proj_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
50: p_Cbs_Element_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
51: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE );
52:
53: /*
54: * This API is used to Validate whether the Alternate Task is

Line 59: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

55: * eligible for deletion or not.
56: *
57: */
58: Procedure Validate_Del_Alt_Tasks(
59: p_Alt_Task_Id IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
60: p_context IN VARCHAR2 := 'COST_CODE',
61: X_Valid_Status OUT NOCOPY SYSTEM.PA_VARCHAR2_1_TBL_TYPE );
62:
63: /*