DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_LEADS_PUB

Line 129: px_SALES_LEAD_rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

125: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
126:
127: PROCEDURE Set_default_values (
128: p_mode IN VARCHAR2,
129: px_SALES_LEAD_rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
130: )
131: IS
132: BEGIN
133:

Line 2654: P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,

2650: PROCEDURE Validate_sales_lead(
2651: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2652: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2653: P_Validation_mode IN VARCHAR2,
2654: P_SALES_LEAD_Rec IN OUT NOCOPY AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
2655: P_Referral_Type IN VARCHAR2,
2656: P_Referred_By IN NUMBER,
2657: X_Return_Status OUT NOCOPY VARCHAR2,
2658: X_Msg_Count OUT NOCOPY NUMBER,

Line 3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

3209: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
3210: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type

Line 3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

3210: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,

Line 3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type

3211: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,

Line 3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,

3212: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT

Line 3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type

3213: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,

Line 3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,

3214: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
3215: P_SALES_LEAD_LINE_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Tbl_type
3216: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_Tbl,
3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT

Line 3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,

3217: P_SALES_LEAD_CONTACT_Tbl IN AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Tbl_Type
3218: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_CONTACT_Tbl,
3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT
3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
3224: X_Return_Status OUT NOCOPY VARCHAR2,
3225: X_Msg_Count OUT NOCOPY NUMBER,

Line 3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,

3219: X_SALES_LEAD_ID OUT NOCOPY NUMBER,
3220: X_SALES_LEAD_LINE_OUT_Tbl OUT
3221: AS_SALES_LEADS_PUB.SALES_LEAD_LINE_OUT_Tbl_type,
3222: X_SALES_LEAD_CNT_OUT_Tbl OUT
3223: AS_SALES_LEADS_PUB.SALES_LEAD_CNT_OUT_Tbl_Type,
3224: X_Return_Status OUT NOCOPY VARCHAR2,
3225: X_Msg_Count OUT NOCOPY NUMBER,
3226: X_Msg_Data OUT NOCOPY VARCHAR2
3227: )

Line 3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

3238: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
3239: l_SALES_LEAD_ID NUMBER;
3240: l_sales_lead_line_id NUMBER;
3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;

Line 3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;

3240: l_sales_lead_line_id NUMBER;
3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
3247: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3248: l_Sales_Lead_Log_ID NUMBER;

Line 3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;

3241: l_lead_contact_id NUMBER;
3242: l_SALES_LEAD_Rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
3243: := p_sales_lead_rec;
3244: p_sales_lead_line_rec AS_SALES_LEADS_PUB.SALES_LEAD_LINE_Rec_Type;
3245: p_sales_lead_contact_rec AS_SALES_LEADS_PUB.SALES_LEAD_CONTACT_Rec_Type;
3246: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
3247: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
3248: l_Sales_Lead_Log_ID NUMBER;
3249: l_access_id NUMBER;

Line 3519: AS_SALES_LEADS_PUB.Get_Access_Profiles(

3515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3516: 'Calling Get_Access_Profiles');
3517: END IF;
3518:
3519: AS_SALES_LEADS_PUB.Get_Access_Profiles(
3520: p_profile_tbl => p_sales_lead_profile_tbl,
3521: x_access_profile_rec => l_access_profile_rec);
3522:
3523: IF (AS_DEBUG_LOW_ON) THEN

Line 4300: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,

4296: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
4297: P_Identity_Salesforce_Id IN NUMBER := FND_API.G_MISS_NUM,
4298: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4299: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4300: P_SALES_LEAD_Rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type,
4301: -- P_Calling_From_WF_Flag IN VARCHAR2 := 'N',
4302: X_Return_Status OUT NOCOPY VARCHAR2,
4303: X_Msg_Count OUT NOCOPY NUMBER,
4304: X_Msg_Data OUT NOCOPY VARCHAR2

Line 4510: l_tar_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

4506: l_api_name CONSTANT VARCHAR2(30) := 'Update_sales_lead';
4507: l_api_version_number CONSTANT NUMBER := 2.0;
4508: -- Local Variables
4509: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
4510: l_tar_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
4511: := P_SALES_LEAD_Rec;
4512: l_rowid ROWID;
4513: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
4514: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 4762: AS_SALES_LEADS_PUB.Get_Access_Profiles(

4758: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4759: 'Calling Get_Access_Profiles');
4760: END IF;
4761:
4762: AS_SALES_LEADS_PUB.Get_Access_Profiles(
4763: p_profile_tbl => p_sales_lead_profile_tbl,
4764: x_access_profile_rec => l_access_profile_rec);
4765:
4766:

Line 6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type

6477: /*
6478: This function is decomissioned
6479: -- function determines whether the Sales_Lead Is Qualified Or NOT.
6480: FUNCTION IS_LEAD_QUALIFIED(
6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
6483: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
6484: p_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
6485: ) RETURN VARCHAR

Line 6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,

6478: This function is decomissioned
6479: -- function determines whether the Sales_Lead Is Qualified Or NOT.
6480: FUNCTION IS_LEAD_QUALIFIED(
6481: P_Sales_lead_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type
6482: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC,
6483: p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
6484: p_contact_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
6485: ) RETURN VARCHAR
6486: IS