622:
623:
624: -- This procudure defines the columns for the Dynamic SQL.
625: PROCEDURE Define_Columns(
626: P_RCR_Rec IN CSP_RS_CUST_RELATION_PUB.RCR_Rec_Type,
627: p_cur_get_RCR IN NUMBER
628: )
629: IS
630: BEGIN
659:
660: -- This procudure gets column values by the Dynamic SQL.
661: PROCEDURE Get_Column_Values(
662: p_cur_get_RCR IN NUMBER,
663: X_RCR_Rec OUT NOCOPY CSP_RS_CUST_RELATION_PUB.RCR_Rec_Type
664: )
665: IS
666: BEGIN
667: -- Debug Message
693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
694: END Get_Column_Values;
695:
696: PROCEDURE Gen_RCR_order_cl(
697: p_order_by_rec IN CSP_RS_CUST_RELATION_PUB.RCR_sort_rec_type,
698: x_order_by_cl OUT NOCOPY VARCHAR2,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,
701: x_msg_data OUT NOCOPY VARCHAR2
736: END Gen_RCR_order_cl;
737:
738: -- This procedure bind the variables for the Dynamic SQL
739: PROCEDURE Bind(
740: P_RCR_Rec IN CSP_RS_CUST_RELATION_PUB.RCR_Rec_Type,
741: -- Hint: Add more binding variables here
742: p_cur_get_RCR IN NUMBER
743: )
744: IS
799:
800: END Gen_Select;
801:
802: PROCEDURE Gen_RCR_Where(
803: P_RCR_Rec IN CSP_RS_CUST_RELATION_PUB.RCR_Rec_Type,
804: x_RCR_where OUT NOCOPY VARCHAR2
805: )
806: IS
807: -- cursors to check if wildcard values '%' and '_' have been passed