DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_LINES_PVT dependencies on AS_SALES_LEADS_PUB

Line 756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,

752: PROCEDURE Validate_sales_lead_line(
753: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
754: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
755: P_Validation_mode IN VARCHAR2,
756: P_SALES_LEAD_LINE_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type,
757: X_Return_Status OUT NOCOPY VARCHAR2,
758: X_Msg_Count OUT NOCOPY NUMBER,
759: X_Msg_Data OUT NOCOPY VARCHAR2
760: )

Line 991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type

987: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,

Line 992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,

988: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
989: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,
996: X_Msg_Count OUT NOCOPY NUMBER,

Line 994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

990: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
991: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
992: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
993: P_SALES_LEAD_ID IN NUMBER,
994: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
995: X_Return_Status OUT NOCOPY VARCHAR2,
996: X_Msg_Count OUT NOCOPY NUMBER,
997: X_Msg_Data OUT NOCOPY VARCHAR2
998: )

Line 1005: l_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_rec_type;

1001: l_api_name CONSTANT VARCHAR2(30) := 'Create_sales_lead_lines';
1002: l_api_version_number CONSTANT NUMBER := 2.0;
1003: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1004: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1005: l_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_rec_type;
1006: l_sales_lead_line_id NUMBER;
1007: l_customer_id NUMBER;
1008: l_address_id NUMBER;
1009: l_update_access_flag VARCHAR2(1);

Line 1304: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1300: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1301: 'Calling Get_Access_Profiles');
1302: END IF;
1303:
1304: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1305: p_profile_tbl => p_sales_lead_profile_tbl,
1306: x_access_profile_rec => l_access_profile_rec);
1307:
1308: IF (AS_DEBUG_LOW_ON) THEN

Line 1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

1543: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1549: X_Return_Status OUT NOCOPY VARCHAR2,
1550: X_Msg_Count OUT NOCOPY NUMBER,
1551: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

1544: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1546: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1547: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1548: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1549: X_Return_Status OUT NOCOPY VARCHAR2,
1550: X_Msg_Count OUT NOCOPY NUMBER,
1551: X_Msg_Data OUT NOCOPY VARCHAR2
1552: )

Line 1565: l_tar_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;

1561: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead_lines';
1562: l_api_version_number CONSTANT NUMBER := 2.0;
1563: -- Local Variables
1564: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1565: l_tar_SALES_LEAD_LINE_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
1566: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1567: l_Sales_Lead_Id NUMBER;
1568: l_Sales_Lead_Line_Id NUMBER;
1569: l_last_update_date DATE;

Line 1751: AS_SALES_LEADS_PUB.Get_Access_Profiles(

1747: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1748: 'Calling Get_Access_Profiles');
1749: END IF;
1750:
1751: AS_SALES_LEADS_PUB.Get_Access_Profiles(
1752: p_profile_tbl => p_sales_lead_profile_tbl,
1753: x_access_profile_rec => l_access_profile_rec);
1754:
1755: IF (AS_DEBUG_LOW_ON) THEN

Line 1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,

1974: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1981: X_Msg_Count OUT NOCOPY NUMBER,
1982: X_Msg_Data OUT NOCOPY VARCHAR2

Line 1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,

1975: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1976: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1977: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1978: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type,
1979: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_Type,
1980: X_Return_Status OUT NOCOPY VARCHAR2,
1981: X_Msg_Count OUT NOCOPY NUMBER,
1982: X_Msg_Data OUT NOCOPY VARCHAR2
1983: )

Line 1995: l_sales_lead_line_rec AS_SALES_LEADS_PUB.Sales_Lead_Line_Rec_Type;

1991: l_api_name CONSTANT VARCHAR2(30) := 'Delete_sales_lead_lines';
1992: l_api_version_number CONSTANT NUMBER := 2.0;
1993: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
1994: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1995: l_sales_lead_line_rec AS_SALES_LEADS_PUB.Sales_Lead_Line_Rec_Type;
1996: l_last_update_date DATE;
1997: l_delete_amounts NUMBER;
1998: l_budget_amount NUMBER;
1999: l_update_access_flag VARCHAR2(1);

Line 2116: AS_SALES_LEADS_PUB.Get_Access_Profiles(

2112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2113: 'Calling Get_Access_Profiles');
2114: END IF;
2115:
2116: AS_SALES_LEADS_PUB.Get_Access_Profiles(
2117: p_profile_tbl => p_sales_lead_profile_tbl,
2118: x_access_profile_rec => l_access_profile_rec);
2119:
2120: IF (AS_DEBUG_LOW_ON) THEN