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_OPPORTUNITY_PUB dependencies on AS_UTILITY_PUB

Line 33: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

29: p_admin_group_id IN NUMBER,
30: p_identity_salesforce_id IN NUMBER,
31: p_salesgroup_id IN NUMBER DEFAULT NULL,
32: p_partner_cont_party_id IN NUMBER,
33: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
34: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,

Line 34: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

30: p_identity_salesforce_id IN NUMBER,
31: p_salesgroup_id IN NUMBER DEFAULT NULL,
32: p_partner_cont_party_id IN NUMBER,
33: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
34: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: x_lead_id OUT NOCOPY NUMBER

Line 266: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

262: p_admin_flag IN VARCHAR2,
263: p_admin_group_id IN NUMBER,
264: p_identity_salesforce_id IN NUMBER,
265: p_partner_cont_party_id IN NUMBER,
266: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
267: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,

Line 267: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

263: p_admin_group_id IN NUMBER,
264: p_identity_salesforce_id IN NUMBER,
265: p_partner_cont_party_id IN NUMBER,
266: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
267: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,
271: x_lead_id OUT NOCOPY NUMBER)

Line 517: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

513: p_admin_flag IN VARCHAR2,
514: p_admin_group_id IN NUMBER,
515: p_identity_salesforce_id IN NUMBER,
516: p_partner_cont_party_id IN NUMBER,
517: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
518: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,

Line 518: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

514: p_admin_group_id IN NUMBER,
515: p_identity_salesforce_id IN NUMBER,
516: p_partner_cont_party_id IN NUMBER,
517: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
518: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,
522: x_lead_id OUT NOCOPY NUMBER)

Line 689: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

685: p_admin_group_id IN NUMBER,
686: p_identity_salesforce_id IN NUMBER,
687: p_salesgroup_id IN NUMBER DEFAULT NULL,
688: p_partner_cont_party_id IN NUMBER,
689: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
690: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
691: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,

Line 690: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

686: p_identity_salesforce_id IN NUMBER,
687: p_salesgroup_id IN NUMBER DEFAULT NULL,
688: p_partner_cont_party_id IN NUMBER,
689: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
690: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
691: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
694: x_msg_data OUT NOCOPY VARCHAR2)

Line 870: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

866: p_check_access_flag IN VARCHAR2,
867: p_admin_flag IN VARCHAR2,
868: p_admin_group_id IN NUMBER,
869: p_partner_cont_party_id IN NUMBER,
870: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
871: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
872: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
873: x_return_status OUT NOCOPY VARCHAR2,
874: x_msg_count OUT NOCOPY NUMBER,

Line 871: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

867: p_admin_flag IN VARCHAR2,
868: p_admin_group_id IN NUMBER,
869: p_partner_cont_party_id IN NUMBER,
870: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
871: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
872: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
873: x_return_status OUT NOCOPY VARCHAR2,
874: x_msg_count OUT NOCOPY NUMBER,
875: x_msg_data OUT NOCOPY VARCHAR2)

Line 1046: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1042: p_check_access_flag IN VARCHAR2,
1043: p_admin_flag IN VARCHAR2,
1044: p_admin_group_id IN NUMBER,
1045: p_partner_cont_party_id IN NUMBER,
1046: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1047: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1048: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1049: x_return_status OUT NOCOPY VARCHAR2,
1050: x_msg_count OUT NOCOPY NUMBER,

Line 1047: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1043: p_admin_flag IN VARCHAR2,
1044: p_admin_group_id IN NUMBER,
1045: p_partner_cont_party_id IN NUMBER,
1046: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1047: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1048: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1049: x_return_status OUT NOCOPY VARCHAR2,
1050: x_msg_count OUT NOCOPY NUMBER,
1051: x_msg_data OUT NOCOPY VARCHAR2)

Line 1213: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1209: p_check_access_flag IN VARCHAR2,
1210: p_admin_flag IN VARCHAR2,
1211: p_admin_group_id IN NUMBER,
1212: p_partner_cont_party_id IN NUMBER,
1213: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1214: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1215: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,

Line 1214: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1210: p_admin_flag IN VARCHAR2,
1211: p_admin_group_id IN NUMBER,
1212: p_partner_cont_party_id IN NUMBER,
1213: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1214: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1215: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,
1218: x_msg_data OUT NOCOPY VARCHAR2)

Line 1380: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1376: p_check_access_flag IN VARCHAR2,
1377: p_admin_flag IN VARCHAR2,
1378: p_admin_group_id IN NUMBER,
1379: p_partner_cont_party_id IN NUMBER,
1380: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1381: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1382: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1383: x_return_status OUT NOCOPY VARCHAR2,
1384: x_msg_count OUT NOCOPY NUMBER,

Line 1381: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1377: p_admin_flag IN VARCHAR2,
1378: p_admin_group_id IN NUMBER,
1379: p_partner_cont_party_id IN NUMBER,
1380: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1381: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1382: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1383: x_return_status OUT NOCOPY VARCHAR2,
1384: x_msg_count OUT NOCOPY NUMBER,
1385: x_msg_data OUT NOCOPY VARCHAR2)

Line 1546: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1542: p_check_access_flag IN VARCHAR2,
1543: p_admin_flag IN VARCHAR2,
1544: p_admin_group_id IN NUMBER,
1545: p_partner_cont_party_id IN NUMBER,
1546: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1547: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1548: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1549: x_return_status OUT NOCOPY VARCHAR2,
1550: x_msg_count OUT NOCOPY NUMBER,

Line 1547: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1543: p_admin_flag IN VARCHAR2,
1544: p_admin_group_id IN NUMBER,
1545: p_partner_cont_party_id IN NUMBER,
1546: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1547: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1548: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_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 1709: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1705: p_check_access_flag IN VARCHAR2,
1706: p_admin_flag IN VARCHAR2,
1707: p_admin_group_id IN NUMBER,
1708: p_partner_cont_party_id IN NUMBER,
1709: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1710: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1711: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_count OUT NOCOPY NUMBER,

Line 1710: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1706: p_admin_flag IN VARCHAR2,
1707: p_admin_group_id IN NUMBER,
1708: p_partner_cont_party_id IN NUMBER,
1709: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1710: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1711: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_count OUT NOCOPY NUMBER,
1714: x_msg_data OUT NOCOPY VARCHAR2)

Line 1873: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1869: p_check_access_flag IN VARCHAR2,
1870: p_admin_flag IN VARCHAR2,
1871: p_admin_group_id IN NUMBER,
1872: p_partner_cont_party_id IN NUMBER,
1873: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1874: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1875: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1876: x_return_status OUT NOCOPY VARCHAR2,
1877: x_msg_count OUT NOCOPY NUMBER,

Line 1874: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1870: p_admin_flag IN VARCHAR2,
1871: p_admin_group_id IN NUMBER,
1872: p_partner_cont_party_id IN NUMBER,
1873: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1874: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1875: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1876: x_return_status OUT NOCOPY VARCHAR2,
1877: x_msg_count OUT NOCOPY NUMBER,
1878: x_msg_data OUT NOCOPY VARCHAR2)

Line 2041: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2037: p_check_access_flag IN VARCHAR2,
2038: p_admin_flag IN VARCHAR2,
2039: p_admin_group_id IN NUMBER,
2040: p_partner_cont_party_id IN NUMBER,
2041: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2042: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2043: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,

Line 2042: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2038: p_admin_flag IN VARCHAR2,
2039: p_admin_group_id IN NUMBER,
2040: p_partner_cont_party_id IN NUMBER,
2041: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2042: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2043: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,
2046: x_msg_data OUT NOCOPY VARCHAR2)

Line 2205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2201: p_check_access_flag IN VARCHAR2,
2202: p_admin_flag IN VARCHAR2,
2203: p_admin_group_id IN NUMBER,
2204: p_partner_cont_party_id IN NUMBER,
2205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2207: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2208: x_return_status OUT NOCOPY VARCHAR2,
2209: x_msg_count OUT NOCOPY NUMBER,

Line 2206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2202: p_admin_flag IN VARCHAR2,
2203: p_admin_group_id IN NUMBER,
2204: p_partner_cont_party_id IN NUMBER,
2205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2207: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2208: x_return_status OUT NOCOPY VARCHAR2,
2209: x_msg_count OUT NOCOPY NUMBER,
2210: x_msg_data OUT NOCOPY VARCHAR2)

Line 2372: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2368: p_check_access_flag IN VARCHAR2,
2369: p_admin_flag IN VARCHAR2,
2370: p_admin_group_id IN NUMBER,
2371: p_partner_cont_party_id IN NUMBER,
2372: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2373: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2374: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2375: x_return_status OUT NOCOPY VARCHAR2,
2376: x_msg_count OUT NOCOPY NUMBER,

Line 2373: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2369: p_admin_flag IN VARCHAR2,
2370: p_admin_group_id IN NUMBER,
2371: p_partner_cont_party_id IN NUMBER,
2372: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2373: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2374: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2375: x_return_status OUT NOCOPY VARCHAR2,
2376: x_msg_count OUT NOCOPY NUMBER,
2377: x_msg_data OUT NOCOPY VARCHAR2)

Line 2537: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2533: p_check_access_flag IN VARCHAR2,
2534: p_admin_flag IN VARCHAR2,
2535: p_admin_group_id IN NUMBER,
2536: p_partner_cont_party_id IN NUMBER,
2537: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2538: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2539: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2540: x_return_status OUT NOCOPY VARCHAR2,
2541: x_msg_count OUT NOCOPY NUMBER,

Line 2538: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2534: p_admin_flag IN VARCHAR2,
2535: p_admin_group_id IN NUMBER,
2536: p_partner_cont_party_id IN NUMBER,
2537: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2538: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2539: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
2540: x_return_status OUT NOCOPY VARCHAR2,
2541: x_msg_count OUT NOCOPY NUMBER,
2542: x_msg_data OUT NOCOPY VARCHAR2)

Line 2701: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2697: p_check_access_flag IN VARCHAR2,
2698: p_admin_flag IN VARCHAR2,
2699: p_admin_group_id IN NUMBER,
2700: p_partner_cont_party_id IN NUMBER,
2701: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2702: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2703: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,

Line 2702: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2698: p_admin_flag IN VARCHAR2,
2699: p_admin_group_id IN NUMBER,
2700: p_partner_cont_party_id IN NUMBER,
2701: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2702: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2703: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
2704: x_return_status OUT NOCOPY VARCHAR2,
2705: x_msg_count OUT NOCOPY NUMBER,
2706: x_msg_data OUT NOCOPY VARCHAR2)

Line 2869: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

2865: p_check_access_flag IN VARCHAR2,
2866: p_admin_flag IN VARCHAR2,
2867: p_admin_group_id IN NUMBER,
2868: p_partner_cont_party_id IN NUMBER,
2869: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2870: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2871: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
2872: x_return_status OUT NOCOPY VARCHAR2,
2873: x_msg_count OUT NOCOPY NUMBER,

Line 2870: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

2866: p_admin_flag IN VARCHAR2,
2867: p_admin_group_id IN NUMBER,
2868: p_partner_cont_party_id IN NUMBER,
2869: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
2870: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
2871: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
2872: x_return_status OUT NOCOPY VARCHAR2,
2873: x_msg_count OUT NOCOPY NUMBER,
2874: x_msg_data OUT NOCOPY VARCHAR2)

Line 3033: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3029: p_check_access_flag IN VARCHAR2,
3030: p_admin_flag IN VARCHAR2,
3031: p_admin_group_id IN NUMBER,
3032: p_partner_cont_party_id IN NUMBER,
3033: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3034: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3035: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: x_msg_count OUT NOCOPY NUMBER,

Line 3034: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3030: p_admin_flag IN VARCHAR2,
3031: p_admin_group_id IN NUMBER,
3032: p_partner_cont_party_id IN NUMBER,
3033: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3034: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3035: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
3036: x_return_status OUT NOCOPY VARCHAR2,
3037: x_msg_count OUT NOCOPY NUMBER,
3038: x_msg_data OUT NOCOPY VARCHAR2)

Line 3198: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3194: p_check_access_flag IN VARCHAR2,
3195: p_admin_flag IN VARCHAR2,
3196: p_admin_group_id IN NUMBER,
3197: p_partner_cont_party_id IN NUMBER,
3198: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3199: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3200: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3201: x_return_status OUT NOCOPY VARCHAR2,
3202: x_msg_count OUT NOCOPY NUMBER,

Line 3199: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3195: p_admin_flag IN VARCHAR2,
3196: p_admin_group_id IN NUMBER,
3197: p_partner_cont_party_id IN NUMBER,
3198: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3199: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3200: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3201: x_return_status OUT NOCOPY VARCHAR2,
3202: x_msg_count OUT NOCOPY NUMBER,
3203: x_msg_data OUT NOCOPY VARCHAR2)

Line 3365: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3361: p_check_access_flag IN VARCHAR2,
3362: p_admin_flag IN VARCHAR2,
3363: p_admin_group_id IN NUMBER,
3364: p_partner_cont_party_id IN NUMBER,
3365: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3366: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3367: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3368: x_return_status OUT NOCOPY VARCHAR2,
3369: x_msg_count OUT NOCOPY NUMBER,

Line 3366: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3362: p_admin_flag IN VARCHAR2,
3363: p_admin_group_id IN NUMBER,
3364: p_partner_cont_party_id IN NUMBER,
3365: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3366: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3367: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3368: x_return_status OUT NOCOPY VARCHAR2,
3369: x_msg_count OUT NOCOPY NUMBER,
3370: x_msg_data OUT NOCOPY VARCHAR2)

Line 3529: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3525: p_check_access_flag IN VARCHAR2,
3526: p_admin_flag IN VARCHAR2,
3527: p_admin_group_id IN NUMBER,
3528: p_partner_cont_party_id IN NUMBER,
3529: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3530: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3531: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3532: x_return_status OUT NOCOPY VARCHAR2,
3533: x_msg_count OUT NOCOPY NUMBER,

Line 3530: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3526: p_admin_flag IN VARCHAR2,
3527: p_admin_group_id IN NUMBER,
3528: p_partner_cont_party_id IN NUMBER,
3529: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3530: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3531: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
3532: x_return_status OUT NOCOPY VARCHAR2,
3533: x_msg_count OUT NOCOPY NUMBER,
3534: x_msg_data OUT NOCOPY VARCHAR2)

Line 3695: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3691: p_check_access_flag IN VARCHAR2,
3692: p_admin_flag IN VARCHAR2,
3693: p_admin_group_id IN NUMBER,
3694: p_partner_cont_party_id IN NUMBER,
3695: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3696: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3697: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
3698: x_return_status OUT NOCOPY VARCHAR2,
3699: x_msg_count OUT NOCOPY NUMBER,

Line 3696: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3692: p_admin_flag IN VARCHAR2,
3693: p_admin_group_id IN NUMBER,
3694: p_partner_cont_party_id IN NUMBER,
3695: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3696: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3697: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
3698: x_return_status OUT NOCOPY VARCHAR2,
3699: x_msg_count OUT NOCOPY NUMBER,
3700: x_msg_data OUT NOCOPY VARCHAR2)

Line 3862: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

3858: p_check_access_flag IN VARCHAR2,
3859: p_admin_flag IN VARCHAR2,
3860: p_admin_group_id IN NUMBER,
3861: p_partner_cont_party_id IN NUMBER,
3862: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3863: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3864: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
3865: x_return_status OUT NOCOPY VARCHAR2,
3866: x_msg_count OUT NOCOPY NUMBER,

Line 3863: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

3859: p_admin_flag IN VARCHAR2,
3860: p_admin_group_id IN NUMBER,
3861: p_partner_cont_party_id IN NUMBER,
3862: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
3863: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
3864: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
3865: x_return_status OUT NOCOPY VARCHAR2,
3866: x_msg_count OUT NOCOPY NUMBER,
3867: x_msg_data OUT NOCOPY VARCHAR2)

Line 4027: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4023: p_check_access_flag IN VARCHAR2,
4024: p_admin_flag IN VARCHAR2,
4025: p_admin_group_id IN NUMBER,
4026: p_partner_cont_party_id IN NUMBER,
4027: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4028: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4029: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
4030: x_return_status OUT NOCOPY VARCHAR2,
4031: x_msg_count OUT NOCOPY NUMBER,

Line 4028: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4024: p_admin_flag IN VARCHAR2,
4025: p_admin_group_id IN NUMBER,
4026: p_partner_cont_party_id IN NUMBER,
4027: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4028: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4029: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
4030: x_return_status OUT NOCOPY VARCHAR2,
4031: x_msg_count OUT NOCOPY NUMBER,
4032: x_msg_data OUT NOCOPY VARCHAR2)

Line 4193: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4189: p_check_access_flag IN VARCHAR2,
4190: p_admin_flag IN VARCHAR2,
4191: p_admin_group_id IN NUMBER,
4192: p_partner_cont_party_id IN NUMBER,
4193: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4194: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4195: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4196: x_return_status OUT NOCOPY VARCHAR2,
4197: x_msg_count OUT NOCOPY NUMBER,

Line 4194: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4190: p_admin_flag IN VARCHAR2,
4191: p_admin_group_id IN NUMBER,
4192: p_partner_cont_party_id IN NUMBER,
4193: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4194: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4195: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4196: x_return_status OUT NOCOPY VARCHAR2,
4197: x_msg_count OUT NOCOPY NUMBER,
4198: x_msg_data OUT NOCOPY VARCHAR2)

Line 4362: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4358: p_check_access_flag IN VARCHAR2,
4359: p_admin_flag IN VARCHAR2,
4360: p_admin_group_id IN NUMBER,
4361: p_partner_cont_party_id IN NUMBER,
4362: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4363: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4364: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4365: x_return_status OUT NOCOPY VARCHAR2,
4366: x_msg_count OUT NOCOPY NUMBER,

Line 4363: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4359: p_admin_flag IN VARCHAR2,
4360: p_admin_group_id IN NUMBER,
4361: p_partner_cont_party_id IN NUMBER,
4362: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4363: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4364: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4365: x_return_status OUT NOCOPY VARCHAR2,
4366: x_msg_count OUT NOCOPY NUMBER,
4367: x_msg_data OUT NOCOPY VARCHAR2)

Line 4527: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4523: p_check_access_flag IN VARCHAR2,
4524: p_admin_flag IN VARCHAR2,
4525: p_admin_group_id IN NUMBER,
4526: p_partner_cont_party_id IN NUMBER,
4527: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4528: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4529: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4530: x_return_status OUT NOCOPY VARCHAR2,
4531: x_msg_count OUT NOCOPY NUMBER,

Line 4528: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4524: p_admin_flag IN VARCHAR2,
4525: p_admin_group_id IN NUMBER,
4526: p_partner_cont_party_id IN NUMBER,
4527: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4528: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4529: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
4530: x_return_status OUT NOCOPY VARCHAR2,
4531: x_msg_count OUT NOCOPY NUMBER,
4532: x_msg_data OUT NOCOPY VARCHAR2)

Line 4692: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4688: p_admin_flag IN VARCHAR2,
4689: p_admin_group_id IN NUMBER,
4690: p_identity_salesforce_id IN NUMBER,
4691: p_partner_cont_party_id IN NUMBER,
4692: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4693: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4694: x_return_status OUT NOCOPY VARCHAR2,
4695: x_msg_count OUT NOCOPY NUMBER,
4696: x_msg_data OUT NOCOPY VARCHAR2

Line 4693: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4689: p_admin_group_id IN NUMBER,
4690: p_identity_salesforce_id IN NUMBER,
4691: p_partner_cont_party_id IN NUMBER,
4692: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4693: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4694: x_return_status OUT NOCOPY VARCHAR2,
4695: x_msg_count OUT NOCOPY NUMBER,
4696: x_msg_data OUT NOCOPY VARCHAR2
4697: )

Line 4963: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

4959: p_admin_group_id IN NUMBER,
4960: p_identity_salesforce_id IN NUMBER,
4961: p_salesgroup_id IN NUMBER DEFAULT NULL,
4962: p_partner_cont_party_id IN NUMBER,
4963: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4964: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4965: x_return_status OUT NOCOPY VARCHAR2,
4966: x_msg_count OUT NOCOPY NUMBER,
4967: x_msg_data OUT NOCOPY VARCHAR2,

Line 4964: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

4960: p_identity_salesforce_id IN NUMBER,
4961: p_salesgroup_id IN NUMBER DEFAULT NULL,
4962: p_partner_cont_party_id IN NUMBER,
4963: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
4964: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
4965: x_return_status OUT NOCOPY VARCHAR2,
4966: x_msg_count OUT NOCOPY NUMBER,
4967: x_msg_data OUT NOCOPY VARCHAR2,
4968: x_lead_id OUT NOCOPY NUMBER

Line 5114: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

5110: End Copy_Opportunity;
5111:
5112:
5113: PROCEDURE Get_Access_Profiles(
5114: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
5115: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
5116: )
5117:
5118: IS

Line 5189: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

5185: END Get_Access_Profiles;
5186:
5187:
5188: FUNCTION Get_Profile(
5189: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
5190: p_profile_name IN VARCHAR2 )
5191: RETURN VARCHAR2
5192: IS
5193: l_profile_count CONSTANT NUMBER := p_profile_tbl.count;