1374: IF l_cust_is_partner_csr%FOUND THEN
1375: CLOSE l_cust_is_partner_csr;
1376:
1377: -- Check any of the Organization qualifier enabled.
1378: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_partner_name)= 'Y') OR
1379: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_cust_catgy_code)= 'Y') OR
1380: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_number_of_employee)= 'Y') OR
1381: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_Annual_Revenue)= 'Y') ) THEN
1382:
1375: CLOSE l_cust_is_partner_csr;
1376:
1377: -- Check any of the Organization qualifier enabled.
1378: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_partner_name)= 'Y') OR
1379: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_cust_catgy_code)= 'Y') OR
1380: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_number_of_employee)= 'Y') OR
1381: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_Annual_Revenue)= 'Y') ) THEN
1382:
1383: OPEN l_chng_partner_exist_csr(l_partner_id);
1376:
1377: -- Check any of the Organization qualifier enabled.
1378: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_partner_name)= 'Y') OR
1379: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_cust_catgy_code)= 'Y') OR
1380: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_number_of_employee)= 'Y') OR
1381: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_Annual_Revenue)= 'Y') ) THEN
1382:
1383: OPEN l_chng_partner_exist_csr(l_partner_id);
1384: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
1377: -- Check any of the Organization qualifier enabled.
1378: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_partner_name)= 'Y') OR
1379: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_cust_catgy_code)= 'Y') OR
1380: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_number_of_employee)= 'Y') OR
1381: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_Annual_Revenue)= 'Y') ) THEN
1382:
1383: OPEN l_chng_partner_exist_csr(l_partner_id);
1384: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
1385: l_batch_chg_prtnrs_rec.partner_id := l_partner_id;
1778: IF l_cust_is_partner_csr%FOUND THEN
1779: CLOSE l_cust_is_partner_csr;
1780:
1781: -- Check any of the Location qualifier enabled.
1782: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1779: CLOSE l_cust_is_partner_csr;
1780:
1781: -- Check any of the Location qualifier enabled.
1782: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1787: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1780:
1781: -- Check any of the Location qualifier enabled.
1782: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1787: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1788:
1781: -- Check any of the Location qualifier enabled.
1782: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1787: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1788:
1789: OPEN l_chng_partner_exist_csr(l_partner_id);
1782: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1787: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1788:
1789: OPEN l_chng_partner_exist_csr(l_partner_id);
1790: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
1783: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1784: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1785: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1786: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1787: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1788:
1789: OPEN l_chng_partner_exist_csr(l_partner_id);
1790: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
1791: l_batch_chg_prtnrs_rec.partner_id := l_partner_id;
2013: IF l_cust_is_partner_csr%FOUND THEN
2014: CLOSE l_cust_is_partner_csr;
2015:
2016: -- Check any of the Contact Point qualifier enabled.
2017: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_area_code )= 'Y') ) THEN
2018:
2019: OPEN l_chng_partner_exist_csr(l_partner_id);
2020: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
2021: l_batch_chg_prtnrs_rec.partner_id := l_partner_id;