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 126: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,

122: TYPE Message_Tokens IS Table OF Message_Token
123: INDEX BY Binary_Integer;
124:
125: TYPE EndDateBatchName_Rec IS Record (
126: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
127: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);
128:
129: TYPE EndDateBatchName_Tab IS Table OF EndDateBatchName_Rec
130: INDEX BY Binary_Integer;

Line 127: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);

123: INDEX BY Binary_Integer;
124:
125: TYPE EndDateBatchName_Rec IS Record (
126: Expenditure_Ending_Date Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
127: Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE);
128:
129: TYPE EndDateBatchName_Tab IS Table OF EndDateBatchName_Rec
130: INDEX BY Binary_Integer;
131:

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

211: -- Function : This procedure is used to pull approved self service
212: -- timecards into transaction interface table.
213: -- Parameters :
214: -- IN
215: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
216: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
217: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
218: -- P_User_Id - Number
219:

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

212: -- timecards into transaction interface table.
213: -- Parameters :
214: -- IN
215: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
216: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
217: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
218: -- P_User_Id - Number
219:
220: /*--------------------------------------------------------------------------*/

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

213: -- Parameters :
214: -- IN
215: -- P_Transaction_Source: - Pa_Transaction_Interface_All.Transaction_Source%TYPE
216: -- P_Batch: - Pa_Transaction_Interface_All.Batch_Name%TYPE
217: -- P_Xface_Id - Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
218: -- P_User_Id - Number
219:
220: /*--------------------------------------------------------------------------*/
221:

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

218: -- P_User_Id - Number
219:
220: /*--------------------------------------------------------------------------*/
221:
222: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
223: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
224: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
225: P_User_Id IN Number);
226:

Line 223: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

219:
220: /*--------------------------------------------------------------------------*/
221:
222: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
223: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
224: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
225: P_User_Id IN Number);
226:
227:

Line 224: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

220: /*--------------------------------------------------------------------------*/
221:
222: PROCEDURE Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
223: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
224: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
225: P_User_Id IN Number);
226:
227:
228: -- =======================================================================

Line 251: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE

247: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
248: -- P_Batch_Name Varchar2
249: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
250: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
251: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
252:
253: /*------------------------------------------------------------------------- */
254:
255: Procedure Build_Reverse_Item(

Line 258: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

254:
255: Procedure Build_Reverse_Item(
256: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
257: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
258: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
259: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
260: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
261: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
262:

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

257: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
258: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
259: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
260: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
261: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE);
262:
263: -- =======================================================================
264: -- Start of Comments
265: -- API Name : UpdateChangedOrigTxn

Line 321: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,

317: -- none
318: /*--------------------------------------------------------------------------*/
319:
320: Procedure Tieback_Otc_Timecards (
321: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
322: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
323: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
324: P_User_Id IN Number);
325:

Line 322: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

318: /*--------------------------------------------------------------------------*/
319:
320: Procedure Tieback_Otc_Timecards (
321: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
322: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
323: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
324: P_User_Id IN Number);
325:
326: -- =======================================================================

Line 323: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

319:
320: Procedure Tieback_Otc_Timecards (
321: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
322: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
323: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
324: P_User_Id IN Number);
325:
326: -- =======================================================================
327: -- Start of Comments

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

330: -- Pre-Reqs : None
331: -- Type : Procedure
332: -- Function : This procedure determines if the expenditure item should be updated directly
333: -- : or if a reversing entry and a new entry neeed to be inserted into table
334: -- : pa_transaction_interface_all. This is done by comparing to see what has
335: -- : actually changed. If only the dff and/or the item comment has changed and
336: -- : nothing else then the expenditure item should be directly updated.
337: --
338: -- Parameters :

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

1028: -- to only create single batch_name for each Ending_Date for a Trx Import run.
1029: --
1030: -- Parameters :
1031: -- IN
1032: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
1033: -- OUT
1034: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1035: /*--------------------------------------------------------------------------*/
1036:

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

1030: -- Parameters :
1031: -- IN
1032: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
1033: -- OUT
1034: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1035: /*--------------------------------------------------------------------------*/
1036:
1037: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1038: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);

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

1033: -- OUT
1034: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1035: /*--------------------------------------------------------------------------*/
1036:
1037: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1038: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);
1039:
1040:
1041: -- =======================================================================

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

1034: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
1035: /*--------------------------------------------------------------------------*/
1036:
1037: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
1038: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE);
1039:
1040:
1041: -- =======================================================================
1042: -- Start of Comments