DBA Data[Home] [Help]

APPS.CSP_ORDERHEADERS_PVT dependencies on CSP_ORDERHEADERS_PUB

Line 762: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,

758:
759:
760: -- This procudure defines the columns for the Dynamic SQL.
761: PROCEDURE Define_Columns(
762: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,
763: p_cur_get_MOH IN NUMBER
764: )
765: IS
766: BEGIN

Line 795: X_MOH_Rec OUT NOCOPY CSP_ORDERHEADERS_PUB.MOH_Rec_Type

791:
792: -- This procudure gets column values by the Dynamic SQL.
793: PROCEDURE Get_Column_Values(
794: p_cur_get_MOH IN NUMBER,
795: X_MOH_Rec OUT NOCOPY CSP_ORDERHEADERS_PUB.MOH_Rec_Type
796: )
797: IS
798: BEGIN
799: -- Debug Message

Line 825: p_order_by_rec IN CSP_ORDERHEADERS_PUB.MOH_sort_rec_type,

821: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
822: END Get_Column_Values;
823:
824: PROCEDURE Gen_MOH_order_cl(
825: p_order_by_rec IN CSP_ORDERHEADERS_PUB.MOH_sort_rec_type,
826: x_order_by_cl OUT NOCOPY VARCHAR2,
827: x_return_status OUT NOCOPY VARCHAR2,
828: x_msg_count OUT NOCOPY NUMBER,
829: x_msg_data OUT NOCOPY VARCHAR2

Line 868: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,

864: END Gen_MOH_order_cl;
865:
866: -- This procedure bind the variables for the Dynamic SQL
867: PROCEDURE Bind(
868: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,
869: -- Hint: Add more binding variables here
870: p_cur_get_MOH IN NUMBER
871: )
872: IS

Line 926: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,

922:
923: END Gen_Select;
924:
925: PROCEDURE Gen_MOH_Where(
926: P_MOH_Rec IN CSP_ORDERHEADERS_PUB.MOH_Rec_Type,
927: x_MOH_where OUT NOCOPY VARCHAR2
928: )
929: IS
930: -- cursors to check if wildcard values '%' and '_' have been passed