APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PQH_PROCESS_LOG

Line 684: delete from pqh_process_log

680: ,p_effective_date => p_effective_date
681: );
682: --
683: -- Delete Log records
684: delete from pqh_process_log
685: where txn_id = p_copy_entity_txn_id
686: and module_cd = 'PDC_CP';
687:
688: PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN

Line 2393: insert into pqh_process_log

2389: ,p_message_text in varchar2
2390: ,p_message_type_cd in varchar2
2391: ) is
2392: begin
2393: insert into pqh_process_log
2394: ( process_log_id,
2395: module_cd,
2396: txn_id,
2397: message_text,

Line 2402: ( pqh_process_log_s.nextval,

2398: message_type_cd,
2399: object_version_number
2400: )
2401: Values
2402: ( pqh_process_log_s.nextval,
2403: p_module_cd,
2404: p_txn_id,
2405: p_message_text,
2406: p_message_type_cd,

Line 2751: delete from pqh_process_log

2747: end if;
2748: end loop;
2749:
2750: -- Delete Old Log Data
2751: delete from pqh_process_log
2752: where txn_id = p_copy_entity_txn_id
2753: and module_cd = 'PDC_CP';
2754:
2755: -- Insert Summary information

Line 5331: from pqh_process_log

5327: return varchar2 is
5328:
5329: cursor c_log_exists(c_copy_entity_txn_id number) is
5330: select null
5331: from pqh_process_log
5332: where txn_id = c_copy_entity_txn_id
5333: and module_cd = 'PDC_CP'
5334: and rownum = 1;
5335: