APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on PQH_COPY_ENTITY_TXNS

Line 11: From pqh_copy_entity_txns

7: ,p_effective_date OUT NOCOPY DATE
8: ) IS
9: Cursor csr_txn_details is
10: Select SRC_EFFECTIVE_DATE,CONTEXT_BUSINESS_GROUP_ID
11: From pqh_copy_entity_txns
12: Where copy_entity_txn_id=p_copy_entity_txn_id;
13: BEGIN
14: OPEN csr_txn_details;
15: FETCH csr_txn_details into p_effective_date, p_business_group_id ;

Line 252: pqh_copy_entity_txns

248: hr_utility.set_location('Entering: '||l_proc,10);
249: select
250: context_business_group_id into l_business_group_id
251: from
252: pqh_copy_entity_txns
253: where
254: copy_entity_txn_id = p_copy_entity_txn_id;
255:
256: select

Line 3902: l_effective_date pqh_copy_entity_txns.SRC_EFFECTIVE_DATE%TYPE;

3898: and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date);
3899:
3900: l_name ben_copy_entity_results.information170%TYPE;
3901: l_table_name pqh_table_route.where_clause%TYPE;
3902: l_effective_date pqh_copy_entity_txns.SRC_EFFECTIVE_DATE%TYPE;
3903: l_bg_id pqh_copy_entity_txns.CONTEXT_BUSINESS_GROUP_ID%TYPE;
3904: Begin
3905: get_txn_details(
3906: p_copy_entity_txn_id,

Line 3903: l_bg_id pqh_copy_entity_txns.CONTEXT_BUSINESS_GROUP_ID%TYPE;

3899:
3900: l_name ben_copy_entity_results.information170%TYPE;
3901: l_table_name pqh_table_route.where_clause%TYPE;
3902: l_effective_date pqh_copy_entity_txns.SRC_EFFECTIVE_DATE%TYPE;
3903: l_bg_id pqh_copy_entity_txns.CONTEXT_BUSINESS_GROUP_ID%TYPE;
3904: Begin
3905: get_txn_details(
3906: p_copy_entity_txn_id,
3907: l_bg_id,

Line 4996: l_context pqh_copy_entity_txns.context%type;

4992:
4993: PROCEDURE mark_future_data_exists(p_copy_entity_txn_id in NUMBER)
4994: AS
4995:
4996: l_context pqh_copy_entity_txns.context%type;
4997: -- PRAGMA AUTONOMOUS_TRANSACTION;
4998: BEGIN
4999:
5000: select context into l_context

Line 5001: from pqh_copy_entity_txns

4997: -- PRAGMA AUTONOMOUS_TRANSACTION;
4998: BEGIN
4999:
5000: select context into l_context
5001: from pqh_copy_entity_txns
5002: where copy_entity_txn_id = p_copy_entity_txn_id ;
5003:
5004: -- If it is "GSP" context (Eligibility integration with GSP)
5005: -- donot execute Mark Future Data exists code

Line 5194: update pqh_copy_entity_txns

5190: ,argument6 => p_object_version_number
5191: ,argument7 => fnd_date.date_to_canonical(p_effective_date)
5192: ,argument8 => p_no_dup_rslt);
5193:
5194: update pqh_copy_entity_txns
5195: set status = 'COPYING_IN_PROGRESS'
5196: ,start_with = null
5197: where copy_entity_txn_id = p_copy_entity_txn_id;
5198: end if;

Line 5232: update pqh_copy_entity_txns

5228: );
5229: -- update the tasklist row
5230: update_task_list_row(p_copy_entity_txn_id,fnd_date.canonical_to_date(p_effective_date));
5231: -- update the status of the row.
5232: update pqh_copy_entity_txns
5233: set status = 'COPIED' /* To disable View Log Icon */
5234: ,start_with = 'BEN_PDW_PLN_OVVW_FUNC' /*enable the continue icon*/
5235: where copy_entity_txn_id = p_copy_entity_txn_id;
5236:

Line 5245: update pqh_copy_entity_txns

5241: when others then
5242:
5243: rollback;
5244: -- update the txn row
5245: update pqh_copy_entity_txns
5246: set status = 'ERROR' /* To disable View Log Icon */
5247: ,start_with = null /*disable the continue icon*/
5248: where copy_entity_txn_id = p_copy_entity_txn_id;
5249: commit;

Line 5289: update pqh_copy_entity_txns

5285: ,program => 'BEPDWELG'
5286: ,description => NULL
5287: ,sub_request => FALSE
5288: ,argument1 => p_copy_entity_txn_id);
5289: update pqh_copy_entity_txns
5290: set status = 'COPYING_IN_PROGRESS'
5291: ,start_with = null
5292: where copy_entity_txn_id = p_copy_entity_txn_id;
5293: end if;

Line 5311: update pqh_copy_entity_txns

5307: begin
5308: -- copy all the eligibility profiles, zip code and benefit groups in this process.
5309: copy_elig_pzip_bnftgrp(p_copy_entity_txn_id);
5310: -- update the status of the row.
5311: update pqh_copy_entity_txns
5312: set status = 'COPIED' /* To disable View Log Icon */
5313: ,start_with = 'BEN_PDW_PLN_OVVW_FUNC' /*show the continue icon*/
5314: where copy_entity_txn_id = p_copy_entity_txn_id;
5315:

Line 5321: update pqh_copy_entity_txns

5317: exception
5318: when others then
5319: rollback;
5320: -- update the txn row
5321: update pqh_copy_entity_txns
5322: set status = 'ERROR' /* To disable View Log Icon */
5323: ,start_with = null /*disable the continue icon*/
5324: where copy_entity_txn_id = p_copy_entity_txn_id;
5325: commit;