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.OE_APPROVALS_WF dependencies on OE_APPROVER_TRANSACTIONS

Line 82: FROM OE_APPROVER_TRANSACTIONS

78: END IF;
79:
80: -- Delete any previous approval transaction data.
81: DELETE
82: FROM OE_APPROVER_TRANSACTIONS
83: WHERE TRANSACTION_ID = l_transaction_id;
84:
85: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
86: l_sales_document_type_code := wf_engine.GetItemAttrText(

Line 304: and insert the record in OE_APPROVER_TRANSACTIONS.

300: the proper record in the OM Approval transaction table
301: OE_APPROVAL_TRANSACTIONS. Checks the max(approver_sequence) from
302: OE_APPROVAL_TRANSACTIONS given a transaction_id, and then fetches
303: the role from the OE_APPROVER_LISTS with approver_sequence = max+1
304: and insert the record in OE_APPROVER_TRANSACTIONS.
305: Returns Y if it finds the next approver and returns N if there is no
306: approver left. In the case there is no more approvers, it will update
307: the status to APPROVED
308: */

Line 355: -- in the OE_APPROVER_TRANSACTIONS

351: oe_debug_pub.add( 'Get_Next_Approver ', 1 ) ;
352: END IF;
353:
354: -- We need to set the status of the last approver to APPROVED here
355: -- in the OE_APPROVER_TRANSACTIONS
356: UPDATE OE_APPROVER_TRANSACTIONS
357: SET APPROVAL_STATUS = 'APPROVED'
358: WHERE TRANSACTION_ID = l_transaction_id
359: --- ?? phase code = not really needed

Line 356: UPDATE OE_APPROVER_TRANSACTIONS

352: END IF;
353:
354: -- We need to set the status of the last approver to APPROVED here
355: -- in the OE_APPROVER_TRANSACTIONS
356: UPDATE OE_APPROVER_TRANSACTIONS
357: SET APPROVAL_STATUS = 'APPROVED'
358: WHERE TRANSACTION_ID = l_transaction_id
359: --- ?? phase code = not really needed
360: AND APPROVER_SEQUENCE = (select max(APPROVER_SEQUENCE)

Line 361: from OE_APPROVER_TRANSACTIONS

357: SET APPROVAL_STATUS = 'APPROVED'
358: WHERE TRANSACTION_ID = l_transaction_id
359: --- ?? phase code = not really needed
360: AND APPROVER_SEQUENCE = (select max(APPROVER_SEQUENCE)
361: from OE_APPROVER_TRANSACTIONS
362: WHERE TRANSACTION_ID = l_transaction_id);
363:
364:
365: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN

Line 654: from OE_APPROVER_TRANSACTIONS

650: -------------------------------------------
651: BEGIN
652: select max(APPROVER_SEQUENCE)
653: into l_curr_approver_sequence
654: from OE_APPROVER_TRANSACTIONS
655: where TRANSACTION_ID = p_transaction_id
656: and TRANSACTION_TYPE_ID = l_transaction_type_id
657: and TRANSACTION_PHASE_CODE = l_transaction_phase_code;
658:

Line 700: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;

696:
697:
698: IF p_query_mode = 'N' THEN
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;
701: END IF;
702: -- insert this next approver in the OE_APPROVER_TRANSACTIONS
703: INSERT INTO OE_APPROVER_TRANSACTIONS
704: (

Line 702: -- insert this next approver in the OE_APPROVER_TRANSACTIONS

698: IF p_query_mode = 'N' THEN
699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;
701: END IF;
702: -- insert this next approver in the OE_APPROVER_TRANSACTIONS
703: INSERT INTO OE_APPROVER_TRANSACTIONS
704: (
705: TRANSACTION_ID
706: ,TRANSACTION_TYPE_ID --?? Do we need this. evalute

Line 703: INSERT INTO OE_APPROVER_TRANSACTIONS

699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add('Inserting into OE_APPROVER_TRANSACTIONS ', 1) ;
701: END IF;
702: -- insert this next approver in the OE_APPROVER_TRANSACTIONS
703: INSERT INTO OE_APPROVER_TRANSACTIONS
704: (
705: TRANSACTION_ID
706: ,TRANSACTION_TYPE_ID --?? Do we need this. evalute
707: ,TRANSACTION_PHASE_CODE

Line 743: OE_APPROVER_TRANSACTIONS with proper results. Perform a status

739: * Approve_Approval *
740: **************************/
741: /*
742: This procedure will update the OM Approval transaction table
743: OE_APPROVER_TRANSACTIONS with proper results. Perform a status
744: update to INTERNAL_APPROVED.
745: */
746: Procedure Approve_Approval
747: (itemtype in varchar2,

Line 1004: OE_APPROVER_TRANSACTIONS with proper results. Perform a status

1000: * Reject_Approval *
1001: *************************/
1002: /*
1003: This procedure will update the OM Approval transaction table
1004: OE_APPROVER_TRANSACTIONS with proper results. Perform a status
1005: update to DRAFT_INTERNAL_REJECTED. And update the column
1006: DRAFT_SUBMITTED_FLAG to 'N' to the base table.
1007: */
1008: Procedure Reject_Approval

Line 1040: UPDATE OE_APPROVER_TRANSACTIONS

1036: oe_debug_pub.add('Reject_Approval.. ', 1) ;
1037: END IF;
1038:
1039: BEGIN
1040: UPDATE OE_APPROVER_TRANSACTIONS
1041: SET APPROVAL_STATUS = 'REJECTED'
1042: WHERE TRANSACTION_ID = to_number(itemkey)
1043: AND APPROVER_SEQUENCE = ( select max(APPROVER_SEQUENCE)
1044: from OE_APPROVER_TRANSACTIONS

Line 1044: from OE_APPROVER_TRANSACTIONS

1040: UPDATE OE_APPROVER_TRANSACTIONS
1041: SET APPROVAL_STATUS = 'REJECTED'
1042: WHERE TRANSACTION_ID = to_number(itemkey)
1043: AND APPROVER_SEQUENCE = ( select max(APPROVER_SEQUENCE)
1044: from OE_APPROVER_TRANSACTIONS
1045: where TRANSACTION_ID = to_number(itemkey));
1046: EXCEPTION
1047: WHEN NO_DATA_FOUND THEN
1048: -- In case someone adds an additional approval notification after its approved

Line 1144: This API will hit the OE_APPROVER_TRANSACTIONS table to find the

1140: /*************************
1141: * Get_Current_Approver *
1142: *************************/
1143: /*
1144: This API will hit the OE_APPROVER_TRANSACTIONS table to find the
1145: max(approver_sequence) approver for the given transaction_id and
1146: retrieve the proper name of the approver. NID will be passed in.
1147: */
1148: Procedure Get_Current_Approver

Line 1217: from OE_APPROVER_TRANSACTIONS

1213:
1214: BEGIN
1215: select role
1216: into l_role
1217: from OE_APPROVER_TRANSACTIONS
1218: where TRANSACTION_ID = p_transaction_id
1219: and APPROVER_SEQUENCE = ( select max(APPROVER_SEQUENCE)
1220: from OE_APPROVER_TRANSACTIONS
1221: where TRANSACTION_ID = p_transaction_id);

Line 1220: from OE_APPROVER_TRANSACTIONS

1216: into l_role
1217: from OE_APPROVER_TRANSACTIONS
1218: where TRANSACTION_ID = p_transaction_id
1219: and APPROVER_SEQUENCE = ( select max(APPROVER_SEQUENCE)
1220: from OE_APPROVER_TRANSACTIONS
1221: where TRANSACTION_ID = p_transaction_id);
1222:
1223: EXCEPTION
1224: WHEN NO_DATA_FOUND THEN

Line 1226: oe_debug_pub.add('No OE_APPROVER_TRANSACTIONS for TransactionID:'

1222:
1223: EXCEPTION
1224: WHEN NO_DATA_FOUND THEN
1225: IF l_debug_level > 0 THEN
1226: oe_debug_pub.add('No OE_APPROVER_TRANSACTIONS for TransactionID:'
1227: || p_transaction_id ,1);
1228: l_role := null;-- 6615403
1229: END IF;
1230:

Line 1422: DELETE FROM oe_approver_transactions

1418: oe_debug_pub.ADD ('Initiate_Approval');
1419: END IF;
1420:
1421: -- Delete any previous approval transaction data.
1422: DELETE FROM oe_approver_transactions
1423: WHERE transaction_id = l_transaction_id;
1424:
1425: IF itemtype = oe_globals.g_wfi_ngo
1426: THEN

Line 2375: -- in the OE_APPROVER_TRANSACTIONS

2371: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_APPROVE ', 1);
2372: END IF;
2373:
2374: -- We need to set the status of the last approver to APPROVED here
2375: -- in the OE_APPROVER_TRANSACTIONS
2376: l_role :=
2377: wf_engine.getitemattrtext (itemtype,
2378: l_transaction_id,
2379: 'NOTIFICATION_APPROVER'

Line 2701: -- in the OE_APPROVER_TRANSACTIONS

2697: oe_debug_pub.ADD ('Entering PROCESS_RESPONSE_REJECT ', 1);
2698: END IF;
2699:
2700: -- We need to set the status of the last approver to APPROVED here
2701: -- in the OE_APPROVER_TRANSACTIONS
2702: l_role :=
2703: wf_engine.getitemattrtext (itemtype,
2704: l_transaction_id,
2705: 'NOTIFICATION_APPROVER'