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_GB_TP_EXT_PROCESS dependencies on PQP_GB_T1_PENSION_EXTRACTS

Line 1431: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;

1427: l_dev_phase VARCHAR2(80);
1428: l_dev_status VARCHAR2(80);
1429: l_message VARCHAR2(80);
1430:
1431: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1432:
1433: l_proc_name VARCHAR2 (80) := g_proc_name
1434: || 'set_cross_person_records';
1435:

Line 1444: OPEN pqp_gb_t1_pension_extracts.csr_multiproc_data

1440: debug('Entering :'||l_proc_name, 10);
1441: END IF;
1442:
1443: -- Get the master row data
1444: OPEN pqp_gb_t1_pension_extracts.csr_multiproc_data
1445: (p_record_type => 'M'
1446: ,p_national_identifier => NULL
1447: -- Bugfix 3671727:ENH1: Now passing lea number
1448: ,p_lea_number => g_lea_number

Line 1451: FETCH pqp_gb_t1_pension_extracts.csr_multiproc_data INTO l_multiproc_data;

1447: -- Bugfix 3671727:ENH1: Now passing lea number
1448: ,p_lea_number => g_lea_number
1449: ,p_ext_dfn_id => p_ext_dfn_id
1450: );
1451: FETCH pqp_gb_t1_pension_extracts.csr_multiproc_data INTO l_multiproc_data;
1452:
1453: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN
1454:
1455: IF g_debug THEN

Line 1453: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN

1449: ,p_ext_dfn_id => p_ext_dfn_id
1450: );
1451: FETCH pqp_gb_t1_pension_extracts.csr_multiproc_data INTO l_multiproc_data;
1452:
1453: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN
1454:
1455: IF g_debug THEN
1456: debug('Found row in csr_multiproc_data', 20);
1457: END IF;

Line 1516: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;

1512: ELSE
1513: -- Raise error with message that there is already
1514: -- another TPA Master Extract Process running,
1515: -- can not submit a second one
1516: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1517:
1518: -- Exiting because another process is running and you can not submit twice
1519: fnd_message.set_name('PQP', 'PQP_230036_MULTIPLE_TP_EXT_ERR');
1520: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1561: END IF; -- pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN

1557: IF g_debug THEN
1558: debug('Inserted master BG row with :'||to_char(p_business_group_id), 60);
1559: END IF;
1560:
1561: END IF; -- pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN
1562:
1563: -- Close the cursor if its still open
1564: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%ISOPEN THEN
1565: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;

Line 1564: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%ISOPEN THEN

1560:
1561: END IF; -- pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN
1562:
1563: -- Close the cursor if its still open
1564: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%ISOPEN THEN
1565: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1566: END IF;
1567:
1568: -- Step 3.2) Updating multiproc data

Line 1565: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;

1561: END IF; -- pqp_gb_t1_pension_extracts.csr_multiproc_data%FOUND THEN
1562:
1563: -- Close the cursor if its still open
1564: IF pqp_gb_t1_pension_extracts.csr_multiproc_data%ISOPEN THEN
1565: CLOSE pqp_gb_t1_pension_extracts.csr_multiproc_data;
1566: END IF;
1567:
1568: -- Step 3.2) Updating multiproc data
1569: UPDATE pqp_ext_cross_person_records

Line 1685: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;

1681: l_err_msg fnd_new_messages.message_text%TYPE;
1682:
1683: l_lea_details pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1684: l_lea_dets_frm_bg pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1685: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1686: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1687:
1688: l_ext_udt_id pay_user_tables.user_table_id%TYPE;
1689: l_bg_name per_business_groups_perf.name%TYPE := NULL;

Line 1909: FOR l_BG_dets IN pqp_gb_t1_pension_extracts.csr_all_business_groups

1905: AND
1906: l_lea_details.crossbg_enabled = 'Y' THEN
1907:
1908: -- Loop thru all the LEA BGs enabled for Cross BG reporting
1909: FOR l_BG_dets IN pqp_gb_t1_pension_extracts.csr_all_business_groups
1910: (l_lea_details.lea_number
1911: ,p_business_group_id
1912: )
1913: LOOP