eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEADS_PUB dependencies on AS_UTILITY_PUB

Line 88: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

84: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
85: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
87: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
88: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
89: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
90: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
91: P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type
92: DEFAULT G_MISS_SALES_LEAD_LINE_tbl,

Line 89: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

85: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
86: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
87: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
88: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
89: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
90: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type := G_MISS_SALES_LEAD_REC,
91: P_SALES_LEAD_LINE_tbl IN SALES_LEAD_LINE_tbl_type
92: DEFAULT G_MISS_SALES_LEAD_LINE_tbl,
93: P_SALES_LEAD_CONTACT_tbl IN SALES_LEAD_CONTACT_tbl_type

Line 258: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

254: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
257: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
258: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
259: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
260: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type DEFAULT G_MISS_SALES_LEAD_REC,
261: X_Return_Status OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER,

Line 259: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

255: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
257: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
258: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
259: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
260: P_SALES_LEAD_Rec IN SALES_LEAD_Rec_Type DEFAULT G_MISS_SALES_LEAD_REC,
261: X_Return_Status OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER,
263: X_Msg_Data OUT NOCOPY VARCHAR2

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

413: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
414: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
415: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
416: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
417: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
418: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_type
419: := G_MISS_SALES_LEAD_LINE_Tbl,
420: p_SALES_LEAD_ID IN NUMBER,
421: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,

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

573: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
574: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
575: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
576: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
577: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
578: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
579: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
580: X_Return_Status OUT NOCOPY VARCHAR2,
581: X_Msg_Count OUT NOCOPY NUMBER,

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

733: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
734: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
735: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
736: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
737: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
738: P_SALES_LEAD_LINE_Tbl IN SALES_LEAD_LINE_Tbl_Type,
739: X_SALES_LEAD_LINE_OUT_Tbl OUT NOCOPY SALES_LEAD_LINE_OUT_Tbl_Type,
740: X_Return_Status OUT NOCOPY VARCHAR2,
741: X_Msg_Count OUT NOCOPY NUMBER,

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

896: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
897: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
898: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
899: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
900: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
901: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type
902: := G_MISS_SALES_LEAD_CONTACT_Tbl,
903: p_SALES_LEAD_ID IN NUMBER,
904: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,

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

1055: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1056: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1057: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1058: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1059: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1060: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
1061: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
1062: X_Return_Status OUT NOCOPY VARCHAR2,
1063: X_Msg_Count OUT NOCOPY NUMBER,

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

1214: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1215: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1216: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1217: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1218: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1219: P_SALES_LEAD_CONTACT_Tbl IN SALES_LEAD_CONTACT_Tbl_Type,
1220: X_SALES_LEAD_CNT_OUT_Tbl OUT NOCOPY SALES_LEAD_CNT_OUT_Tbl_Type,
1221: X_Return_Status OUT NOCOPY VARCHAR2,
1222: X_Msg_Count OUT NOCOPY NUMBER,

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

1376: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1377: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1378: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1379: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1380: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1381: P_SALES_LEAD_rec IN SALES_LEAD_rec_type,
1382: X_Return_Status OUT NOCOPY VARCHAR2,
1383: X_Msg_Count OUT NOCOPY NUMBER,
1384: X_Msg_Data OUT NOCOPY VARCHAR2,

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

1543: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1544: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1545: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1546: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
1547: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1548: P_SALES_LEAD_ID IN NUMBER,
1549: P_SALES_LEAD_LINE_TBL IN SALES_LEAD_LINE_TBL_TYPE
1550: := G_MISS_SALES_LEAD_LINE_TBL,
1551: P_OPPORTUNITY_ID IN NUMBER,

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

1711: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
1712: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
1713: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
1714: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
1715: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1716: P_SALES_LEAD_ID IN NUMBER,
1717: P_OPPORTUNITY_ID IN NUMBER,
1718: X_Return_Status OUT NOCOPY VARCHAR2,
1719: X_Msg_Count OUT NOCOPY NUMBER,

Line 2493: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2489: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2490: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2491: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2492: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2493: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2494: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2495: P_SALES_LEAD_ID IN NUMBER,
2496: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
2497: X_Return_Status OUT NOCOPY VARCHAR2,

Line 2494: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2490: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2491: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2492: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
2493: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2494: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2495: P_SALES_LEAD_ID IN NUMBER,
2496: P_OPP_STATUS IN VARCHAR2 := FND_API.G_MISS_CHAR,
2497: X_Return_Status OUT NOCOPY VARCHAR2,
2498: X_Msg_Count OUT NOCOPY NUMBER,

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

2909: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2910: P_Admin_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
2911: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
2912: P_identity_salesforce_id IN NUMBER := FND_API.G_MISS_NUM,
2913: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2914: P_Sales_Lead_Id IN NUMBER,
2915: X_Return_Status OUT NOCOPY VARCHAR2,
2916: X_Msg_Count OUT NOCOPY NUMBER,
2917: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 3072: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

3068: ,X_RETURN_STATUS => X_RETURN_STATUS);
3069: End Assign_Sales_Lead;
3070:
3071: PROCEDURE Get_Access_Profiles(
3072: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
3073: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type)
3074: IS
3075:
3076: l_profile_count CONSTANT NUMBER := p_profile_tbl.count;

Line 3144: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

3140: END Get_Access_Profiles;
3141:
3142:
3143: FUNCTION Get_Profile(
3144: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
3145: p_profile_name IN VARCHAR2 )
3146: RETURN VARCHAR2
3147: IS
3148: l_profile_count CONSTANT NUMBER := p_profile_tbl.count;

Line 4110: l_sales_lead_profile_tbl AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL;

4106: l_api_name CONSTANT VARCHAR2(30) := 'Route_Lead_To_Marketing';
4107: l_api_version_number CONSTANT NUMBER := 2.0;
4108: l_Sales_Team_Rec AS_ACCESS_PUB.Sales_Team_Rec_Type := AS_ACCESS_PUB.G_MISS_SALES_TEAM_REC;
4109: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4110: l_sales_lead_profile_tbl AS_UTILITY_PUB.Profile_Tbl_Type := AS_UTILITY_PUB.G_MISS_PROFILE_TBL;
4111: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
4112:
4113: l_assign_sales_group_id NUMBER;
4114: l_assign_to_person_id NUMBER;