APPS.CSP_PICK_SERIAL_LOTS_PVT dependencies on CSP_PICK_SERIAL_LOTS_PUB

Line 685: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,

681:
682:
683: -- This procudure defines the columns for the Dynamic SQL.
684: PROCEDURE Define_Columns(
685: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
686: p_cur_get_psl IN NUMBER
687: )
688: IS
689: BEGIN

Line 709: X_psl_Rec OUT NOCOPY csp_pick_serial_lots_PUB.psl_Rec_Type

705:
706: -- This procudure gets column values by the Dynamic SQL.
707: PROCEDURE Get_Column_Values(
708: p_cur_get_psl IN NUMBER,
709: X_psl_Rec OUT NOCOPY csp_pick_serial_lots_PUB.psl_Rec_Type
710: )
711: IS
712: BEGIN
713: -- Debug Message

Line 731: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,

727: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'csp', 'Private API: Get Column Values Ends');
728: END Get_Column_Values;
729:
730: PROCEDURE Gen_psl_order_cl(
731: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,
732: x_order_by_cl OUT NOCOPY VARCHAR2,
733: x_return_status OUT NOCOPY VARCHAR2,
734: x_msg_count OUT NOCOPY NUMBER,
735: x_msg_data OUT NOCOPY VARCHAR2

Line 774: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,

770: END Gen_psl_order_cl;
771:
772: -- This procedure bind the variables for the Dynamic SQL
773: PROCEDURE Bind(
774: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
775: -- Hint: Add more binding variables here
776: p_cur_get_psl IN NUMBER
777: )
778: IS

Line 825: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,

821:
822: END Gen_Select;
823:
824: PROCEDURE Gen_psl_Where(
825: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
826: x_psl_where OUT NOCOPY VARCHAR2
827: )
828: IS
829: -- cursors to check if wildcard values '%' and '_' have been passed