APPS.PQH_GENERIC_PURGE dependencies on PQH_PROCESS_LOG

Line 122: FROM pqh_process_log

118: PROCEDURE delete_process_log_data(p_pk_value IN Number ) IS
119: CURSOR csr_process_log_id(p_txn_value IN NUMBER,
120: p_short_name IN VARCHAR2) IS
121: SELECT process_log_id,object_version_number
122: FROM pqh_process_log
123: WHERE module_cd = UPPER(p_short_name)
124: START WITH process_log_id = (SELECT process_log_id
125: FROM pqh_process_log
126: WHERE module_cd = UPPER(p_short_name)

Line 125: FROM pqh_process_log

121: SELECT process_log_id,object_version_number
122: FROM pqh_process_log
123: WHERE module_cd = UPPER(p_short_name)
124: START WITH process_log_id = (SELECT process_log_id
125: FROM pqh_process_log
126: WHERE module_cd = UPPER(p_short_name)
127: AND master_process_log_id IS NULL
128: AND txn_id = p_txn_value)
129: CONNECT BY master_process_log_id = PRIOR process_log_id

Line 139: pqh_process_log_api.delete_process_log

135: end if;
136: hr_utility.set_location('Entering '||l_proc,10);
137: FOR i IN csr_process_log_id(p_pk_value,g_short_name)
138: LOOP
139: pqh_process_log_api.delete_process_log
140: (p_validate => false
141: ,p_process_log_id => i.process_log_id
142: ,p_object_version_number => i.object_version_number
143: ,p_effective_date => SYSDATE

Line 516: process_log_id from pqh_process_log

512: CURSOR
513: get_process_log_id(p_txn_value IN NUMBER,
514: l_short_name IN VARCHAR2) IS
515: SELECT
516: process_log_id from pqh_process_log
517: WHERE txn_id = p_txn_value AND module_cd = UPPER(l_short_name);
518:
519: CURSOR get_plog_ovn(l_process_log_id IN NUMBER) IS
520: SELECT

Line 521: object_version_number from pqh_process_log

517: WHERE txn_id = p_txn_value AND module_cd = UPPER(l_short_name);
518:
519: CURSOR get_plog_ovn(l_process_log_id IN NUMBER) IS
520: SELECT
521: object_version_number from pqh_process_log
522: WHERE
523: process_log_id = l_process_log_id;
524: */
525: --