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_OTC_API dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 109: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,

105: TYPE Message_Tokens IS Table OF Message_Token
106: INDEX BY Binary_Integer;
107:
108: TYPE EndDateBatchName_Rec IS Record (
109: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
110: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);
111:
112: TYPE EndDateBatchName_Tab IS Table OF EndDateBatchName_Rec
113: INDEX BY Binary_Integer;

Line 110: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);

106: INDEX BY Binary_Integer;
107:
108: TYPE EndDateBatchName_Rec IS Record (
109: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
110: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);
111:
112: TYPE EndDateBatchName_Tab IS Table OF EndDateBatchName_Rec
113: INDEX BY Binary_Integer;
114:

Line 198: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE

194: -- Function : This procedure is used to pull approved self service
195: -- timecards into transaction interface table.
196: -- Parameters :
197: -- IN
198: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
199: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
200: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
201: -- P_User_Id - Number
202:

Line 199: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE

195: -- timecards into transaction interface table.
196: -- Parameters :
197: -- IN
198: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
199: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
200: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
201: -- P_User_Id - Number
202:
203: /*--------------------------------------------------------------------------*/

Line 200: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE

196: -- Parameters :
197: -- IN
198: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
199: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
200: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
201: -- P_User_Id - Number
202:
203: /*--------------------------------------------------------------------------*/
204:

Line 205: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,

201: -- P_User_Id - Number
202:
203: /*--------------------------------------------------------------------------*/
204:
205: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
206: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
207: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
208: P_User_Id IN Number);
209:

Line 206: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

202:
203: /*--------------------------------------------------------------------------*/
204:
205: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
206: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
207: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
208: P_User_Id IN Number);
209:
210:

Line 207: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

203: /*--------------------------------------------------------------------------*/
204:
205: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
206: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
207: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
208: P_User_Id IN Number);
209:
210:
211: -- =======================================================================

Line 234: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE

230: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
231: -- P_Batch_Name Varchar2
232: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
233: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
234: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
235:
236: /*------------------------------------------------------------------------- */
237:
238: Procedure Build_Reverse_Item(

Line 241: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

237:
238: Procedure Build_Reverse_Item(
239: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
240: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
241: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
242: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
243: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
244: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
245:

Line 244: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);

240: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
241: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
242: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
243: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
244: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
245:
246: -- =======================================================================
247: -- Start of Comments
248: -- API Name : UpdateChangedOrigTxn

Line 304: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,

300: -- none
301: /*--------------------------------------------------------------------------*/
302:
303: Procedure Tieback_Otc_Timecards (
304: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
305: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
306: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
307: P_User_Id IN Number);
308:

Line 305: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

301: /*--------------------------------------------------------------------------*/
302:
303: Procedure Tieback_Otc_Timecards (
304: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
305: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
306: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
307: P_User_Id IN Number);
308:
309: -- =======================================================================

Line 306: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

302:
303: Procedure Tieback_Otc_Timecards (
304: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
305: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
306: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
307: P_User_Id IN Number);
308:
309: -- =======================================================================
310: -- Start of Comments

Line 317: -- : pa_transaction_interface_all. This is done by comparing to see what has

313: -- Pre-Reqs : None
314: -- Type : Procedure
315: -- Function : This procedure determines if the expenditure item should be updated directly
316: -- : or if a reversing entry and a new entry neeed to be inserted into table
317: -- : pa_transaction_interface_all. This is done by comparing to see what has
318: -- : actually changed. If only the dff and/or the item comment has changed and
319: -- : nothing else then the expenditure item should be directly updated.
320: --
321: -- Parameters :

Line 997: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE

993: -- to only create single batch_name for each Ending_Date for a Trx Import run.
994: --
995: -- Parameters :
996: -- IN
997: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
998: -- OUT
999: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1000: /*--------------------------------------------------------------------------*/
1001:

Line 999: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE

995: -- Parameters :
996: -- IN
997: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
998: -- OUT
999: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1000: /*--------------------------------------------------------------------------*/
1001:
1002: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1003: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);

Line 1002: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,

998: -- OUT
999: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1000: /*--------------------------------------------------------------------------*/
1001:
1002: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1003: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);
1004:
1005:
1006: -- =======================================================================

Line 1003: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);

999: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1000: /*--------------------------------------------------------------------------*/
1001:
1002: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1003: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);
1004:
1005:
1006: -- =======================================================================
1007: -- Start of Comments