DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PUB dependencies on AS_UTILITY_PUB

Line 337: -- Record name:AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL

333: sales_team_flag VARCHAR2(1)
334: );
335:
336: -- -------------------------------------------------------
337: -- Record name:AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL
338: -- -------------------------------------------------------
339:
340: --
341: -- API Name: Create_sales_leads

Line 352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

348: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
349: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
351: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
352: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
353: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
354: P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type
355: DEFAULT G_MISS_SALES_LEAD_LINE_tbl,
356: P_SALES_LEAD_CONTACT_tbl IN SALES_LEAD_CONTACT_tbl_type

Line 399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

395: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
396: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
397: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
398: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
399: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
400: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type
401: DEFAULT G_MISS_SALES_LEAD_REC,
402: X_Return_Status OUT NOCOPY VARCHAR2,
403: X_Msg_Count OUT NOCOPY NUMBER,

Line 420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

416: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
417: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
418: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
419: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
420: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
421: P_SALES_LEAD_ID IN NUMBER,
422: X_Return_Status OUT NOCOPY VARCHAR2,
423: X_Msg_Count OUT NOCOPY NUMBER,
424: X_Msg_Data OUT NOCOPY VARCHAR2

Line 465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

461: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
462: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
463: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
464: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
465: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
466: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type
467: := G_MISS_SALES_LEAD_LINE_Tbl,
468: P_SALES_LEAD_ID IN NUMBER,
469: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,

Line 510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

506: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
507: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
508: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
509: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
510: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
511: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
512: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
513: X_Return_Status OUT NOCOPY VARCHAR2,
514: X_Msg_Count OUT NOCOPY NUMBER,

Line 553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

549: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
550: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
551: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
552: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
553: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
554: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type,
555: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
556: X_Return_Status OUT NOCOPY VARCHAR2,
557: X_Msg_Count OUT NOCOPY NUMBER,

Line 598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

594: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
595: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
596: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
597: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
598: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
599: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type
600: := G_MISS_SALES_LEAD_CONTACT_Tbl,
601: p_SALES_LEAD_ID IN NUMBER,
602: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,

Line 642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

638: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
639: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
640: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
641: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
642: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
643: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
644: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
645: X_Return_Status OUT NOCOPY VARCHAR2,
646: X_Msg_Count OUT NOCOPY NUMBER,

Line 684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

680: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
681: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
682: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
683: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
684: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
685: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_type,
686: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
687: X_Return_Status OUT NOCOPY VARCHAR2,
688: X_Msg_Count OUT NOCOPY NUMBER,

Line 708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

704: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
705: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
706: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
707: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
708: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
709: P_SALES_LEAD_rec IN SALES_LEAD_rec_type,
710: X_Return_Status OUT NOCOPY VARCHAR2,
711: X_Msg_Count OUT NOCOPY NUMBER,
712: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

728: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
729: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
730: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
731: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
732: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
733: P_SALES_LEAD_ID IN NUMBER,
734: P_SALES_LEAD_LINE_TBL IN SALES_LEAD_LINE_TBL_TYPE
735: := G_MISS_SALES_LEAD_LINE_TBL,
736: P_OPPORTUNITY_ID IN NUMBER,

Line 757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

753: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
754: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
755: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
756: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
757: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
758: P_SALES_LEAD_ID IN NUMBER,
759: P_OPPORTUNITY_ID IN NUMBER,
760: X_Return_Status OUT NOCOPY VARCHAR2,
761: X_Msg_Count OUT NOCOPY NUMBER,

Line 779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

775: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781: P_SALES_LEAD_ID IN NUMBER,
782: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: X_Return_Status OUT NOCOPY VARCHAR2,

Line 780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

776: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
777: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
778: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
779: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
780: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
781: P_SALES_LEAD_ID IN NUMBER,
782: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
783: X_Return_Status OUT NOCOPY VARCHAR2,
784: X_Msg_Count OUT NOCOPY NUMBER,

Line 798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

794: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
795: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
796: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
797: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
798: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
799: P_Sales_Lead_Id IN NUMBER,
800: X_Return_Status OUT NOCOPY VARCHAR2,
801: X_Msg_Count OUT NOCOPY NUMBER,
802: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 818: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

814: -- APIs.
815: --
816:
817: PROCEDURE Get_Access_Profiles(
818: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
819: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
820: );
821:
822: --

Line 833: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

829: -- the profile value is NULL or FND_API.G_MISS_CHAR,
830: -- the function will return NULL
831: --
832: FUNCTION Get_Profile(
833: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
834: p_profile_name IN VARCHAR2 )
835: RETURN VARCHAR2;
836:
837: PROCEDURE CALL_WF_TO_ASSIGN (