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.PV_TERR_ASSIGN_PUB dependencies on JTF_TERR_ASSIGN_PUB

Line 1234: -- x_winners_rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type

1230: -- OUT :
1231: -- x_return_Status OUT NOCOPY VARCHAR2,
1232: -- x_msg_Count OUT NOCOPY NUMBER,
1233: -- x_msg_Data OUT NOCOPY VARCHAR2,
1234: -- x_winners_rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type
1235: --
1236: -- Version :
1237: -- Initial version 1.0
1238: --

Line 1249: x_winners_rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type

1245: p_prtnr_qualifier_rec IN partner_qualifiers_rec_type,
1246: x_return_Status OUT NOCOPY VARCHAR2,
1247: x_msg_Count OUT NOCOPY NUMBER,
1248: x_msg_Data OUT NOCOPY VARCHAR2,
1249: x_winners_rec OUT NOCOPY JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type
1250: ) IS
1251:
1252: CURSOR l_get_Currency(cv_party_id NUMBER) IS
1253: SELECT pref_functional_currency

Line 1259: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

1255: WHERE effective_end_date is NULL
1256: AND party_id = cv_party_id;
1257:
1258: l_counter NUMBER;
1259: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1260: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1261: l_return_status VARCHAR2(1);
1262: l_msg_count NUMBER;
1263: l_msg_data VARCHAR(2000);

Line 1260: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;

1256: AND party_id = cv_party_id;
1257:
1258: l_counter NUMBER;
1259: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1260: l_gen_bulk_rec JTF_TERR_ASSIGN_PUB.bulk_trans_rec_type;
1261: l_return_status VARCHAR2(1);
1262: l_msg_count NUMBER;
1263: l_msg_data VARCHAR(2000);
1264: l_curr_code VARCHAR2(30):= null;

Line 1396: JTF_TERR_ASSIGN_PUB.get_winners

1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));
1394: END IF;
1395:
1396: JTF_TERR_ASSIGN_PUB.get_winners
1397: ( p_api_version_number => 1.0,
1398: p_use_type => 'RESOURCE',
1399: p_source_id => -1700,
1400: p_trans_id => -1701,

Line 1496: -- p_winners_rec IN JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type

1492: -- p_partner_id IN NUMBER
1493: -- p_partner_type IN VARCHAR2
1494: -- p_vad_partner_id IN NUMBER
1495: -- p_mode IN VARCHAR2
1496: -- p_winners_rec IN JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type
1497: -- OUT :
1498: -- x_return_status OUT VARCHAR2(1)
1499: -- x_msg_count OUT NUMBER
1500: -- x_msg_data OUT VARCHAR2(2000)

Line 1514: p_winners_rec IN JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,

1510: PROCEDURE Process_TAP_Resources(
1511: p_partner_id IN NUMBER,
1512: p_partner_type IN VARCHAR2,
1513: p_vad_partner_id IN NUMBER,
1514: p_winners_rec IN JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type,
1515: x_return_status OUT NOCOPY VARCHAR2,
1516: x_msg_count OUT NOCOPY NUMBER,
1517: x_msg_data OUT NOCOPY VARCHAR2,
1518: x_prtnr_access_id_tbl OUT NOCOPY prtnr_aces_tbl_type)

Line 1540: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type := p_winners_rec;

1536: AND r.active_flag = 'Y'
1537: AND r.member_flag = 'Y';
1538:
1539: l_api_name CONSTANT VARCHAR2(30) := 'Process_TAP_Resources';
1540: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type := p_winners_rec;
1541: l_partner_id NUMBER ;
1542: l_res_category VARCHAR2(30);
1543: l_return_status VARCHAR2(1);
1544: l_msg_count NUMBER;

Line 2286: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

2282: l_partner_id NUMBER;
2283: l_partner_types_cnt NUMBER := 0;
2284: i NUMBER := 0;
2285: l_partner_qualifier_rec partner_qualifiers_rec_type ;
2286: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
2287: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
2288: l_resource_cnt NUMBER := 0;
2289: l_cm_added VARCHAR2(1) := 'N' ;
2290: l_partner_level VARCHAR2(30);

Line 2287: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

2283: l_partner_types_cnt NUMBER := 0;
2284: i NUMBER := 0;
2285: l_partner_qualifier_rec partner_qualifiers_rec_type ;
2286: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
2287: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
2288: l_resource_cnt NUMBER := 0;
2289: l_cm_added VARCHAR2(1) := 'N' ;
2290: l_partner_level VARCHAR2(30);
2291: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;

Line 3543: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

3539: l_partner_exist VARCHAR2(1) := 'N';
3540: l_territory_exist VARCHAR2(1) := 'N';
3541: l_partner_access_id NUMBER := 0;
3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
3543: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3544: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3545: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
3546: l_resource_cnt NUMBER := 0;
3547: l_cm_added VARCHAR2(1) := 'N' ;

Line 3544: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

3540: l_territory_exist VARCHAR2(1) := 'N';
3541: l_partner_access_id NUMBER := 0;
3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
3543: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3544: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3545: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
3546: l_resource_cnt NUMBER := 0;
3547: l_cm_added VARCHAR2(1) := 'N' ;
3548: l_res_created_flg VARCHAR2(1) := 'N' ;

Line 4109: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

4105: l_partner_exist VARCHAR2(1) := 'N';
4106: l_territory_exist VARCHAR2(1) := 'N';
4107: l_partner_access_id NUMBER := 0;
4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
4109: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4110: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4111: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
4112: l_resource_cnt NUMBER := 0;
4113: l_cm_added VARCHAR2(1) := 'N' ;

Line 4110: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;

4106: l_territory_exist VARCHAR2(1) := 'N';
4107: l_partner_access_id NUMBER := 0;
4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
4109: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4110: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4111: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
4112: l_resource_cnt NUMBER := 0;
4113: l_cm_added VARCHAR2(1) := 'N' ;
4114: l_res_created_flg VARCHAR2(1) := 'N' ;