DBA Data[Home] [Help]

APPS.AST_RS_CAMP_PVT dependencies on AS_SALES_MEMBER_PUB

Line 43: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

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

Line 273: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

269:
270: l_api_name CONSTANT VARCHAR2(30) := 'Update_rs_camp';
271: l_api_version_number CONSTANT NUMBER := 1.0;
272: -- Local Variables
273: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
274: l_ref_rs_camp_rec AST_rs_camp_PVT.rs_camp_Rec_Type;
275: l_tar_rs_camp_rec AST_rs_camp_PVT.rs_camp_Rec_Type := P_rs_camp_Rec;
276: l_rowid ROWID;
277: BEGIN

Line 524: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

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

Line 966: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;

962: l_api_name CONSTANT VARCHAR2(30) := 'Get_rs_camp';
963: l_api_version_number CONSTANT NUMBER := 1.0;
964:
965: -- Local identity variables
966: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
967:
968: -- Local record counters
969: l_returned_rec_count NUMBER := 0; -- number of records returned in x_X_rs_camp_Rec
970: l_next_record_ptr NUMBER := 1;