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 368: Procedure Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,

364: -- P_User_Id: User Id
365:
366: /*--------------------------------------------------------------------------*/
367:
368: Procedure Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
369: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
370: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
371: P_User_Id IN NUMBER) IS
372:

Line 369: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

365:
366: /*--------------------------------------------------------------------------*/
367:
368: Procedure Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
369: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
370: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
371: P_User_Id IN NUMBER) IS
372:
373: l_Txn_Rowid RowId := Null;

Line 370: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

366: /*--------------------------------------------------------------------------*/
367:
368: Procedure Upload_Otc_Timecards(P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
369: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
370: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
371: P_User_Id IN NUMBER) IS
372:
373: l_Txn_Rowid RowId := Null;
374: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;

Line 374: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;

370: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
371: P_User_Id IN NUMBER) IS
372:
373: l_Txn_Rowid RowId := Null;
374: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;
375: l_Where_Clause Varchar2(2000);
376: l_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE;
377: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
378: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;

Line 376: l_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE;

372:
373: l_Txn_Rowid RowId := Null;
374: l_Txn_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := NULL;
375: l_Where_Clause Varchar2(2000);
376: l_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE;
377: l_Override_Approver_Id Pa_Expenditures_All.Overriding_Approver_Person_Id%TYPE;
378: l_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
379: l_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE;
380: l_Insert_Rec_Flag Boolean := False;

Line 1560: -- P_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE

1556: -- Parameters :
1557: -- IN
1558: -- P_Old_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1559: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1560: -- P_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE
1561: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1562: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
1563: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
1564:

Line 1563: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE

1559: -- P_New_Orig_Trx_Ref Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE
1560: -- P_Batch_Name Pa_Transaction_Interface_All.Batch_Name%TYPE
1561: -- P_User_Id Pa_Expenditure_Items_All.Last_Updated_By%TYPE
1562: -- P_Orig_Exp_Txn_Reference1 Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE
1563: -- P_Xface_Id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE
1564:
1565: /*------------------------------------------------------------------------- */
1566:
1567: Procedure Build_Reverse_Item(

Line 1570: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

1566:
1567: Procedure Build_Reverse_Item(
1568: P_Old_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1569: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1570: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
1571: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
1572: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
1573: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE )
1574:

Line 1573: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE )

1569: P_New_Orig_Trx_Ref IN Pa_Expenditure_Items_All.Orig_Transaction_Reference%TYPE,
1570: P_Batch_Name IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
1571: P_User_Id IN Pa_Expenditure_Items_All.Last_Updated_By%TYPE,
1572: P_Orig_Exp_Txn_Reference1 IN Pa_Expenditures_All.Orig_Exp_Txn_Reference1%TYPE,
1573: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE )
1574:
1575: Is
1576:
1577: l_txn_rowid RowId := Null;

Line 1578: l_txn_xface_id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := Null;

1574:
1575: Is
1576:
1577: l_txn_rowid RowId := Null;
1578: l_txn_xface_id Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE := Null;
1579:
1580: l_Exp_End_Date Pa_Expenditures_All.Expenditure_Ending_Date%TYPE;
1581: l_Inc_By_Org_Id Hr_Organization_Units.Organization_Id%TYPE;
1582: l_Exp_Item_Date Pa_Expenditure_Items_All.Expenditure_Item_Date%TYPE;

Line 2210: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,

2206: -- none
2207: /*--------------------------------------------------------------------------*/
2208:
2209: Procedure Tieback_Otc_Timecards (
2210: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
2211: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
2212: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
2213: P_User_Id IN Number)
2214:

Line 2211: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,

2207: /*--------------------------------------------------------------------------*/
2208:
2209: Procedure Tieback_Otc_Timecards (
2210: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
2211: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
2212: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
2213: P_User_Id IN Number)
2214:
2215: Is

Line 2212: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,

2208:
2209: Procedure Tieback_Otc_Timecards (
2210: P_Transaction_Source IN Pa_Transaction_Interface_All.Transaction_Source%TYPE,
2211: P_Batch IN Pa_Transaction_Interface_All.Batch_Name%TYPE,
2212: P_Xface_Id IN Pa_Transaction_Interface_All.Txn_Interface_Id%TYPE,
2213: P_User_Id IN Number)
2214:
2215: Is
2216:

Line 2217: Cursor TrxRecords (P_Interface_Id IN Pa_Transaction_Interface_All.Interface_Id%TYPE) Is

2213: P_User_Id IN Number)
2214:
2215: Is
2216:
2217: Cursor TrxRecords (P_Interface_Id IN Pa_Transaction_Interface_All.Interface_Id%TYPE) Is
2218: Select To_Number(Substr(Orig_Transaction_Reference,1,Instr(Orig_Transaction_Reference,':') - 1)) Detail_BB_Id,
2219: Transaction_Status_Code,
2220: Transaction_Rejection_Code,
2221: Txn_Interface_Id,

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

2431: -- Pre-Reqs : None
2432: -- Type : Procedure
2433: -- Function : This procedure determines if the expenditure item should be updated directly
2434: -- : or if a reversing entry and a new entry neeed to be inserted into table
2435: -- : pa_transaction_interface_all. This is done by comparing to see what has
2436: -- : actually changed. If only the dff and/or the item comment has changed and
2437: -- : nothing else then the item should be directly updated.
2438: --
2439: -- Parameters :

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

9698: -- : Used in the Upload_Otc_Timecards() procedure.
9699: --
9700: -- Parameters :
9701: -- IN
9702: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
9703: -- OUT
9704: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
9705: /*--------------------------------------------------------------------------*/
9706:

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

9700: -- Parameters :
9701: -- IN
9702: -- P_Exp_End_Date - Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE
9703: -- OUT
9704: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
9705: /*--------------------------------------------------------------------------*/
9706:
9707: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
9708: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE)

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

9703: -- OUT
9704: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
9705: /*--------------------------------------------------------------------------*/
9706:
9707: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
9708: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE)
9709:
9710: Is
9711:

Line 9708: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE)

9704: -- X_Batch_Name - Pa_Transaction_Interface_All.Batch_Name%TYPE
9705: /*--------------------------------------------------------------------------*/
9706:
9707: Procedure GetBatchName (P_Exp_End_Date IN Pa_Transaction_Interface_All.Expenditure_Ending_Date%TYPE,
9708: X_Batch_Name OUT NOCOPY Pa_Transaction_Interface_All.Batch_Name%TYPE)
9709:
9710: Is
9711:
9712: l_Found_Match Boolean := False;