APPS.AST_RS_CAMP_PVT dependencies on AST_RS_CAMP_PUB

Line 672: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,

668:
669:
670: -- This procudure defines the columns for the Dynamic SQL.
671: PROCEDURE Define_Columns(
672: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
673: p_cur_get_rs_camp IN NUMBER
674: )
675: IS
676: BEGIN

Line 698: X_rs_camp_Rec OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Rec_Type

694:
695: -- This procudure gets column values by the Dynamic SQL.
696: PROCEDURE Get_Column_Values(
697: p_cur_get_rs_camp IN NUMBER,
698: X_rs_camp_Rec OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Rec_Type
699: )
700: IS
701: BEGIN
702: -- Debug Message

Line 721: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,

717:
718: END Get_Column_Values;
719:
720: PROCEDURE Gen_rs_camp_order_cl(
721: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
722: x_order_by_cl OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
723: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
724: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
725: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 767: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,

763: END Gen_rs_camp_order_cl;
764:
765: -- This procedure bind the variables for the Dynamic SQL
766: PROCEDURE Bind(
767: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
768: -- Hint: Add more binding variables here
769: p_cur_get_rs_camp IN NUMBER
770: )
771: IS

Line 823: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,

819:
820: END Gen_Select;
821:
822: PROCEDURE Gen_rs_camp_Where(
823: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
824: x_rs_camp_where OUT NOCOPY /* file.sql.39 change */ VARCHAR2
825: )
826: IS
827: -- cursors to check if wildcard values '%' and '_' have been passed

Line 943: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,

939: P_Api_Version_Number IN NUMBER,
940: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
941: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
942: P_identity_salesforce_id IN NUMBER := NULL,
943: P_rs_camp_Rec IN AST_rs_camp_PUB.rs_camp_Rec_Type,
944: -- Hint: Add list of bind variables here
945: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
946: p_start_rec_prt IN NUMBER := 1,
947: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

Line 949: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,

945: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
946: p_start_rec_prt IN NUMBER := 1,
947: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
948: -- Hint: user defined record type
949: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
950: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
951: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
952: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
953: X_rs_camp_Tbl OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Tbl_Type,

Line 953: X_rs_camp_Tbl OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Tbl_Type,

949: p_order_by_rec IN AST_rs_camp_PUB.rs_camp_sort_rec_type,
950: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
951: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
952: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
953: X_rs_camp_Tbl OUT NOCOPY /* file.sql.39 change */ AST_rs_camp_PUB.rs_camp_Tbl_Type,
954: x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
955: x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER,
956: x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
957: -- other optional parameters

Line 993: l_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;

989: l_flex_where VARCHAR2(2000) := NULL;
990: l_counter NUMBER;
991:
992: -- Local scratch record
993: l_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
994: l_crit_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT GET_rs_camp_PVT;

Line 994: l_crit_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;

990: l_counter NUMBER;
991:
992: -- Local scratch record
993: l_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
994: l_crit_rs_camp_rec AST_rs_camp_PUB.rs_camp_Rec_Type;
995: BEGIN
996: -- Standard Start of API savepoint
997: SAVEPOINT GET_rs_camp_PVT;
998: