eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_TXN_INTERFACE_ITEMS_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,

93: x_cdl_sys_ref4 IN VARCHAR2 DEFAULT NULL,
94: -- PA-J changes
95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

Line 98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,

94: -- PA-J changes
95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

Line 99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,

95: x_Accrual_flag IN VARCHAR2 DEFAULT NULL,
96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

Line 100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,

96: -- Pa-K Changes
97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

Line 101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

97: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

Line 102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

98: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

Line 103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

99: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes

Line 104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

100: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

Line 105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

101: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

Line 106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

102: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
103: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

Line 108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

104: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

Line 109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

105: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

Line 110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

106: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes

Line 111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,

107: -- Begin PA.M/CWK changes
108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

Line 112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

108: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

Line 113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

109: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
110: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

Line 115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

111: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )

Line 116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

112: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )
120:

Line 117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,

113: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
114: -- End PA.M/CWK changes
115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )
120:
121: IS

Line 119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )

115: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
116: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
117: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL,
118: -- 12i MOAC changes
119: P_Org_Id IN Pa_Transaction_Interface_All.Org_Id%TYPE DEFAULT NULL )
120:
121: IS
122:
123: cursor return_rowid is

Line 125: from pa_transaction_interface_all

121: IS
122:
123: cursor return_rowid is
124: select rowid
125: from pa_transaction_interface_all
126: where txn_interface_id = X_txn_interface_id;
127:
128: cursor get_itemid is
129: select pa_txn_interface_s.nextval

Line 460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,

456: X_Cdl_Sys_Ref4 IN VARCHAR2 DEFAULT NULL,
457: -- PA-J changes
458: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
459: -- PA-K Changes
460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

Line 461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,

457: -- PA-J changes
458: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
459: -- PA-K Changes
460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

Line 462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,

458: X_Accrual_flag IN VARCHAR2 DEFAULT NULL,
459: -- PA-K Changes
460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

Line 463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,

459: -- PA-K Changes
460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

Line 464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,

460: P_Project_Id IN Pa_Transaction_Interface_All.Project_Id%TYPE DEFAULT NULL,
461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

Line 465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,

461: P_Task_Id IN Pa_Transaction_Interface_All.Task_Id%TYPE DEFAULT NULL,
462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

Line 466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,

462: P_Person_Business_Group_Id IN Pa_Transaction_Interface_All.Person_Business_Group_Id%TYPE DEFAULT NULL,
463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes

Line 467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,

463: P_Person_Id IN Pa_Transaction_Interface_All.Person_Id%TYPE DEFAULT NULL,
464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

Line 468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,

464: P_Organization_Id IN Pa_Transaction_Interface_All.Organization_Id%TYPE DEFAULT NULL,
465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

Line 469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,

465: P_Non_Labor_Res_Org_Id IN Pa_Transaction_Interface_All.Non_Labor_Resource_Org_Id%TYPE DEFAULT NULL,
466: P_Override_To_Org_Id IN Pa_Transaction_Interface_All.Override_To_Organization_Id%TYPE DEFAULT NULL,
467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

Line 471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,

467: P_Assignment_Id IN Pa_Transaction_Interface_All.Assignment_Id%TYPE DEFAULT NULL,
468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

Line 472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,

468: P_Work_Type_Id IN Pa_Transaction_Interface_All.Work_Type_Id%TYPE DEFAULT NULL,
469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

Line 473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,

469: P_Vendor_Id IN Pa_Transaction_Interface_All.Vendor_Id%TYPE DEFAULT NULL,
470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes

Line 474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,

470: -- Begin PA.M/CWK changes
471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

Line 475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,

471: P_PO_Number IN Pa_Transaction_Interface_All.PO_Number%TYPE DEFAULT NULL,
472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

Line 476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,

472: P_PO_Header_Id IN Pa_Transaction_Interface_All.PO_Header_Id%TYPE DEFAULT NULL,
473: P_PO_Line_Num IN Pa_Transaction_Interface_All.PO_Line_Num%TYPE DEFAULT NULL,
474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
480: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)

Line 478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,

474: P_PO_Line_Id IN Pa_Transaction_Interface_All.PO_Line_Id%TYPE DEFAULT NULL,
475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
480: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)
481: IS
482:

Line 479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,

475: P_PO_Price_Type IN Pa_Transaction_Interface_All.PO_Price_Type%TYPE DEFAULT NULL,
476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
480: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)
481: IS
482:
483: Begin

Line 480: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)

476: P_Person_Type IN Pa_Transaction_Interface_All.Person_Type%TYPE DEFAULT NULL,
477: -- End PA.M/CWK changes
478: P_Inventory_Item_Id IN Pa_Transaction_Interface_All.Inventory_Item_Id%TYPE DEFAULT NULL,
479: P_WIP_Resource_Id IN Pa_Transaction_Interface_All.WIP_Resource_Id%TYPE DEFAULT NULL,
480: P_Unit_Of_Measure IN Pa_Transaction_Interface_All.Unit_Of_Measure%TYPE DEFAULT NULL)
481: IS
482:
483: Begin
484:

Line 598: Delete From Pa_Transaction_Interface_All

594: Is
595:
596: Begin
597:
598: Delete From Pa_Transaction_Interface_All
599: Where RowId = X_RowId ;
600:
601: End Delete_Row;
602: