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 748: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the

744: * @param p_salesgroup_id Sales group identifier of the logged in user.
745: * @param p_partner_cont_party_id The party identifier of the partner contact
746: * if the logged in user is a partner contact.
747: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
748: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
749: * package AS_UTILITY_PUB.
750: * @param x_return_status The return status of the API stating Success, Failure or
751: * Unexpected Error.
752: * @param x_msg_count Number of error messages recorded during processing.

Line 749: * package AS_UTILITY_PUB.

745: * @param p_partner_cont_party_id The party identifier of the partner contact
746: * if the logged in user is a partner contact.
747: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
748: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
749: * package AS_UTILITY_PUB.
750: * @param x_return_status The return status of the API stating Success, Failure or
751: * Unexpected Error.
752: * @param x_msg_count Number of error messages recorded during processing.
753: * @param x_msg_data Contains the text of the message if msg_count = 1.

Line 771: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

767: p_admin_group_id IN NUMBER,
768: p_identity_salesforce_id IN NUMBER,
769: p_salesgroup_id IN NUMBER DEFAULT NULL,
770: p_partner_cont_party_id IN NUMBER,
771: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
772: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
773: x_return_status OUT NOCOPY VARCHAR2,
774: x_msg_count OUT NOCOPY NUMBER,
775: x_msg_data OUT NOCOPY VARCHAR2,

Line 772: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

768: p_identity_salesforce_id IN NUMBER,
769: p_salesgroup_id IN NUMBER DEFAULT NULL,
770: p_partner_cont_party_id IN NUMBER,
771: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
772: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
773: x_return_status OUT NOCOPY VARCHAR2,
774: x_msg_count OUT NOCOPY NUMBER,
775: x_msg_data OUT NOCOPY VARCHAR2,
776: x_lead_id OUT NOCOPY NUMBER

Line 823: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the

819: * @param p_identity_salesforce_id Sales force identifier of the logged in user.
820: * @param p_partner_cont_party_id The party identifier of the partner contact
821: * if the logged in user is a partner contact.
822: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
823: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
824: * package AS_UTILITY_PUB.
825: * @param x_return_status The return status of the API stating Success, Failure or
826: * Unexpected Error.
827: * @param x_msg_count Number of error messages recorded during processing.

Line 824: * package AS_UTILITY_PUB.

820: * @param p_partner_cont_party_id The party identifier of the partner contact
821: * if the logged in user is a partner contact.
822: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
823: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
824: * package AS_UTILITY_PUB.
825: * @param x_return_status The return status of the API stating Success, Failure or
826: * Unexpected Error.
827: * @param x_msg_count Number of error messages recorded during processing.
828: * @param x_msg_data Contains the text of the message if msg_count = 1.

Line 845: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

841: p_admin_flag IN VARCHAR2,
842: p_admin_group_id IN NUMBER,
843: p_identity_salesforce_id IN NUMBER,
844: p_partner_cont_party_id IN NUMBER,
845: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
846: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
847: x_return_status OUT NOCOPY VARCHAR2,
848: x_msg_count OUT NOCOPY NUMBER,
849: x_msg_data OUT NOCOPY VARCHAR2,

Line 846: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

842: p_admin_group_id IN NUMBER,
843: p_identity_salesforce_id IN NUMBER,
844: p_partner_cont_party_id IN NUMBER,
845: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
846: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
847: x_return_status OUT NOCOPY VARCHAR2,
848: x_msg_count OUT NOCOPY NUMBER,
849: x_msg_data OUT NOCOPY VARCHAR2,
850: x_lead_id OUT NOCOPY NUMBER);

Line 871: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

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

Line 872: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

868: p_admin_group_id IN NUMBER,
869: p_identity_salesforce_id IN NUMBER,
870: p_partner_cont_party_id IN NUMBER,
871: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
872: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
873: x_return_status OUT NOCOPY VARCHAR2,
874: x_msg_count OUT NOCOPY NUMBER,
875: x_msg_data OUT NOCOPY VARCHAR2,
876: x_lead_id OUT NOCOPY NUMBER);

Line 925: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the

921: * @param p_salesgroup_id Sales group identifier of the logged in user.
922: * @param p_partner_cont_party_id The party identifier of the partner contact
923: * if the logged in user is a partner contact.
924: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
925: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
926: * package AS_UTILITY_PUB.
927: * @param x_line_out_tbl The identifiers of the created product lines and
928: * their statuses. This PL/SQL table is of record type
929: * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.

Line 926: * package AS_UTILITY_PUB.

922: * @param p_partner_cont_party_id The party identifier of the partner contact
923: * if the logged in user is a partner contact.
924: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
925: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
926: * package AS_UTILITY_PUB.
927: * @param x_line_out_tbl The identifiers of the created product lines and
928: * their statuses. This PL/SQL table is of record type
929: * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.
930: * @param x_return_status The return status of the API stating Success, Failure or

Line 951: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

947: p_admin_group_id IN NUMBER,
948: p_identity_salesforce_id IN NUMBER,
949: p_salesgroup_id IN NUMBER DEFAULT NULL,
950: p_partner_cont_party_id IN NUMBER,
951: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
952: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
953: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
954: x_return_status OUT NOCOPY VARCHAR2,
955: x_msg_count OUT NOCOPY NUMBER,

Line 952: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

948: p_identity_salesforce_id IN NUMBER,
949: p_salesgroup_id IN NUMBER DEFAULT NULL,
950: p_partner_cont_party_id IN NUMBER,
951: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
952: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
953: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
954: x_return_status OUT NOCOPY VARCHAR2,
955: x_msg_count OUT NOCOPY NUMBER,
956: x_msg_data OUT NOCOPY VARCHAR2);

Line 1006: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the

1002: * the user has an administrator role.
1003: * @param p_partner_cont_party_id The party identifier of the partner contact
1004: * if the logged in user is a partner contact.
1005: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
1006: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
1007: * package AS_UTILITY_PUB.
1008: * @param x_line_out_tbl The identifiers of the updated product lines and
1009: * their statuses. This PL/SQL table is of record type
1010: * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.

Line 1007: * package AS_UTILITY_PUB.

1003: * @param p_partner_cont_party_id The party identifier of the partner contact
1004: * if the logged in user is a partner contact.
1005: * @param p_profile_tbl A PL/SQL table containing profile values. This PL/SQL
1006: * table is of record type AS_UTILITY_PUB.profile_rec_type defined in the
1007: * package AS_UTILITY_PUB.
1008: * @param x_line_out_tbl The identifiers of the updated product lines and
1009: * their statuses. This PL/SQL table is of record type
1010: * AS_OPPORTUNITY_PUB.line_out_rec_type defined in the package AS_OPPORTUNITY_PUB.
1011: * @param x_return_status The return status of the API stating Success, Failure or

Line 1031: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1027: p_check_access_flag IN VARCHAR2,
1028: p_admin_flag IN VARCHAR2,
1029: p_admin_group_id IN NUMBER,
1030: p_partner_cont_party_id IN NUMBER,
1031: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1032: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1033: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1034: x_return_status OUT NOCOPY VARCHAR2,
1035: x_msg_count OUT NOCOPY NUMBER,

Line 1032: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1028: p_admin_flag IN VARCHAR2,
1029: p_admin_group_id IN NUMBER,
1030: p_partner_cont_party_id IN NUMBER,
1031: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1032: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1033: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1034: x_return_status OUT NOCOPY VARCHAR2,
1035: x_msg_count OUT NOCOPY NUMBER,
1036: x_msg_data OUT NOCOPY VARCHAR2);

Line 1060: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1056: p_check_access_flag IN VARCHAR2,
1057: p_admin_flag IN VARCHAR2,
1058: p_admin_group_id IN NUMBER,
1059: p_partner_cont_party_id IN NUMBER,
1060: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1061: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1062: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1063: x_return_status OUT NOCOPY VARCHAR2,
1064: x_msg_count OUT NOCOPY NUMBER,

Line 1061: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1057: p_admin_flag IN VARCHAR2,
1058: p_admin_group_id IN NUMBER,
1059: p_partner_cont_party_id IN NUMBER,
1060: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1061: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1062: x_line_out_tbl OUT NOCOPY Line_Out_Tbl_Type,
1063: x_return_status OUT NOCOPY VARCHAR2,
1064: x_msg_count OUT NOCOPY NUMBER,
1065: x_msg_data OUT NOCOPY VARCHAR2);

Line 1091: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1087: p_check_access_flag IN VARCHAR2,
1088: p_admin_flag IN VARCHAR2,
1089: p_admin_group_id IN NUMBER,
1090: p_partner_cont_party_id IN NUMBER,
1091: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1092: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1093: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1094: x_return_status OUT NOCOPY VARCHAR2,
1095: x_msg_count OUT NOCOPY NUMBER,

Line 1092: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1088: p_admin_flag IN VARCHAR2,
1089: p_admin_group_id IN NUMBER,
1090: p_partner_cont_party_id IN NUMBER,
1091: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1092: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1093: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1094: x_return_status OUT NOCOPY VARCHAR2,
1095: x_msg_count OUT NOCOPY NUMBER,
1096: x_msg_data OUT NOCOPY VARCHAR2);

Line 1121: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1117: p_check_access_flag IN VARCHAR2,
1118: p_admin_flag IN VARCHAR2,
1119: p_admin_group_id IN NUMBER,
1120: p_partner_cont_party_id IN NUMBER,
1121: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1122: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1123: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,

Line 1122: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1118: p_admin_flag IN VARCHAR2,
1119: p_admin_group_id IN NUMBER,
1120: p_partner_cont_party_id IN NUMBER,
1121: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1122: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1123: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1124: x_return_status OUT NOCOPY VARCHAR2,
1125: x_msg_count OUT NOCOPY NUMBER,
1126: x_msg_data OUT NOCOPY VARCHAR2);

Line 1156: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1152: p_check_access_flag IN VARCHAR2,
1153: p_admin_flag IN VARCHAR2,
1154: p_admin_group_id IN NUMBER,
1155: p_partner_cont_party_id IN NUMBER,
1156: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1157: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1158: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1159: x_return_status OUT NOCOPY VARCHAR2,
1160: x_msg_count OUT NOCOPY NUMBER,

Line 1157: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1153: p_admin_flag IN VARCHAR2,
1154: p_admin_group_id IN NUMBER,
1155: p_partner_cont_party_id IN NUMBER,
1156: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1157: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1158: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1159: x_return_status OUT NOCOPY VARCHAR2,
1160: x_msg_count OUT NOCOPY NUMBER,
1161: x_msg_data OUT NOCOPY VARCHAR2);

Line 1179: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1175: p_check_access_flag IN VARCHAR2,
1176: p_admin_flag IN VARCHAR2,
1177: p_admin_group_id IN NUMBER,
1178: p_partner_cont_party_id IN NUMBER,
1179: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1180: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1181: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,

Line 1180: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1176: p_admin_flag IN VARCHAR2,
1177: p_admin_group_id IN NUMBER,
1178: p_partner_cont_party_id IN NUMBER,
1179: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1180: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1181: x_sales_credit_out_tbl OUT NOCOPY Sales_Credit_Out_Tbl_Type,
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,
1184: x_msg_data OUT NOCOPY VARCHAR2);

Line 1205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1201: p_check_access_flag IN VARCHAR2,
1202: p_admin_flag IN VARCHAR2,
1203: p_admin_group_id IN NUMBER,
1204: p_partner_cont_party_id IN NUMBER,
1205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1207: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,

Line 1206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1202: p_admin_flag IN VARCHAR2,
1203: p_admin_group_id IN NUMBER,
1204: p_partner_cont_party_id IN NUMBER,
1205: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1206: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1207: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,
1210: x_msg_data OUT NOCOPY VARCHAR2);

Line 1232: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1228: p_check_access_flag IN VARCHAR2,
1229: p_admin_flag IN VARCHAR2,
1230: p_admin_group_id IN NUMBER,
1231: p_partner_cont_party_id IN NUMBER,
1232: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1233: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1234: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,

Line 1233: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1229: p_admin_flag IN VARCHAR2,
1230: p_admin_group_id IN NUMBER,
1231: p_partner_cont_party_id IN NUMBER,
1232: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1233: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1234: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1235: x_return_status OUT NOCOPY VARCHAR2,
1236: x_msg_count OUT NOCOPY NUMBER,
1237: x_msg_data OUT NOCOPY VARCHAR2);

Line 1254: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1250: p_check_access_flag IN VARCHAR2,
1251: p_admin_flag IN VARCHAR2,
1252: p_admin_group_id IN NUMBER,
1253: p_partner_cont_party_id IN NUMBER,
1254: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1255: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1256: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1257: x_return_status OUT NOCOPY VARCHAR2,
1258: x_msg_count OUT NOCOPY NUMBER,

Line 1255: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1251: p_admin_flag IN VARCHAR2,
1252: p_admin_group_id IN NUMBER,
1253: p_partner_cont_party_id IN NUMBER,
1254: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1255: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1256: x_obstacle_out_tbl OUT NOCOPY Obstacle_Out_Tbl_Type,
1257: x_return_status OUT NOCOPY VARCHAR2,
1258: x_msg_count OUT NOCOPY NUMBER,
1259: x_msg_data OUT NOCOPY VARCHAR2);

Line 1281: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1277: p_check_access_flag IN VARCHAR2,
1278: p_admin_flag IN VARCHAR2,
1279: p_admin_group_id IN NUMBER,
1280: p_partner_cont_party_id IN NUMBER,
1281: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1282: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1283: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1284: x_return_status OUT NOCOPY VARCHAR2,
1285: x_msg_count OUT NOCOPY NUMBER,

Line 1282: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1278: p_admin_flag IN VARCHAR2,
1279: p_admin_group_id IN NUMBER,
1280: p_partner_cont_party_id IN NUMBER,
1281: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1282: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1283: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1284: x_return_status OUT NOCOPY VARCHAR2,
1285: x_msg_count OUT NOCOPY NUMBER,
1286: x_msg_data OUT NOCOPY VARCHAR2);

Line 1303: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1299: p_check_access_flag IN VARCHAR2,
1300: p_admin_flag IN VARCHAR2,
1301: p_admin_group_id IN NUMBER,
1302: p_partner_cont_party_id IN NUMBER,
1303: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1304: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1305: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1306: x_return_status OUT NOCOPY VARCHAR2,
1307: x_msg_count OUT NOCOPY NUMBER,

Line 1304: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1300: p_admin_flag IN VARCHAR2,
1301: p_admin_group_id IN NUMBER,
1302: p_partner_cont_party_id IN NUMBER,
1303: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1304: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1305: x_order_out_tbl OUT NOCOPY Order_Out_Tbl_Type,
1306: x_return_status OUT NOCOPY VARCHAR2,
1307: x_msg_count OUT NOCOPY NUMBER,
1308: x_msg_data OUT NOCOPY VARCHAR2);

Line 1329: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1325: p_check_access_flag IN VARCHAR2,
1326: p_admin_flag IN VARCHAR2,
1327: p_admin_group_id IN NUMBER,
1328: p_partner_cont_party_id IN NUMBER,
1329: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1330: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1331: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_msg_count OUT NOCOPY NUMBER,

Line 1330: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1326: p_admin_flag IN VARCHAR2,
1327: p_admin_group_id IN NUMBER,
1328: p_partner_cont_party_id IN NUMBER,
1329: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1330: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1331: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1332: x_return_status OUT NOCOPY VARCHAR2,
1333: x_msg_count OUT NOCOPY NUMBER,
1334: x_msg_data OUT NOCOPY VARCHAR2);

Line 1356: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1352: p_check_access_flag IN VARCHAR2,
1353: p_admin_flag IN VARCHAR2,
1354: p_admin_group_id IN NUMBER,
1355: p_partner_cont_party_id IN NUMBER,
1356: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1357: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1358: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1359: x_return_status OUT NOCOPY VARCHAR2,
1360: x_msg_count OUT NOCOPY NUMBER,

Line 1357: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1353: p_admin_flag IN VARCHAR2,
1354: p_admin_group_id IN NUMBER,
1355: p_partner_cont_party_id IN NUMBER,
1356: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1357: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1358: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1359: x_return_status OUT NOCOPY VARCHAR2,
1360: x_msg_count OUT NOCOPY NUMBER,
1361: x_msg_data OUT NOCOPY VARCHAR2);

Line 1375: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1371: p_check_access_flag IN VARCHAR2,
1372: p_admin_flag IN VARCHAR2,
1373: p_admin_group_id IN NUMBER,
1374: p_partner_cont_party_id IN NUMBER,
1375: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1376: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1377: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_msg_count OUT NOCOPY NUMBER,

Line 1376: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1372: p_admin_flag IN VARCHAR2,
1373: p_admin_group_id IN NUMBER,
1374: p_partner_cont_party_id IN NUMBER,
1375: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1376: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1377: x_competitor_out_tbl OUT NOCOPY Competitor_Out_Tbl_Type,
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: x_msg_count OUT NOCOPY NUMBER,
1380: x_msg_data OUT NOCOPY VARCHAR2);

Line 1402: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1398: p_check_access_flag IN VARCHAR2,
1399: p_admin_flag IN VARCHAR2,
1400: p_admin_group_id IN NUMBER,
1401: p_partner_cont_party_id IN NUMBER,
1402: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1403: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1404: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,

Line 1403: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1399: p_admin_flag IN VARCHAR2,
1400: p_admin_group_id IN NUMBER,
1401: p_partner_cont_party_id IN NUMBER,
1402: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1403: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1404: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1405: x_return_status OUT NOCOPY VARCHAR2,
1406: x_msg_count OUT NOCOPY NUMBER,
1407: x_msg_data OUT NOCOPY VARCHAR2);

Line 1430: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1426: p_check_access_flag IN VARCHAR2,
1427: p_admin_flag IN VARCHAR2,
1428: p_admin_group_id IN NUMBER,
1429: p_partner_cont_party_id IN NUMBER,
1430: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1431: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1432: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1433: x_return_status OUT NOCOPY VARCHAR2,
1434: x_msg_count OUT NOCOPY NUMBER,

Line 1431: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1427: p_admin_flag IN VARCHAR2,
1428: p_admin_group_id IN NUMBER,
1429: p_partner_cont_party_id IN NUMBER,
1430: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1431: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1432: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1433: x_return_status OUT NOCOPY VARCHAR2,
1434: x_msg_count OUT NOCOPY NUMBER,
1435: x_msg_data OUT NOCOPY VARCHAR2);

Line 1449: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1445: p_check_access_flag IN VARCHAR2,
1446: p_admin_flag IN VARCHAR2,
1447: p_admin_group_id IN NUMBER,
1448: p_partner_cont_party_id IN NUMBER,
1449: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1450: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1451: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,

Line 1450: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1446: p_admin_flag IN VARCHAR2,
1447: p_admin_group_id IN NUMBER,
1448: p_partner_cont_party_id IN NUMBER,
1449: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1450: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1451: x_competitor_prod_out_tbl OUT NOCOPY Competitor_Prod_Out_Tbl_Type,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2);

Line 1476: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1472: p_check_access_flag IN VARCHAR2,
1473: p_admin_flag IN VARCHAR2,
1474: p_admin_group_id IN NUMBER,
1475: p_partner_cont_party_id IN NUMBER,
1476: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1477: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1478: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1479: x_return_status OUT NOCOPY VARCHAR2,
1480: x_msg_count OUT NOCOPY NUMBER,

Line 1477: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1473: p_admin_flag IN VARCHAR2,
1474: p_admin_group_id IN NUMBER,
1475: p_partner_cont_party_id IN NUMBER,
1476: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1477: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1478: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1479: x_return_status OUT NOCOPY VARCHAR2,
1480: x_msg_count OUT NOCOPY NUMBER,
1481: x_msg_data OUT NOCOPY VARCHAR2);

Line 1504: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1500: p_check_access_flag IN VARCHAR2,
1501: p_admin_flag IN VARCHAR2,
1502: p_admin_group_id IN NUMBER,
1503: p_partner_cont_party_id IN NUMBER,
1504: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1505: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1506: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,

Line 1505: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1501: p_admin_flag IN VARCHAR2,
1502: p_admin_group_id IN NUMBER,
1503: p_partner_cont_party_id IN NUMBER,
1504: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1505: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1506: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1507: x_return_status OUT NOCOPY VARCHAR2,
1508: x_msg_count OUT NOCOPY NUMBER,
1509: x_msg_data OUT NOCOPY VARCHAR2);

Line 1523: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1519: p_check_access_flag IN VARCHAR2,
1520: p_admin_flag IN VARCHAR2,
1521: p_admin_group_id IN NUMBER,
1522: p_partner_cont_party_id IN NUMBER,
1523: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1524: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1525: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1526: x_return_status OUT NOCOPY VARCHAR2,
1527: x_msg_count OUT NOCOPY NUMBER,

Line 1524: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1520: p_admin_flag IN VARCHAR2,
1521: p_admin_group_id IN NUMBER,
1522: p_partner_cont_party_id IN NUMBER,
1523: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1524: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1525: x_decision_factor_out_tbl OUT NOCOPY Decision_Factor_Out_Tbl_Type,
1526: x_return_status OUT NOCOPY VARCHAR2,
1527: x_msg_count OUT NOCOPY NUMBER,
1528: x_msg_data OUT NOCOPY VARCHAR2);

Line 1554: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1550: p_check_access_flag IN VARCHAR2,
1551: p_admin_flag IN VARCHAR2,
1552: p_admin_group_id IN NUMBER,
1553: p_partner_cont_party_id IN NUMBER,
1554: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1555: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1556: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1557: x_return_status OUT NOCOPY VARCHAR2,
1558: x_msg_count OUT NOCOPY NUMBER,

Line 1555: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1551: p_admin_flag IN VARCHAR2,
1552: p_admin_group_id IN NUMBER,
1553: p_partner_cont_party_id IN NUMBER,
1554: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1555: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1556: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1557: x_return_status OUT NOCOPY VARCHAR2,
1558: x_msg_count OUT NOCOPY NUMBER,
1559: x_msg_data OUT NOCOPY VARCHAR2);

Line 1584: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1580: p_check_access_flag IN VARCHAR2,
1581: p_admin_flag IN VARCHAR2,
1582: p_admin_group_id IN NUMBER,
1583: p_partner_cont_party_id IN NUMBER,
1584: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1585: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1586: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,

Line 1585: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1581: p_admin_flag IN VARCHAR2,
1582: p_admin_group_id IN NUMBER,
1583: p_partner_cont_party_id IN NUMBER,
1584: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1585: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1586: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2);

Line 1606: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1602: p_check_access_flag IN VARCHAR2,
1603: p_admin_flag IN VARCHAR2,
1604: p_admin_group_id IN NUMBER,
1605: p_partner_cont_party_id IN NUMBER,
1606: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1607: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1608: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1609: x_return_status OUT NOCOPY VARCHAR2,
1610: x_msg_count OUT NOCOPY NUMBER,

Line 1607: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1603: p_admin_flag IN VARCHAR2,
1604: p_admin_group_id IN NUMBER,
1605: p_partner_cont_party_id IN NUMBER,
1606: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1607: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1608: x_contact_out_tbl OUT NOCOPY Contact_Out_Tbl_Type,
1609: x_return_status OUT NOCOPY VARCHAR2,
1610: x_msg_count OUT NOCOPY NUMBER,
1611: x_msg_data OUT NOCOPY VARCHAR2);

Line 1629: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1625: p_admin_flag IN VARCHAR2,
1626: p_admin_group_id IN NUMBER,
1627: p_identity_salesforce_id IN NUMBER,
1628: p_partner_cont_party_id IN NUMBER,
1629: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1630: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1631: x_return_status OUT NOCOPY VARCHAR2,
1632: x_msg_count OUT NOCOPY NUMBER,
1633: x_msg_data OUT NOCOPY VARCHAR2

Line 1630: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1626: p_admin_group_id IN NUMBER,
1627: p_identity_salesforce_id IN NUMBER,
1628: p_partner_cont_party_id IN NUMBER,
1629: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1630: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1631: x_return_status OUT NOCOPY VARCHAR2,
1632: x_msg_count OUT NOCOPY NUMBER,
1633: x_msg_data OUT NOCOPY VARCHAR2
1634: );

Line 1691: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type

1687: p_admin_group_id IN NUMBER,
1688: p_identity_salesforce_id IN NUMBER,
1689: p_salesgroup_id IN NUMBER DEFAULT NULL,
1690: p_partner_cont_party_id IN NUMBER,
1691: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1692: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_count OUT NOCOPY NUMBER,
1695: x_msg_data OUT NOCOPY VARCHAR2,

Line 1692: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,

1688: p_identity_salesforce_id IN NUMBER,
1689: p_salesgroup_id IN NUMBER DEFAULT NULL,
1690: p_partner_cont_party_id IN NUMBER,
1691: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
1692: DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_count OUT NOCOPY NUMBER,
1695: x_msg_data OUT NOCOPY VARCHAR2,
1696: x_lead_id OUT NOCOPY NUMBER

Line 1712: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

1708: -- APIs.
1709: --
1710:
1711: PROCEDURE Get_Access_Profiles(
1712: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
1713: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
1714: );
1715:
1716: --

Line 1728: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,

1724: -- then the function return NULL
1725: --
1726:
1727: FUNCTION Get_Profile(
1728: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
1729: p_profile_name IN VARCHAR2 )
1730: RETURN VARCHAR2;
1731:
1732: