DBA Data[Home] [Help]

APPS.CSP_PACKLIST_LINES_PVT dependencies on CSP_PACKLIST_LINES_PUB

Line 748: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,

744:
745:
746: -- This procudure defines the columns for the Dynamic SQL.
747: PROCEDURE Define_Columns(
748: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,
749: p_cur_get_PLL IN NUMBER
750: )
751: IS
752: BEGIN

Line 794: X_PLL_Rec OUT NOCOPY CSP_PACKLIST_LINES_PUB.PLL_Rec_Type

790:
791: -- This procudure gets column values by the Dynamic SQL.
792: PROCEDURE Get_Column_Values(
793: p_cur_get_PLL IN NUMBER,
794: X_PLL_Rec OUT NOCOPY CSP_PACKLIST_LINES_PUB.PLL_Rec_Type
795: )
796: IS
797: BEGIN
798: -- Debug Message

Line 837: p_order_by_rec IN CSP_PACKLIST_LINES_PUB.PLL_sort_rec_type,

833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
834: END Get_Column_Values;
835:
836: PROCEDURE Gen_PLL_order_cl(
837: p_order_by_rec IN CSP_PACKLIST_LINES_PUB.PLL_sort_rec_type,
838: x_order_by_cl OUT NOCOPY VARCHAR2,
839: x_return_status OUT NOCOPY VARCHAR2,
840: x_msg_count OUT NOCOPY NUMBER,
841: x_msg_data OUT NOCOPY VARCHAR2

Line 880: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,

876: END Gen_PLL_order_cl;
877:
878: -- This procedure bind the variables for the Dynamic SQL
879: PROCEDURE Bind(
880: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,
881: -- Hint: Add more binding variables here
882: p_cur_get_PLL IN NUMBER
883: )
884: IS

Line 952: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,

948:
949: END Gen_Select;
950:
951: PROCEDURE Gen_PLL_Where(
952: P_PLL_Rec IN CSP_PACKLIST_LINES_PUB.PLL_Rec_Type,
953: x_PLL_where OUT NOCOPY VARCHAR2
954: )
955: IS
956: -- cursors to check if wildcard values '%' and '_' have been passed