DBA Data[Home] [Help]

APPS.PV_TAP_BES_PKG dependencies on PV_TERR_ASSIGN_PUB

Line 1378: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_partner_name)= 'Y') OR

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:

Line 1379: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_cust_catgy_code)= 'Y') OR

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);

Line 1380: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_number_of_employee)= 'Y') OR

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;

Line 1381: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_Annual_Revenue)= 'Y') ) THEN

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;

Line 1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR

1949: IF l_cust_is_partner_csr%FOUND THEN
1950: CLOSE l_cust_is_partner_csr;
1951:
1952: -- Check any of the Location qualifier enabled.
1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR

Line 1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR

1950: CLOSE l_cust_is_partner_csr;
1951:
1952: -- Check any of the Location qualifier enabled.
1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN

Line 1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR

1951:
1952: -- Check any of the Location qualifier enabled.
1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1959:

Line 1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR

1952: -- Check any of the Location qualifier enabled.
1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1959:
1960: OPEN l_chng_partner_exist_csr(l_partner_id);

Line 1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR

1953: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_city)= 'Y') OR
1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1959:
1960: OPEN l_chng_partner_exist_csr(l_partner_id);
1961: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;

Line 1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN

1954: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_county)= 'Y') OR
1955: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_country)= 'Y') OR
1956: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_state)= 'Y') OR
1957: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_postal_code)= 'Y') OR
1958: (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_province)= 'Y') ) THEN
1959:
1960: OPEN l_chng_partner_exist_csr(l_partner_id);
1961: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
1962: l_batch_chg_prtnrs_rec.partner_id := l_partner_id;

Line 2188: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_area_code )= 'Y') ) THEN

2184: IF l_cust_is_partner_csr%FOUND THEN
2185: CLOSE l_cust_is_partner_csr;
2186:
2187: -- Check any of the Contact Point qualifier enabled.
2188: IF ( (PV_TERR_ASSIGN_PUB.chk_prtnr_qflr_enabled(PV_TERR_ASSIGN_PUB.g_area_code )= 'Y') ) THEN
2189:
2190: OPEN l_chng_partner_exist_csr(l_partner_id);
2191: FETCH l_chng_partner_exist_csr INTO l_processed_flag, l_object_version;
2192: l_batch_chg_prtnrs_rec.partner_id := l_partner_id;