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.AST_UWQ_WRAPPER_PKG dependencies on FND_PROFILE

Line 19: l_client_tz_id := to_number(fnd_profile.value('CLIENT_TIMEZONE_ID'));

15: x_server_time date;
16:
17: BEGIN
18:
19: l_client_tz_id := to_number(fnd_profile.value('CLIENT_TIMEZONE_ID'));
20: l_server_tz_id := to_number(fnd_profile.value('SERVER_TIMEZONE_ID'));
21:
22: HZ_TIMEZONE_PUB.Get_Time(1.0, 'F', l_server_tz_id, l_client_tz_id, p_client_time, x_server_time, l_status, l_msg_count, l_msg_data);
23:

Line 20: l_server_tz_id := to_number(fnd_profile.value('SERVER_TIMEZONE_ID'));

16:
17: BEGIN
18:
19: l_client_tz_id := to_number(fnd_profile.value('CLIENT_TIMEZONE_ID'));
20: l_server_tz_id := to_number(fnd_profile.value('SERVER_TIMEZONE_ID'));
21:
22: HZ_TIMEZONE_PUB.Get_Time(1.0, 'F', l_server_tz_id, l_client_tz_id, p_client_time, x_server_time, l_status, l_msg_count, l_msg_data);
23:
24: return x_server_time;

Line 134: l_timezone_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');

130: l_task_contact_id NUMBER;
131: l_task_or_contact_party_id NUMBER;
132: l_task_phone_id NUMBER;
133: l_api_version NUMBER := 1.0;
134: l_timezone_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
135: l_task_status_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_STATUS');
136: l_assigned_by_id NUMBER := FND_PROFILE.VALUE('USER_ID');
137: l_task_priority_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_PRIORITY');
138: l_init_msg_list VARCHAR2(5) := 'T';

Line 135: l_task_status_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_STATUS');

131: l_task_or_contact_party_id NUMBER;
132: l_task_phone_id NUMBER;
133: l_api_version NUMBER := 1.0;
134: l_timezone_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
135: l_task_status_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_STATUS');
136: l_assigned_by_id NUMBER := FND_PROFILE.VALUE('USER_ID');
137: l_task_priority_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_PRIORITY');
138: l_init_msg_list VARCHAR2(5) := 'T';
139: l_commit VARCHAR2(5) := 'T';

Line 136: l_assigned_by_id NUMBER := FND_PROFILE.VALUE('USER_ID');

132: l_task_phone_id NUMBER;
133: l_api_version NUMBER := 1.0;
134: l_timezone_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
135: l_task_status_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_STATUS');
136: l_assigned_by_id NUMBER := FND_PROFILE.VALUE('USER_ID');
137: l_task_priority_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_PRIORITY');
138: l_init_msg_list VARCHAR2(5) := 'T';
139: l_commit VARCHAR2(5) := 'T';
140: l_task_status_name VARCHAR2(30);

Line 137: l_task_priority_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_PRIORITY');

133: l_api_version NUMBER := 1.0;
134: l_timezone_id NUMBER := fnd_profile.value('CLIENT_TIMEZONE_ID');
135: l_task_status_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_STATUS');
136: l_assigned_by_id NUMBER := FND_PROFILE.VALUE('USER_ID');
137: l_task_priority_id NUMBER := fnd_profile.value('JTF_TASK_DEFAULT_TASK_PRIORITY');
138: l_init_msg_list VARCHAR2(5) := 'T';
139: l_commit VARCHAR2(5) := 'T';
140: l_task_status_name VARCHAR2(30);
141: l_date_type VARCHAR2(30);

Line 256: IF fnd_profile.value('JTF_TASK_DEFAULT_OWNER_TYPE') <> 'RS_EMPLOYEE' THEN

252: FETCH C_GetDefaultPriority INTO l_task_priority_name;
253: CLOSE C_GetDefaultPriority;
254: END IF;
255:
256: IF fnd_profile.value('JTF_TASK_DEFAULT_OWNER_TYPE') <> 'RS_EMPLOYEE' THEN
257: FND_MESSAGE.Set_Name('AST', 'AST_UWQ_IMPROPER_OWNER_TYPE');
258: FND_MSG_PUB.ADD;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- x_msg_count := l_msg_count;

Line 336: P_OWNER_ID => nvl(fnd_profile.value('JTF_TASK_DEFAULT_OWNER'),p_owner_id), --Bug # 3626890

332: P_TASK_PRIORITY_NAME => l_task_priority_name,
333: P_TASK_PRIORITY_ID => l_task_priority_id,
334: P_OWNER_TYPE_NAME => l_owner_type_name,
335: P_OWNER_TYPE_CODE => l_owner_type_code,
336: P_OWNER_ID => nvl(fnd_profile.value('JTF_TASK_DEFAULT_OWNER'),p_owner_id), --Bug # 3626890
337: P_OWNER_TERRITORY_ID => null,
338: P_ASSIGNED_BY_NAME => l_assigned_by_name,
339: P_ASSIGNED_BY_ID => l_assigned_by_id,
340: P_CUSTOMER_NUMBER => null,

Line 521: l_note_status VARCHAR2(3) := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');

517: l_counter NUMBER;
518: l_cust_account_id NUMBER;
519: l_subject_id NUMBER;
520: l_object_id NUMBER;
521: l_note_status VARCHAR2(3) := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');
522: l_init_msg_list VARCHAR2(5) := 'T';
523: l_commit VARCHAR2(5) := 'T';
524: l_note_type VARCHAR2(30) := fnd_profile.value('AST_NOTES_DEFAULT_TYPE');
525:

Line 524: l_note_type VARCHAR2(30) := fnd_profile.value('AST_NOTES_DEFAULT_TYPE');

520: l_object_id NUMBER;
521: l_note_status VARCHAR2(3) := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');
522: l_init_msg_list VARCHAR2(5) := 'T';
523: l_commit VARCHAR2(5) := 'T';
524: l_note_type VARCHAR2(30) := fnd_profile.value('AST_NOTES_DEFAULT_TYPE');
525:
526: l_count NUMBER;
527: l_index NUMBER;
528: my_message VARCHAR2(1000);

Line 565: IF nvl(fnd_profile.value('AS_NOTES_OPP_CONTACT'),'N') = 'Y' THEN

561: BEGIN
562: g_jtf_note_contexts_tab.delete;
563: l_counter := 0;
564: IF p_source_object_code = 'OPPORTUNITY' THEN
565: IF nvl(fnd_profile.value('AS_NOTES_OPP_CONTACT'),'N') = 'Y' THEN
566: OPEN C_opp_contact(p_source_object_id);
567: FETCH C_opp_contact into l_contact_id;
568: IF C_opp_contact%FOUND THEN
569: l_counter := l_counter + 1;

Line 577: IF nvl(fnd_profile.value('AS_NOTES_OPP_CUSTOMER'),'N') = 'Y' THEN

573: END IF;
574: CLOSE C_opp_contact;
575: END IF;
576:
577: IF nvl(fnd_profile.value('AS_NOTES_OPP_CUSTOMER'),'N') = 'Y' THEN
578: l_counter := l_counter + 1;
579: add_context_to_table(l_counter, p_party_id, 'PARTY',
580: p_last_update_date, p_last_updated_by, p_last_update_login,
581: p_creation_date, p_created_by);

Line 584: IF nvl(fnd_profile.value('AS_NOTES_LEAD_CONTACT'),'N') = 'Y' THEN

580: p_last_update_date, p_last_updated_by, p_last_update_login,
581: p_creation_date, p_created_by);
582: END IF;
583: ELSIF p_source_object_code = 'LEAD' THEN
584: IF nvl(fnd_profile.value('AS_NOTES_LEAD_CONTACT'),'N') = 'Y' THEN
585: OPEN C_lead_contact(p_source_object_id);
586: FETCH C_lead_contact into l_contact_id;
587: IF C_lead_contact%FOUND THEN
588: l_counter := l_counter + 1;

Line 595: IF nvl(fnd_profile.value('AS_NOTES_LEAD_CUSTOMER'),'N') = 'Y' THEN

591: p_creation_date, p_created_by);
592: END IF;
593: CLOSE C_lead_contact;
594: END IF;
595: IF nvl(fnd_profile.value('AS_NOTES_LEAD_CUSTOMER'),'N') = 'Y' THEN
596: l_counter := l_counter + 1;
597: add_context_to_table(l_counter, p_party_id, 'PARTY',
598: p_last_update_date, p_last_updated_by, p_last_update_login,
599: p_creation_date, p_created_by);

Line 605: IF nvl(fnd_profile.value('AS_NOTES_REL_OBJECT'),'N') = 'Y' THEN

601: ELSIF p_source_object_code = 'PARTY' THEN
602: OPEN c_subject_and_object(p_source_object_id);
603: FETCH c_subject_and_object INTO l_subject_id, l_object_id;
604: IF c_subject_and_object%FOUND THEN
605: IF nvl(fnd_profile.value('AS_NOTES_REL_OBJECT'),'N') = 'Y' THEN
606: l_counter := l_counter + 1;
607: add_context_to_table(l_counter, l_object_id, 'PARTY',
608: p_last_update_date, p_last_updated_by, p_last_update_login,
609: p_creation_date, p_created_by);

Line 611: IF nvl(fnd_profile.value('AS_NOTES_REL_SUBJECT'),'N') = 'Y' THEN

607: add_context_to_table(l_counter, l_object_id, 'PARTY',
608: p_last_update_date, p_last_updated_by, p_last_update_login,
609: p_creation_date, p_created_by);
610: END IF;
611: IF nvl(fnd_profile.value('AS_NOTES_REL_SUBJECT'),'N') = 'Y' THEN
612: l_counter := l_counter + 1;
613: add_context_to_table(l_counter, l_subject_id, 'PARTY',
614: p_last_update_date, p_last_updated_by, p_last_update_login,
615: p_creation_date, p_created_by);

Line 724: l_sales_methodology_id NUMBER := fnd_profile.value('AS_SALES_METHODOLOGY'); -- Updated by Sumita for bug # 4100911

720: l_last_update_date DATE;
721: --Code commented for R12 Enhancement --Start
722: --l_close_competitor VARCHAR2(4000);
723: --Code commented for R12 Enhancement --End
724: l_sales_methodology_id NUMBER := fnd_profile.value('AS_SALES_METHODOLOGY'); -- Updated by Sumita for bug # 4100911
725:
726: CURSOR c_close_comp(p_close_party_id in number) IS
727: SELECT party_name
728: FROM hz_parties

Line 771: if nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'),'N') = 'Y' and p_lead_id is NULL then

767: -- header_rec.end_user_customer_name := null;
768: header_rec.parent_project := NVL(p_parent_project, l_char);
769:
770: -- Updated by Sumita for bug # 4100911
771: if nvl(fnd_profile.value('AS_ACTIVATE_SALES_INTEROP'),'N') = 'Y' and p_lead_id is NULL then
772: header_rec.sales_methodology_id := NVL(l_sales_methodology_id,l_char);
773: end if;
774:
775: -- header_rec.sales_methodology_id := null;

Line 856: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');

852: AS
853: l_api_version NUMBER := 2.0;
854: l_valid_level_full NUMBER := 100;
855: l_address_id NUMBER;
856: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');
857: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
858: l_init_msg_list VARCHAR2(5) := 'T';
859: l_commit VARCHAR2(5) := 'T';
860: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;

Line 862: l_vehicle_response_code VARCHAR2(200) := nvl(p_vehicle_response_code, FND_PROFILE.value('AS_OPP_RESPONSE_CODE'));

858: l_init_msg_list VARCHAR2(5) := 'T';
859: l_commit VARCHAR2(5) := 'T';
860: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;
861: v_profile_tbl AS_UTILITY_PUB.PROFILE_TBL_TYPE := AS_API_RECORDS_PKG.get_p_profile_tbl;
862: l_vehicle_response_code VARCHAR2(200) := nvl(p_vehicle_response_code, FND_PROFILE.value('AS_OPP_RESPONSE_CODE'));
863:
864: -- Added by Sumita on 10.14.2004 for bug # 3812865
865: l_source_promotion_id NUMBER;
866: l_action_key VARCHAR2(30) := p_action_key;

Line 1055: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

1051: l_api_version NUMBER := 2.0;
1052: l_assign_to_person_id NUMBER;
1053: l_assign_to_salesforce_id NUMBER;
1054: l_assign_sales_group_id NUMBER;
1055: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1056: l_org_contact_id NUMBER;
1057: l_phone_id NUMBER := null;
1058: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1059: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_LEAD');

Line 1059: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_LEAD');

1055: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1056: l_org_contact_id NUMBER;
1057: l_phone_id NUMBER := null;
1058: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1059: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_LEAD');
1060: l_init_msg_list VARCHAR2(5) := 'T';
1061: l_commit VARCHAR2(5) := 'F';
1062: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1063: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');

Line 1062: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');

1058: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1059: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_LEAD');
1060: l_init_msg_list VARCHAR2(5) := 'T';
1061: l_commit VARCHAR2(5) := 'F';
1062: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1063: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1064: l_contact_role_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_CONTACT_ROLE');
1065: l_full_name VARCHAR2(240);
1066:

Line 1063: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');

1059: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_LEAD');
1060: l_init_msg_list VARCHAR2(5) := 'T';
1061: l_commit VARCHAR2(5) := 'F';
1062: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1063: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1064: l_contact_role_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_CONTACT_ROLE');
1065: l_full_name VARCHAR2(240);
1066:
1067: -- Added by Sumita on 10.14.2004 for bug # 3812865

Line 1064: l_contact_role_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_CONTACT_ROLE');

1060: l_init_msg_list VARCHAR2(5) := 'T';
1061: l_commit VARCHAR2(5) := 'F';
1062: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1063: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1064: l_contact_role_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_CONTACT_ROLE');
1065: l_full_name VARCHAR2(240);
1066:
1067: -- Added by Sumita on 10.14.2004 for bug # 3812865
1068: l_source_promotion_id NUMBER;

Line 1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');

1248: if (l_sales_lead_contact_rec.contact_party_id IS NOT NULL) THEN
1249: l_sales_lead_contact_tbl(1) := l_sales_lead_contact_rec;
1250: END IF;
1251:
1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

Line 1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');

1249: l_sales_lead_contact_tbl(1) := l_sales_lead_contact_rec;
1250: END IF;
1251:
1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1257:

Line 1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');

1250: END IF;
1251:
1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1257:
1258: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';

Line 1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');

1251:
1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1257:
1258: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1259: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;

Line 1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

1252: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1253: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1254: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1255: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1256: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1257:
1258: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1259: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;
1260: l_sales_lead_profile_tbl(2).profile_name := 'AS_LEAD_ACCESS';

Line 1400: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

1396: x_msg_data OUT NOCOPY VARCHAR2
1397: )
1398: IS
1399: l_api_version NUMBER := 2.0;
1400: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1401: l_assign_sales_group_id NUMBER;
1402: l_assign_to_person_id NUMBER;
1403: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1404: l_init_msg_list VARCHAR2(5) := 'T';

Line 1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');

1402: l_assign_to_person_id NUMBER;
1403: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1404: l_init_msg_list VARCHAR2(5) := 'T';
1405: l_commit VARCHAR2(5) := 'T';
1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;

Line 1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');

1403: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1404: l_init_msg_list VARCHAR2(5) := 'T';
1405: l_commit VARCHAR2(5) := 'T';
1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;

Line 1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');

1460: l_sales_lead_rec.accept_flag := p_accept_flag;
1461: l_sales_lead_rec.qualified_flag := p_qualified_flag;
1462: -- l_sales_lead_rec.vehicle_response_code := l_vehicle_response_code;
1463:
1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

Line 1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');

1461: l_sales_lead_rec.qualified_flag := p_qualified_flag;
1462: -- l_sales_lead_rec.vehicle_response_code := l_vehicle_response_code;
1463:
1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1469:

Line 1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');

1462: -- l_sales_lead_rec.vehicle_response_code := l_vehicle_response_code;
1463:
1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1469:
1470: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';

Line 1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');

1463:
1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1469:
1470: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1471: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;

Line 1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

1464: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1465: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1466: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1467: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1468: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1469:
1470: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1471: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;
1472: l_sales_lead_profile_tbl(2).profile_name := 'AS_LEAD_ACCESS';

Line 1549: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

1545: l_api_version NUMBER := 2.0;
1546: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1547: l_init_msg_list VARCHAR2(5) := 'T';
1548: l_commit VARCHAR2(5) := 'T';
1549: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1550: l_opp_status VARCHAR2(30) := nvl(FND_PROFILE.value('AS_OPP_STATUS'), null);
1551: l_query_string varchar2(200);
1552: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1553: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 1550: l_opp_status VARCHAR2(30) := nvl(FND_PROFILE.value('AS_OPP_STATUS'), null);

1546: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1547: l_init_msg_list VARCHAR2(5) := 'T';
1548: l_commit VARCHAR2(5) := 'T';
1549: l_validation_level NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1550: l_opp_status VARCHAR2(30) := nvl(FND_PROFILE.value('AS_OPP_STATUS'), null);
1551: l_query_string varchar2(200);
1552: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1553: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1554:

Line 1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');

1572: else
1573: x_app_launch := 'N';
1574: end if;
1575:
1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

Line 1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');

1573: x_app_launch := 'N';
1574: end if;
1575:
1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1581:

Line 1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');

1574: end if;
1575:
1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1581:
1582: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';

Line 1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');

1575:
1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1581:
1582: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1583: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;

Line 1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

1576: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1577: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1578: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1579: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1580: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1581:
1582: l_sales_lead_profile_tbl(1).profile_name := 'AS_CUST_ACCESS';
1583: l_sales_lead_profile_tbl(1).profile_value := G_access_rec_type.cust_access_profile_value;
1584: l_sales_lead_profile_tbl(2).profile_name := 'AS_LEAD_ACCESS';

Line 1647: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

1643: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1644: l_init_msg_list VARCHAR2(5) := 'T';
1645: l_commit VARCHAR2(5) := 'T';
1646: l_message_name VARCHAR2(100);
1647: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1648: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1649:
1650: l_count NUMBER;
1651: l_index NUMBER;

Line 1661: l_access_flag := nvl(fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER'),'N');

1657: Procedure LLIST_REASSIGN_LEAD in astulacb.pls
1658: **/
1659: /**
1660: l_message_name := 'AST_NO_LEAD_OWNR_CHANGE_ACCESS';
1661: l_access_flag := nvl(fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER'),'N');
1662:
1663: if (l_access_flag <> 'Y') then
1664: if (p_sales_lead_id is not null) then
1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');

Line 1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');

1661: l_access_flag := nvl(fnd_profile.value('AS_ALLOW_CHANGE_LEAD_OWNER'),'N');
1662:
1663: if (l_access_flag <> 'Y') then
1664: if (p_sales_lead_id is not null) then
1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

Line 1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');

1662:
1663: if (l_access_flag <> 'Y') then
1664: if (p_sales_lead_id is not null) then
1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1670:

Line 1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');

1663: if (l_access_flag <> 'Y') then
1664: if (p_sales_lead_id is not null) then
1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1670:
1671: AS_ACCESS_PVT.has_LeadOwnerAccess(

Line 1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');

1664: if (p_sales_lead_id is not null) then
1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1670:
1671: AS_ACCESS_PVT.has_LeadOwnerAccess(
1672: p_api_version_Number => 2.0,

Line 1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');

1665: G_Access_Rec_Type.cust_access_profile_value := nvl(FND_PROFILE.VALUE('AS_CUST_ACCESS'),'F');
1666: G_Access_Rec_Type.lead_access_profile_value := nvl(FND_PROFILE.VALUE('AS_LEAD_ACCESS'),'F');
1667: G_Access_Rec_Type.opp_access_profile_value := nvl(FND_PROFILE.VALUE('AS_OPP_ACCESS'),'F');
1668: G_Access_Rec_Type.mgr_update_profile_value := nvl(FND_PROFILE.VALUE('AS_MGR_UPDATE'),'R');
1669: G_Access_Rec_Type.admin_update_profile_value := nvl(FND_PROFILE.VALUE('AS_ADMIN_UPDATE'),'R');
1670:
1671: AS_ACCESS_PVT.has_LeadOwnerAccess(
1672: p_api_version_Number => 2.0,
1673: p_init_msg_list => 'N',

Line 1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;
1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;
1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;
1748:
1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);
1750: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1751:
1752: CURSOR c_lead_info (p_sales_lead_id NUMBER) is
1753: SELECT customer_id, source_promotion_id

Line 1852: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');

1848: )
1849: AS
1850: l_api_version NUMBER := 2.0;
1851: l_valid_level_full NUMBER := 100;
1852: l_address_profile VARCHAR2(3) := FND_PROFILE.value('AST_WP_USE_ADDRESS_FOR_OPP');
1853: l_admin_flag VARCHAR2(1) := nvl(p_admin_flag, 'N');
1854: l_init_msg_list VARCHAR2(5) := 'T';
1855: l_commit VARCHAR2(5) := 'T';
1856: header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type := AS_API_RECORDS_PKG.get_p_header_rec;