DBA Data[Home] [Help]

APPS.PV_TERR_ASSIGN_PUB dependencies on FND_PROFILE

Line 2635: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;

2631:
2632:
2633: -- Get the value of Profile PV_DEFAULT_CM.
2634: CURSOR l_get_default_cm_csr(cv_profile_name IN VARCHAR2) IS
2635: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
2636:
2637: BEGIN
2638:
2639: -- Standard call to check for call compatibility.

Line 2798: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');

2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: END IF;
2796: -- Set the p_partner_access_rec record
2797: l_partner_access_rec.partner_id := l_partner_id;
2798: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');
2799: l_partner_access_rec.keep_flag := 'Y';
2800: l_partner_access_rec.created_by_tap_flag := 'Y';
2801: l_partner_access_rec.access_type := 'F';
2802:

Line 3003: SELECT fnd_profile.value(cv_profile_name) from dual;

2999: WHERE partner_id = cv_partner_id;
3000:
3001: -- Get the value of Profile PV_TAP_ASSIGN_ONLINE.
3002: CURSOR l_get_tap_prfl_value_csr(cv_profile_name IN VARCHAR2) IS
3003: SELECT fnd_profile.value(cv_profile_name) from dual;
3004:
3005: BEGIN
3006:
3007: -- Standard Start of API savepoint

Line 3899: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');

3895:
3896: IF ( l_cm_added <> 'Y' ) THEN
3897: -- Set the p_partner_access_rec record
3898: l_partner_access_rec.partner_id := l_partner_id;
3899: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');
3900: l_partner_access_rec.keep_flag := 'Y';
3901: l_partner_access_rec.created_by_tap_flag := 'Y';
3902: l_partner_access_rec.access_type := 'F';
3903:

Line 4451: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');

4447:
4448: IF ( l_cm_added <> 'Y' ) THEN
4449: -- Set the p_partner_access_rec record
4450: l_partner_access_rec.partner_id := l_partner_id;
4451: l_partner_access_rec.resource_id := fnd_profile.value('PV_DEFAULT_CM');
4452: l_partner_access_rec.keep_flag := 'Y';
4453: l_partner_access_rec.created_by_tap_flag := 'Y';
4454: l_partner_access_rec.access_type := 'F';
4455:

Line 5400: l_request_id NUMBER := fnd_profile.value('CONC_REQUEST_ID');

5396: l_msg_count NUMBER;
5397: l_msg_data VARCHAR2(2000);
5398: l_err_mesg VARCHAR2(255);
5399: l_partner_access_id_tbl prtnr_aces_tbl_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;

Line 5401: l_program_application_id NUMBER := fnd_profile.value('CONC_PROGRAM_APPICATION_ID');

5397: l_msg_data VARCHAR2(2000);
5398: l_err_mesg VARCHAR2(255);
5399: l_partner_access_id_tbl prtnr_aces_tbl_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;

Line 5402: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');

5398: l_err_mesg VARCHAR2(255);
5399: l_partner_access_id_tbl prtnr_aces_tbl_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;

Line 5967: l_batch_size := nvl(to_number(FND_PROFILE.value('PV_BATCH_SIZE_FOR_TAP_PROCESSING')),0);

5963: l_total_records := 0;
5964: END IF;
5965:
5966: --Get the batch size for each thread from profile
5967: l_batch_size := nvl(to_number(FND_PROFILE.value('PV_BATCH_SIZE_FOR_TAP_PROCESSING')),0);
5968:
5969: --handle condition if batch size for parallel import is set to -ve or zero.
5970: IF l_batch_size <= 0 THEN
5971: l_batch_size := l_total_records;

Line 6144: l_request_id NUMBER := fnd_profile.value('CONC_REQUEST_ID');

6140: l_msg_count NUMBER;
6141: l_msg_data VARCHAR2(2000);
6142: l_err_mesg VARCHAR2(255);
6143: l_partner_access_id_tbl prtnr_aces_tbl_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;

Line 6145: l_program_application_id NUMBER := fnd_profile.value('CONC_PROGRAM_APPICATION_ID');

6141: l_msg_data VARCHAR2(2000);
6142: l_err_mesg VARCHAR2(255);
6143: l_partner_access_id_tbl prtnr_aces_tbl_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;

Line 6146: l_program_id NUMBER := fnd_profile.value('CONC_PROGRAM_ID');

6142: l_err_mesg VARCHAR2(255);
6143: l_partner_access_id_tbl prtnr_aces_tbl_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;