DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on HXC_TIME_ATTRIBUTES

Line 54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

50:
51: TYPE Project_Attribution_Rec IS Record (
52: Project_Number Pa_Projects_All.Segment1%TYPE,
53: Project_Id Pa_Projects_All.Project_Id%TYPE,
54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,
57: Task_Id Pa_Tasks.Task_Id%TYPE,
58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

51: TYPE Project_Attribution_Rec IS Record (
52: Project_Number Pa_Projects_All.Segment1%TYPE,
53: Project_Id Pa_Projects_All.Project_Id%TYPE,
54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,
57: Task_Id Pa_Tasks.Task_Id%TYPE,
58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

54: Proj_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,
57: Task_Id Pa_Tasks.Task_Id%TYPE,
58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

55: Proj_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
56: Task_Number Pa_Tasks.Task_Number%TYPE,
57: Task_Id Pa_Tasks.Task_Id%TYPE,
58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

58: Task_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
64: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

59: Task_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
60: Expenditure_Type Pa_Expenditure_Types.Expenditure_Type%TYPE,
61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
64: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,

Line 65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

61: UOM Hxc_Time_Building_Blocks.Unit_Of_Measure%TYPE,
62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
64: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
68: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
69: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,

Line 66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

62: Exp_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
63: Exp_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
64: Sys_Linkage_Func Pa_Expenditure_Types.System_Linkage_Function%TYPE,
65: Sys_Link_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
66: Sys_Link_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
67: Quantity Pa_Expenditure_Items_All.Quantity%TYPE,
68: Expenditure_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE,
69: Exp_Ending_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE,
70: Inc_By_Person_Id Pa_Expenditures_All.Incurred_By_Person_Id%TYPE,

Line 84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

80: Attribute9 Pa_Expenditure_Items_All.Attribute9%TYPE,
81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,

Line 85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

81: Attribute10 Pa_Expenditure_Items_All.Attribute10%TYPE,
82: Expenditure_Item_Comment Pa_Expenditure_Comments.Expenditure_Comment%TYPE,
83: Billable_Flag Pa_Expenditure_Items_All.Billable_Flag%TYPE,
84: Billable_Flag_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

Line 89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

85: Billable_Flag_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

86: Billable_Flag2 Pa_Expenditure_Items_All.Billable_Flag%TYPE,
87: Billable_Flag_Index Binary_Integer,
88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,

Line 92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

88: Work_Type_Id Pa_Expenditure_Items_All.Work_Type_Id%TYPE,
89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

89: Work_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
90: Work_Type_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,

Line 95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

91: Assignment_Id Pa_Expenditure_Items_All.Assignment_Id%TYPE,
92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

Line 96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

92: Assignment_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
93: Assignment_Attr_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,

Line 98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

94: PO_Line_Id Pa_Expenditure_Items_All.PO_Line_Id%TYPE,
95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
102: PO_Header_Id Number,

Line 99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,

95: PO_Line_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
96: PO_Line_Id_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
97: PO_Price_Type Pa_Expenditure_Items_All.PO_Price_Type%TYPE,
98: PO_Price_Type_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
99: PO_Price_Type_Ovn Hxc_Time_Attributes.Object_Version_Number%TYPE,
100: Person_Type Pa_Expenditures_All.Person_Type%TYPE,
101: Vendor_Id Pa_EXpenditures_All.Vendor_Id%TYPE,
102: PO_Header_Id Number,
103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,

Line 107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

103: Approval_Status Hxc_Time_Building_Blocks.Approval_Status%TYPE,
104: Action Varchar2(30),
105: -- bug 10253400: Payroll integration enhancement for 12.2..start
106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE

Line 109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

105: -- bug 10253400: Payroll integration enhancement for 12.2..start
106: Job_Id PA_Expenditure_Items_All.Job_ID%TYPE,
107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE
112: -- bug 10253400: Payroll integration enhancement for 12.2..end
113: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146

Line 111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE

107: Job_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
108: Location_Id PA_Expenditure_Items_All.Location_Id%TYPE,
109: Location_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
110: Pay_Element_Type_Id PA_Expenditure_Items_All.Pay_Element_Type_Id%TYPE,
111: Pay_Element_Type_Id_Attr_Id Hxc_Time_Attributes.Time_Attribute_Id%TYPE
112: -- bug 10253400: Payroll integration enhancement for 12.2..end
113: ,Cbs_Element_Id PA_Expenditure_Items_All.Cbs_Element_Id%TYPE -- Added for CBS Enhancement Bug 16220146
114: );
115:

Line 182: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE

178: -- P_Message_Level - Varchar2
179: -- P_Message_Field - Varchar2
180: -- P_Msg_Tokens - Pa_Otc_Api.Message_Tokens
181: -- P_Time_Building_Block_Id - Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE
182: -- P_Time_Attribute_Id - Hxc_Time_Attributes.Time_Attribute_Id%TYPE
183: -- P_Message_App - Varchar2 Default 'PA'
184: --
185: -- OUT
186: -- P_Message_Table - Hxc_User_Type_Definition_Grp.Message_Table

Line 198: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,

194: P_Message_Level IN Varchar2,
195: P_Message_Field IN Varchar2,
196: P_Msg_Tokens IN Pa_Otc_Api.Message_Tokens,
197: P_Time_Building_Block_Id IN Hxc_Time_Building_Blocks.Time_Building_Block_Id%TYPE,
198: P_Time_Attribute_Id IN Hxc_Time_Attributes.Time_Attribute_Id%TYPE,
199: P_Message_App IN Varchar2 Default 'PA');
200:
201:
202: /* IMPORT ROUTINES */