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;
261: -- x_msg_data := l_msg_data;
262: RETURN;
263: ELSE
713: p_freeze_flag IN VARCHAR2,
714: header_rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_type
715: )
716: AS
717: l_num NUMBER := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_NUM');
718: l_char VARCHAR2(1) := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_CHAR');
719: l_date DATE := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_DATE');
720: l_last_update_date DATE;
721: --Code commented for R12 Enhancement --Start
714: header_rec IN OUT NOCOPY AS_OPPORTUNITY_PUB.Header_Rec_type
715: )
716: AS
717: l_num NUMBER := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_NUM');
718: l_char VARCHAR2(1) := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_CHAR');
719: l_date DATE := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_DATE');
720: l_last_update_date DATE;
721: --Code commented for R12 Enhancement --Start
722: --l_close_competitor VARCHAR2(4000);
715: )
716: AS
717: l_num NUMBER := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_NUM');
718: l_char VARCHAR2(1) := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_CHAR');
719: l_date DATE := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_DATE');
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
778: -- header_rec.freeze_flag := NVL(p_freeze_flag, l_char);
779: /** commented by magesh the above one line for freeze flag for bug.3357959**/
780: -- header_rec.price_list_id := null;
781:
782: header_rec.attribute_category := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
779: /** commented by magesh the above one line for freeze flag for bug.3357959**/
780: -- header_rec.price_list_id := null;
781:
782: header_rec.attribute_category := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
780: -- header_rec.price_list_id := null;
781:
782: header_rec.attribute_category := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
781:
782: header_rec.attribute_category := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
782: header_rec.attribute_category := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
783: header_rec.attribute1 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
784: header_rec.attribute2 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
785: header_rec.attribute3 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
786: header_rec.attribute4 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
787: header_rec.attribute5 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
788: header_rec.attribute6 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
789: header_rec.attribute7 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
797: header_rec.attribute15 := FND_API.G_MISS_CHAR;
790: header_rec.attribute8 := FND_API.G_MISS_CHAR;
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
797: header_rec.attribute15 := FND_API.G_MISS_CHAR;
798: --Code added for R12 Enhancement ---Start
791: header_rec.attribute9 := FND_API.G_MISS_CHAR;
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
797: header_rec.attribute15 := FND_API.G_MISS_CHAR;
798: --Code added for R12 Enhancement ---Start
799: header_rec.TOTAL_REVENUE_OPP_FORECAST_AMT := NVL(p_total_revenue_forecast_amt, l_num);
792: header_rec.attribute10 := FND_API.G_MISS_CHAR;
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
797: header_rec.attribute15 := FND_API.G_MISS_CHAR;
798: --Code added for R12 Enhancement ---Start
799: header_rec.TOTAL_REVENUE_OPP_FORECAST_AMT := NVL(p_total_revenue_forecast_amt, l_num);
800: --Code added for R12 Enhancement ---End
793: header_rec.attribute11 := FND_API.G_MISS_CHAR;
794: header_rec.attribute12 := FND_API.G_MISS_CHAR;
795: header_rec.attribute13 := FND_API.G_MISS_CHAR;
796: header_rec.attribute14 := FND_API.G_MISS_CHAR;
797: header_rec.attribute15 := FND_API.G_MISS_CHAR;
798: --Code added for R12 Enhancement ---Start
799: header_rec.TOTAL_REVENUE_OPP_FORECAST_AMT := NVL(p_total_revenue_forecast_amt, l_num);
800: --Code added for R12 Enhancement ---End
801:
1369: RAISE;
1370: END create_lead;
1371:
1372: PROCEDURE update_lead (
1373: p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,
1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1370: END create_lead;
1371:
1372: PROCEDURE update_lead (
1373: p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,
1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1371:
1372: PROCEDURE update_lead (
1373: p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,
1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1373: p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,
1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1375: p_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1376: p_last_update_date IN DATE,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1378: p_customer_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1379: p_address_id IN NUMBER := FND_API.G_MISS_NUM,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1380: p_assign_to_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1381: p_admin_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1385: p_source_promotion_id IN NUMBER := FND_API.G_MISS_NUM,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
1394: x_return_status OUT NOCOPY VARCHAR2,
1387: p_decision_timeframe_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
1394: x_return_status OUT NOCOPY VARCHAR2,
1395: x_msg_count OUT NOCOPY NUMBER,
1388: p_initiating_contact_id IN NUMBER := FND_API.G_MISS_NUM,
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
1394: x_return_status OUT NOCOPY VARCHAR2,
1395: x_msg_count OUT NOCOPY NUMBER,
1396: x_msg_data OUT NOCOPY VARCHAR2
1389: p_accept_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1390: p_qualified_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1391: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
1392: p_close_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,
1394: x_return_status OUT NOCOPY VARCHAR2,
1395: x_msg_count OUT NOCOPY NUMBER,
1396: x_msg_data OUT NOCOPY VARCHAR2
1397: )
1951: dbms_output.put_line('Update Opp: There are ' || l_count || ' messages.');
1952: FOR l_index IN 1..l_count LOOP
1953: my_message := FND_MSG_PUB.Get(
1954: p_msg_index => l_index,
1955: p_encoded => FND_API.G_FALSE);
1956: dbms_output.put_line(substr(my_message,1,255));
1957: END LOOP;
1958:
1959: rollback;