[Home] [Help]
682:
683:
684: -- This procudure defines the columns for the Dynamic SQL.
685: PROCEDURE Define_Columns(
686: P_plsl_Rec IN CSP_Pack_Serial_Lots_PUB.plsl_Rec_Type,
687: p_cur_get_plsl IN NUMBER
688: )
689: IS
690: BEGIN
706:
707: -- This procudure gets column values by the Dynamic SQL.
708: PROCEDURE Get_Column_Values(
709: p_cur_get_plsl IN NUMBER,
710: X_plsl_Rec OUT NOCOPY CSP_Pack_Serial_Lots_PUB.plsl_Rec_Type
711: )
712: IS
713: BEGIN
714: -- Debug Message
728: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
729: END Get_Column_Values;
730:
731: PROCEDURE Gen_plsl_order_cl(
732: p_order_by_rec IN CSP_Pack_Serial_Lots_PUB.plsl_sort_rec_type,
733: x_order_by_cl OUT NOCOPY VARCHAR2,
734: x_return_status OUT NOCOPY VARCHAR2,
735: x_msg_count OUT NOCOPY NUMBER,
736: x_msg_data OUT NOCOPY VARCHAR2
771: END Gen_plsl_order_cl;
772:
773: -- This procedure bind the variables for the Dynamic SQL
774: PROCEDURE Bind(
775: P_plsl_Rec IN CSP_Pack_Serial_Lots_PUB.plsl_Rec_Type,
776: -- Hint: Add more binding variables here
777: p_cur_get_plsl IN NUMBER
778: )
779: IS
822:
823: END Gen_Select;
824:
825: PROCEDURE Gen_plsl_Where(
826: P_plsl_Rec IN CSP_Pack_Serial_Lots_PUB.plsl_Rec_Type,
827: x_plsl_where OUT NOCOPY VARCHAR2
828: )
829: IS
830: -- cursors to check if wildcard values '%' and '_' have been passed