DBA Data[Home] [Help]

APPS.IBE_LEAD_IMPORT_PVT dependencies on AS_SALES_LEADS_PUB

Line 1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,

1466: x_return_status OUT NOCOPY VARCHAR2,
1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: x_msg_count OUT NOCOPY NUMBER,
1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;

Line 1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE

1467: x_msg_data OUT NOCOPY VARCHAR2,
1468: x_msg_count OUT NOCOPY NUMBER,
1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

Line 1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;

1469: x_sales_lead_id OUT NOCOPY NUMBER,
1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

Line 1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;

1470: x_sales_lead_line_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_TBL_TYPE,
1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

Line 1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;

1471: x_sales_lead_cnt_out_tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_TBL_TYPE
1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

Line 1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;

1472: ) IS
1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;

Line 1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;

1473: l_sales_lead_rec as_sales_leads_pub.sales_lead_rec_type;
1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;

Line 1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;

1474: l_sales_lead_line_rec as_sales_leads_pub.sales_lead_line_rec_type;
1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;
1482: l_msg_data VARCHAR2(2000) := NULL;

Line 1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;

1475: l_sales_lead_line_tbl as_sales_leads_pub.sales_lead_line_tbl_type;
1476: l_sales_lead_contact_rec as_sales_leads_pub.sales_lead_contact_rec_type;
1477: l_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
1478: l_sales_lead_line_out_tbl as_sales_leads_pub.sales_lead_line_out_tbl_type;
1479: l_sales_lead_cnt_out_tbl as_sales_leads_pub.sales_lead_cnt_out_tbl_type;
1480: l_sales_lead_profile_tbl as_utility_pub.profile_tbl_type;
1481: l_sales_lead_id NUMBER;
1482: l_msg_data VARCHAR2(2000) := NULL;
1483: l_api_message VARCHAR2(2000);

Line 1564: printDebug('Calling as_sales_leads_pub.create_sales_lead', 'Create_Sales_Lead');

1560: printDebug('contacT_party_id = ' || p_header_rec.rel_party_id || ' customer_id = ' || p_header_rec.party_id,
1561: 'Create_Sales_Lead');
1562: end if;
1563:
1564: printDebug('Calling as_sales_leads_pub.create_sales_lead', 'Create_Sales_Lead');
1565: as_sales_leads_pub.create_sales_lead(
1566: p_api_version_number => 2.0,
1567: p_init_msg_list => FND_API.G_FALSE,
1568: p_commit => FND_API.G_FALSE,

Line 1565: as_sales_leads_pub.create_sales_lead(

1561: 'Create_Sales_Lead');
1562: end if;
1563:
1564: printDebug('Calling as_sales_leads_pub.create_sales_lead', 'Create_Sales_Lead');
1565: as_sales_leads_pub.create_sales_lead(
1566: p_api_version_number => 2.0,
1567: p_init_msg_list => FND_API.G_FALSE,
1568: p_commit => FND_API.G_FALSE,
1569: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1593: printDebug('After calling as_sales_leads_pub.create_sales_lead ' || x_return_status, 'Create_Sales_lead');

1589: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1590: end if;
1591:
1592:
1593: printDebug('After calling as_sales_leads_pub.create_sales_lead ' || x_return_status, 'Create_Sales_lead');
1594: if( x_msg_count > 1 ) then
1595: For i in 1..x_msg_count LOOP
1596: printDebug(FND_MSG_PUB.GET(i, FND_API.G_FALSE), 'Create_sales_lead');
1597: end LOOP;