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 PV_BATCH_CHG_PRTNR_PVT

Line 2262: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;

2258: l_api_version_number CONSTANT NUMBER := 1.0;
2259: l_return_status VARCHAR2(1);
2260: l_msg_count NUMBER;
2261: l_msg_data VARCHAR(2000);
2262: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;
2263:
2264: -- Local variable declaration for all the Partner Qualifiers.
2265: l_party_site_id NUMBER;
2266: l_party_id NUMBER;

Line 2986: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

2982: l_msg_data VARCHAR(2000);
2983: l_partner_id NUMBER;
2984: l_prtnr_access_id_tbl JTF_NUMBER_TABLE;
2985: l_tap_assign_online VARCHAR2(1);
2986: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
2987: l_partner_access_id_tbl prtnr_aces_tbl_type ;
2988: l_partner_exist VARCHAR2(1):= 'N';
2989: l_login_user NUMBER := FND_GLOBAL.user_id;
2990: l_mode VARCHAR2(10);

Line 3127: -- Call the Create_Batch_Chg_Partners API from PV_BATCH_CHG_PRTNR_PVT

3123:
3124: IF (l_chk_partner_exist_csr%NOTFOUND ) THEN
3125:
3126: CLOSE l_chk_partner_exist_csr;
3127: -- Call the Create_Batch_Chg_Partners API from PV_BATCH_CHG_PRTNR_PVT
3128: -- to create a record in PV_TAP_BATCH_CHG_PARTNERS table.
3129:
3130: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
3131: p_api_version_number => 1.0

Line 3130: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

3126: CLOSE l_chk_partner_exist_csr;
3127: -- Call the Create_Batch_Chg_Partners API from PV_BATCH_CHG_PRTNR_PVT
3128: -- to create a record in PV_TAP_BATCH_CHG_PARTNERS table.
3129:
3130: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
3131: p_api_version_number => 1.0
3132: ,p_init_msg_list => FND_API.G_FALSE
3133: ,p_commit => FND_API.G_FALSE
3134: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3147: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');

3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3147: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
3148: FND_MSG_PUB.Add;
3149: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3150: END IF;
3151: END IF;

Line 3160: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

3156:
3157: IF (l_processed_flag <> 'P') THEN
3158:
3159: l_changed_partner_rec.object_version_number := l_object_version_number;
3160: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
3161: p_api_version_number => 1.0
3162: ,p_init_msg_list => FND_API.G_FALSE
3163: ,p_commit => FND_API.G_FALSE
3164: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3176: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

3172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3173: RAISE FND_API.G_EXC_ERROR;
3174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3175: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3176: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
3177: FND_MSG_PUB.Add;
3178: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;
3180: END IF;

Line 3355: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;

3351: l_msg_data VARCHAR(2000);
3352: l_partner_id NUMBER := p_partner_id;
3353: l_prtnr_access_id_tbl prtnr_aces_tbl_type;
3354: l_tap_assign_online VARCHAR2(1);
3355: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_Rec_Type;
3356: l_partner_exist VARCHAR2(1):= 'N';
3357: l_login_user NUMBER := FND_GLOBAL.user_id;
3358: l_mode VARCHAR2(10);
3359: l_processed_flag VARCHAR2(1) := 'P';

Line 3515: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;

3511: l_api_version_number CONSTANT NUMBER := 1.0;
3512: l_return_status VARCHAR2(1);
3513: l_msg_count NUMBER;
3514: l_msg_data VARCHAR(2000);
3515: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;
3516:
3517: -- Local variable declaration for all the Partner Qualifiers.
3518: l_party_site_id NUMBER;
3519: l_party_id NUMBER;

Line 4081: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;

4077: l_api_version_number CONSTANT NUMBER := 1.0;
4078: l_return_status VARCHAR2(1);
4079: l_msg_count NUMBER;
4080: l_msg_data VARCHAR(2000);
4081: l_changed_partner_rec PV_BATCH_CHG_PRTNR_PVT.batch_chg_prtnrs_rec_type ;
4082:
4083: -- Local variable declaration for all the Partner Qualifiers.
4084: l_party_site_id NUMBER;
4085: l_party_id NUMBER;

Line 5404: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;

5400: l_request_id NUMBER := fnd_profile.value('CONC_REQUEST_ID');
5401: l_program_application_id NUMBER := fnd_profile.value('CONC_PROGRAM_APPICATION_ID');
5402: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');
5403: l_program_update_date DATE := sysdate;
5404: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;
5405: rec_index NUMBER := 0;
5406: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;
5407: l_batch_partner_id NUMBER;
5408: l_batch_oversion_number NUMBER;

Line 5515: PV_BATCH_CHG_PRTNR_PVT.Delete_Batch_Chg_Prtnrs(

5511: FOR l_batch_partner_list IN l_batch_partners_csr(l_first_partner_id, l_last_partner_id)
5512: LOOP
5513: l_batch_partner_id := l_batch_partner_list.partner_id;
5514: l_batch_oversion_number := l_batch_partner_list.object_version_number;
5515: PV_BATCH_CHG_PRTNR_PVT.Delete_Batch_Chg_Prtnrs(
5516: p_api_version_number => 1.0 ,
5517: p_init_msg_list => FND_API.G_FALSE,
5518: p_commit => FND_API.G_FALSE,
5519: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5599: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(

5595: ELSE
5596: l_change_partner.processed_flag := 'S';
5597: END IF;
5598:
5599: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
5600: p_api_version_number => 1.0 ,
5601: p_init_msg_list => FND_API.G_TRUE,
5602: p_commit => FND_API.G_FALSE,
5603: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 5641: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

5637: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
5638: l_change_partner.processed_flag := 'S';
5639: END IF;
5640:
5641: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
5642: p_api_version_number => 1.0 ,
5643: p_init_msg_list => FND_API.G_TRUE,
5644: p_commit => FND_API.G_FALSE,
5645: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6148: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;

6144: l_request_id NUMBER := fnd_profile.value('CONC_REQUEST_ID');
6145: l_program_application_id NUMBER := fnd_profile.value('CONC_PROGRAM_APPICATION_ID');
6146: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');
6147: l_program_update_date DATE := sysdate;
6148: l_change_partner PV_BATCH_CHG_PRTNR_PVT.Batch_Chg_Prtnrs_rec_type;
6149: rec_index NUMBER := 0;
6150: l_newline VARCHAR2(1) := FND_GLOBAL.Newline;
6151: l_batch_partner_id NUMBER;
6152: l_batch_oversion_number NUMBER;

Line 6317: PV_BATCH_CHG_PRTNR_PVT.create_Batch_Chg_Partners(

6313: ELSE
6314: l_change_partner.processed_flag := 'S';
6315: END IF;
6316:
6317: PV_BATCH_CHG_PRTNR_PVT.create_Batch_Chg_Partners(
6318: p_api_version_number => 1.0 ,
6319: p_init_msg_list => FND_API.G_FALSE,
6320: p_commit => FND_API.G_FALSE,
6321: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6333: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');

6329: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6330: RAISE FND_API.G_EXC_ERROR;
6331: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6332: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6333: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
6334: FND_MSG_PUB.Add;
6335: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: END IF;
6337: END IF;

Line 6363: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(

6359: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
6360: l_change_partner.processed_flag := 'S';
6361: END IF;
6362:
6363: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
6364: p_api_version_number => 1.0 ,
6365: p_init_msg_list => FND_API.G_FALSE,
6366: p_commit => FND_API.G_FALSE,
6367: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 6378: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

6374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6375: RAISE FND_API.G_EXC_ERROR;
6376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6377: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6378: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
6379: FND_MSG_PUB.Add;
6380: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6381: END IF;
6382: END IF;