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_TP_PENSION_EXTRACTS

Line 1056: l_val_02 := pqp_gb_tp_pension_extracts.get_total_number_data_records(' ');

1052: --
1053: -- Update trailer data element with the correct value
1054: --
1055: ben_ext_thread.g_ext_rslt_id := l_master_ext_rslt_id;
1056: l_val_02 := pqp_gb_tp_pension_extracts.get_total_number_data_records(' ');
1057: l_val_03 := pqp_gb_tp_pension_extracts.get_total_number_data_records('1');
1058:
1059: IF g_debug
1060: THEN

Line 1057: l_val_03 := pqp_gb_tp_pension_extracts.get_total_number_data_records('1');

1053: -- Update trailer data element with the correct value
1054: --
1055: ben_ext_thread.g_ext_rslt_id := l_master_ext_rslt_id;
1056: l_val_02 := pqp_gb_tp_pension_extracts.get_total_number_data_records(' ');
1057: l_val_03 := pqp_gb_tp_pension_extracts.get_total_number_data_records('1');
1058:
1059: IF g_debug
1060: THEN
1061: DEBUG ('Total Number of Data Records: '

Line 1693: l_lea_details pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;

1689: l_dev_status VARCHAR2(80);
1690: l_message VARCHAR2(80);
1691: l_err_msg fnd_new_messages.message_text%TYPE;
1692:
1693: l_lea_details pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1694: l_lea_dets_frm_bg pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1695: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1696: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1697:

Line 1694: l_lea_dets_frm_bg pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;

1690: l_message VARCHAR2(80);
1691: l_err_msg fnd_new_messages.message_text%TYPE;
1692:
1693: l_lea_details pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1694: l_lea_dets_frm_bg pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1695: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1696: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1697:
1698: l_ext_udt_id pay_user_tables.user_table_id%TYPE;

Line 1696: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;

1692:
1693: l_lea_details pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1694: l_lea_dets_frm_bg pqp_gb_tp_pension_extracts.csr_lea_details%ROWTYPE;
1695: l_multiproc_data pqp_gb_t1_pension_extracts.csr_multiproc_data%ROWTYPE;
1696: l_lea_dets_by_loc pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%ROWTYPE;
1697:
1698: l_ext_udt_id pay_user_tables.user_table_id%TYPE;
1699: l_bg_name per_business_groups_perf.name%TYPE := NULL;
1700:

Line 1771: OPEN pqp_gb_tp_pension_extracts.csr_lea_details_by_loc(l_location_id);

1767: debug(l_proc_name, 40);
1768: END IF;
1769:
1770: -- Step 1) Getting LEA Number from Org linked to the location
1771: OPEN pqp_gb_tp_pension_extracts.csr_lea_details_by_loc(l_location_id);
1772: FETCH pqp_gb_tp_pension_extracts.csr_lea_details_by_loc INTO l_lea_dets_by_loc;
1773:
1774: IF (pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%FOUND
1775: AND

Line 1772: FETCH pqp_gb_tp_pension_extracts.csr_lea_details_by_loc INTO l_lea_dets_by_loc;

1768: END IF;
1769:
1770: -- Step 1) Getting LEA Number from Org linked to the location
1771: OPEN pqp_gb_tp_pension_extracts.csr_lea_details_by_loc(l_location_id);
1772: FETCH pqp_gb_tp_pension_extracts.csr_lea_details_by_loc INTO l_lea_dets_by_loc;
1773:
1774: IF (pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%FOUND
1775: AND
1776: l_lea_dets_by_loc.lea_number IS NOT NULL

Line 1774: IF (pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%FOUND

1770: -- Step 1) Getting LEA Number from Org linked to the location
1771: OPEN pqp_gb_tp_pension_extracts.csr_lea_details_by_loc(l_location_id);
1772: FETCH pqp_gb_tp_pension_extracts.csr_lea_details_by_loc INTO l_lea_dets_by_loc;
1773:
1774: IF (pqp_gb_tp_pension_extracts.csr_lea_details_by_loc%FOUND
1775: AND
1776: l_lea_dets_by_loc.lea_number IS NOT NULL
1777: ) THEN
1778:

Line 1788: OPEN pqp_gb_tp_pension_extracts.csr_lea_details

1784: debug(l_proc_name, 45);
1785: END IF;
1786:
1787: -- Step 2) Look for LEA Number at BG level
1788: OPEN pqp_gb_tp_pension_extracts.csr_lea_details
1789: (p_organization_id => p_business_group_id
1790: ,p_lea_number => NULL
1791: );
1792: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_dets_frm_bg;

Line 1792: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_dets_frm_bg;

1788: OPEN pqp_gb_tp_pension_extracts.csr_lea_details
1789: (p_organization_id => p_business_group_id
1790: ,p_lea_number => NULL
1791: );
1792: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_dets_frm_bg;
1793:
1794: IF (pqp_gb_tp_pension_extracts.csr_lea_details%FOUND
1795: AND
1796: l_lea_dets_frm_bg.lea_number IS NOT NULL

Line 1794: IF (pqp_gb_tp_pension_extracts.csr_lea_details%FOUND

1790: ,p_lea_number => NULL
1791: );
1792: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_dets_frm_bg;
1793:
1794: IF (pqp_gb_tp_pension_extracts.csr_lea_details%FOUND
1795: AND
1796: l_lea_dets_frm_bg.lea_number IS NOT NULL
1797: ) THEN
1798:

Line 1804: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;

1800:
1801: ELSE -- NOT FOUND or LEA Number is NULL
1802:
1803: -- Close both cursors
1804: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;
1805: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1806:
1807: -- Error out as the current BG is not set up as an LEA
1808: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);

Line 1805: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;

1801: ELSE -- NOT FOUND or LEA Number is NULL
1802:
1803: -- Close both cursors
1804: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;
1805: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1806:
1807: -- Error out as the current BG is not set up as an LEA
1808: fail_current_extract_run(p_ext_dfn_id => p_ext_dfn_id);
1809:

Line 1822: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;

1818: RETURN;
1819:
1820: END IF; -- Chk Lea number from BG Level
1821:
1822: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1823:
1824: END IF; -- Step 1) Getting LEA Number from Org linked to the location
1825:
1826: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;

Line 1826: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;

1822: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1823:
1824: END IF; -- Step 1) Getting LEA Number from Org linked to the location
1825:
1826: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details_by_loc;
1827:
1828: END IF; -- g_lea_number IS NULL
1829: --
1830: END IF; -- Check report type

Line 1839: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes(p_ext_dfn_id);

1835: debug('l_location_code :'||nvl(l_location_code,'NULL'), 70);
1836: END IF;
1837:
1838: -- Step 2.3) Get the UDT name using p_ext_dfn_id
1839: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes(p_ext_dfn_id);
1840: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes
1841: INTO g_extract_type, g_extract_udt_name, l_ext_udt_id;
1842: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
1843:

Line 1840: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes

1836: END IF;
1837:
1838: -- Step 2.3) Get the UDT name using p_ext_dfn_id
1839: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes(p_ext_dfn_id);
1840: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes
1841: INTO g_extract_type, g_extract_udt_name, l_ext_udt_id;
1842: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
1843:
1844: -- Step 2.4) Update the UDT in the current Master BG

Line 1842: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

1838: -- Step 2.3) Get the UDT name using p_ext_dfn_id
1839: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes(p_ext_dfn_id);
1840: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes
1841: INTO g_extract_type, g_extract_udt_name, l_ext_udt_id;
1842: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
1843:
1844: -- Step 2.4) Update the UDT in the current Master BG
1845: set_location_code
1846: (p_udt_id => l_ext_udt_id

Line 1869: OPEN pqp_gb_tp_pension_extracts.csr_lea_details

1865:
1866: -- Step 4.1) Get the LEA details of the chosen LEA in the current BG
1867: g_lea_business_groups.DELETE;
1868:
1869: OPEN pqp_gb_tp_pension_extracts.csr_lea_details
1870: (p_organization_id => p_business_group_id
1871: -- Bugfix 3671727:ENH1 Now fetching for chosen LEA
1872: ,p_lea_number => g_lea_number
1873: );

Line 1874: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_details;

1870: (p_organization_id => p_business_group_id
1871: -- Bugfix 3671727:ENH1 Now fetching for chosen LEA
1872: ,p_lea_number => g_lea_number
1873: );
1874: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_details;
1875:
1876: IF pqp_gb_tp_pension_extracts.csr_lea_details%NOTFOUND THEN
1877:
1878: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;

Line 1876: IF pqp_gb_tp_pension_extracts.csr_lea_details%NOTFOUND THEN

1872: ,p_lea_number => g_lea_number
1873: );
1874: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_details;
1875:
1876: IF pqp_gb_tp_pension_extracts.csr_lea_details%NOTFOUND THEN
1877:
1878: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1879:
1880: -- Error out as the current BG does not hv this LEA

Line 1878: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;

1874: FETCH pqp_gb_tp_pension_extracts.csr_lea_details INTO l_lea_details;
1875:
1876: IF pqp_gb_tp_pension_extracts.csr_lea_details%NOTFOUND THEN
1877:
1878: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1879:
1880: -- Error out as the current BG does not hv this LEA
1881: -- Bugfix 3671727:ENH1:ENH2 :Moved code from here into new proc
1882: -- as we need to call it from more than one places

Line 1897: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;

1893: RETURN;
1894:
1895: END IF;
1896:
1897: CLOSE pqp_gb_tp_pension_extracts.csr_lea_details;
1898:
1899: -- Step 4.2) Store the current master BG in the list of BGs to process
1900: g_lea_business_groups(p_business_group_id).business_group_id := p_business_group_id;
1901: -- Bugfix 3671727:ENH1 Commented out as these cols are not available in the collection