DBA Data[Home] [Help]

APPS.AST_UWQ_WRAPPER_PKG dependencies on FND_API

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 717: l_num NUMBER := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_NUM');

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

Line 718: l_char VARCHAR2(1) := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_CHAR');

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);

Line 719: l_date DATE := AS_FOUNDATION_PUB.Get_Constant('FND_API.G_MISS_DATE');

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

Line 782: header_rec.attribute_category := FND_API.G_MISS_CHAR;

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;

Line 783: header_rec.attribute1 := 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;

Line 784: header_rec.attribute2 := 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;

Line 785: header_rec.attribute3 := 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;

Line 786: header_rec.attribute4 := 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;

Line 787: header_rec.attribute5 := 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;

Line 788: header_rec.attribute6 := 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;

Line 789: header_rec.attribute7 := 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;

Line 790: header_rec.attribute8 := 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;

Line 791: header_rec.attribute9 := 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;

Line 792: header_rec.attribute10 := 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;

Line 793: header_rec.attribute11 := 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;

Line 794: header_rec.attribute12 := 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

Line 795: header_rec.attribute13 := 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
799: header_rec.TOTAL_REVENUE_OPP_FORECAST_AMT := NVL(p_total_revenue_forecast_amt, l_num);

Line 796: header_rec.attribute14 := 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);
800: --Code added for R12 Enhancement ---End

Line 797: header_rec.attribute15 := 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
801:

Line 1373: p_sales_lead_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 1374: p_admin_group_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 1375: p_identity_salesforce_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,

Line 1377: p_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 1378: p_customer_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,
1382: p_assign_sales_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1379: p_address_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,

Line 1380: p_assign_to_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,
1384: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 1381: p_admin_flag 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,

Line 1382: p_assign_sales_group_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,

Line 1383: p_budget_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 1384: p_description 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,

Line 1385: p_source_promotion_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,

Line 1386: p_lead_rank_id IN NUMBER := FND_API.G_MISS_NUM,

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,

Line 1387: p_decision_timeframe_code 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,

Line 1388: p_initiating_contact_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,

Line 1389: p_accept_flag 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,

Line 1390: p_qualified_flag 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,

Line 1391: p_phone_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,
1395: x_msg_count OUT NOCOPY NUMBER,

Line 1392: p_close_reason_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,
1396: x_msg_data OUT NOCOPY VARCHAR2

Line 1393: p_called_node IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: )

Line 1955: p_encoded => FND_API.G_FALSE);

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;