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.PQP_SS_VEHICLE_TRANSACTIONS dependencies on PQP_SS_VEHICLE_TRANSACTIONS

Line 1: PACKAGE BODY PQP_SS_VEHICLE_TRANSACTIONS AS

1: PACKAGE BODY PQP_SS_VEHICLE_TRANSACTIONS AS
2: /* $Header: pqpssvehinfo.pkb 120.3.12020000.2 2012/07/05 12:17:59 amnaraya ship $*/
3:
4:
5:

Line 371: AND s.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'

367: WHERE s.transaction_step_id = a.transaction_step_id
368: AND s1.transaction_step_id = b.transaction_step_id
369: AND s2.transaction_step_id = c.transaction_step_id
370: AND s.transaction_step_id = p_transaction_step_id
371: AND s.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
372: AND a.name like 'P_PERSON_USR_ID%'
373: AND s1.transaction_step_id = p_transaction_step_id
374: AND s1.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
375: AND b.name like 'P_ASSIGNMENT_USR_ID%'

Line 374: AND s1.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'

370: AND s.transaction_step_id = p_transaction_step_id
371: AND s.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
372: AND a.name like 'P_PERSON_USR_ID%'
373: AND s1.transaction_step_id = p_transaction_step_id
374: AND s1.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
375: AND b.name like 'P_ASSIGNMENT_USR_ID%'
376: AND s2.transaction_step_id = p_transaction_step_id
377: AND s2.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
378: AND c.name like 'P_USER_TYPE%'

Line 377: AND s2.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'

373: AND s1.transaction_step_id = p_transaction_step_id
374: AND s1.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
375: AND b.name like 'P_ASSIGNMENT_USR_ID%'
376: AND s2.transaction_step_id = p_transaction_step_id
377: AND s2.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
378: AND c.name like 'P_USER_TYPE%'
379: AND substr(a.name,-1) = substr(b.name,-1)
380: AND substr(a.name,-1) = substr(c.name,-1);
381:

Line 2036: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';

2032: l_trans_tbl hr_transaction_ss.transaction_table;
2033: l_count NUMBER :=0;
2034: l_transaction_step_id NUMBER;
2035: l_api_name hr_api_transaction_steps.api_name%TYPE
2036: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';
2037: l_result VARCHAR2(100);
2038: l_trns_object_version_number NUMBER;
2039: l_review_proc_call VARCHAR2(30) := 'PqpVehDelReview';
2040: l_effective_date DATE := SYSDATE;

Line 2336: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';

2332: l_trans_tbl hr_transaction_ss.transaction_table;
2333: l_count NUMBER :=0;
2334: l_transaction_step_id NUMBER;
2335: l_api_name hr_api_transaction_steps.api_name%TYPE
2336: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';
2337: l_result VARCHAR2(100);
2338: l_trns_object_version_number number;
2339: l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';
2340: l_effective_date DATE := SYSDATE;

Line 4419: END PQP_SS_VEHICLE_TRANSACTIONS;

4415: WHEN OTHERS THEN
4416: RAISE; -- Raise error here relevant to the new tech stack.
4417:
4418: END delete_allocation;
4419: END PQP_SS_VEHICLE_TRANSACTIONS;