DBA Data[Home] [Help]

APPS.AST_GRP_CAMP_PVT dependencies on AS_SALES_MEMBER_PUB

Line 44: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

40: IS
41: l_api_name CONSTANT VARCHAR2(30) := 'Create_grp_camp';
42: l_api_version_number CONSTANT NUMBER := 1.0;
43: l_return_status_full VARCHAR2(1);
44: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
45: BEGIN
46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_grp_camp_PVT;
48:

Line 272: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

268: For Update NOWAIT;
269: l_api_name CONSTANT VARCHAR2(30) := 'Update_grp_camp';
270: l_api_version_number CONSTANT NUMBER := 1.0;
271: -- Local Variables
272: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
273: l_ref_grp_camp_rec ast_grp_camp_PVT.grp_camp_Rec_Type;
274: l_tar_grp_camp_rec ast_grp_camp_PVT.grp_camp_Rec_Type := P_grp_camp_Rec;
275: l_rowid ROWID;
276: BEGIN

Line 522: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

518:
519: IS
520: l_api_name CONSTANT VARCHAR2(30) := 'Delete_grp_camp';
521: l_api_version_number CONSTANT NUMBER := 1.0;
522: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
523: BEGIN
524: -- Standard Start of API savepoint
525: SAVEPOINT DELETE_grp_camp_PVT;
526:

Line 939: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

935: l_api_name CONSTANT VARCHAR2(30) := 'Get_grp_camp';
936: l_api_version_number CONSTANT NUMBER := 1.0;
937:
938: -- Local identity variables
939: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
940:
941: -- Local record counters
942: l_returned_rec_count NUMBER := 0; -- number of records returned in x_X_grp_camp_Rec
943: l_next_record_ptr NUMBER := 1;