DBA Data[Home] [Help]

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.0 2005/05/29 02:22:18 appldev noship $*/
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 2023: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';

2019: l_trans_tbl hr_transaction_ss.transaction_table;
2020: l_count NUMBER :=0;
2021: l_transaction_step_id NUMBER;
2022: l_api_name hr_api_transaction_steps.api_name%TYPE
2023: := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';
2024: l_result VARCHAR2(100);
2025: l_trns_object_version_number NUMBER;
2026: l_review_proc_call VARCHAR2(30) := 'PqpVehDelReview';
2027: l_effective_date DATE := SYSDATE;

Line 2323: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';

2319: l_trans_tbl hr_transaction_ss.transaction_table;
2320: l_count NUMBER :=0;
2321: l_transaction_step_id NUMBER;
2322: l_api_name hr_api_transaction_steps.api_name%TYPE
2323: := 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API';
2324: l_result VARCHAR2(100);
2325: l_trns_object_version_number number;
2326: l_review_proc_call VARCHAR2(30) := 'PqpVehInfoReview';
2327: l_effective_date DATE := SYSDATE;

Line 4394: END PQP_SS_VEHICLE_TRANSACTIONS;

4390: WHEN OTHERS THEN
4391: RAISE; -- Raise error here relevant to the new tech stack.
4392:
4393: END delete_allocation;
4394: END PQP_SS_VEHICLE_TRANSACTIONS;