DBA Data[Home] [Help]

APPS.CSP_RESOURCE_PVT dependencies on CSP_RESOURCE_PUB

Line 752: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,

748:
749:
750: -- This procudure defines the columns for the Dynamic SQL.
751: PROCEDURE Define_Columns(
752: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,
753: p_cur_get_CSP IN NUMBER
754: )
755: IS
756: BEGIN

Line 778: X_CSP_Rec OUT NOCOPY CSP_RESOURCE_PUB.CSP_Rec_Type

774:
775: -- This procudure gets column values by the Dynamic SQL.
776: PROCEDURE Get_Column_Values(
777: p_cur_get_CSP IN NUMBER,
778: X_CSP_Rec OUT NOCOPY CSP_RESOURCE_PUB.CSP_Rec_Type
779: )
780: IS
781: BEGIN
782: -- Debug Message

Line 801: p_order_by_rec IN CSP_RESOURCE_PUB.CSP_sort_rec_type,

797: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
798: END Get_Column_Values;
799:
800: PROCEDURE Gen_CSP_order_cl(
801: p_order_by_rec IN CSP_RESOURCE_PUB.CSP_sort_rec_type,
802: x_order_by_cl OUT NOCOPY VARCHAR2,
803: x_return_status OUT NOCOPY VARCHAR2,
804: x_msg_count OUT NOCOPY NUMBER,
805: x_msg_data OUT NOCOPY VARCHAR2

Line 844: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,

840: END Gen_CSP_order_cl;
841:
842: -- This procedure bind the variables for the Dynamic SQL
843: PROCEDURE Bind(
844: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,
845: -- Hint: Add more binding variables here
846: p_cur_get_CSP IN NUMBER
847: )
848: IS

Line 897: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,

893:
894: END Gen_Select;
895:
896: PROCEDURE Gen_CSP_Where(
897: P_CSP_Rec IN CSP_RESOURCE_PUB.CSP_Rec_Type,
898: x_CSP_where OUT NOCOPY VARCHAR2
899: )
900: IS
901: -- cursors to check if wildcard values '%' and '_' have been passed