DBA Data[Home] [Help]

APPS.CSP_PACKLIST_HEADERS_PVT dependencies on CSP_PACKLIST_HEADERS_PUB

Line 754: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,

750:
751:
752: -- This procudure defines the columns for the Dynamic SQL.
753: PROCEDURE Define_Columns(
754: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,
755: p_cur_get_PLH IN NUMBER
756: )
757: IS
758: BEGIN

Line 802: X_PLH_Rec OUT NOCOPY CSP_Packlist_Headers_PUB.PLH_Rec_Type

798:
799: -- This procudure gets column values by the Dynamic SQL.
800: PROCEDURE Get_Column_Values(
801: p_cur_get_PLH IN NUMBER,
802: X_PLH_Rec OUT NOCOPY CSP_Packlist_Headers_PUB.PLH_Rec_Type
803: )
804: IS
805: BEGIN
806: -- Debug Message

Line 848: p_order_by_rec IN CSP_Packlist_Headers_PUB.PLH_sort_rec_type,

844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
845: END Get_Column_Values;
846:
847: PROCEDURE Gen_PLH_order_cl(
848: p_order_by_rec IN CSP_Packlist_Headers_PUB.PLH_sort_rec_type,
849: x_order_by_cl OUT NOCOPY VARCHAR2,
850: x_return_status OUT NOCOPY VARCHAR2,
851: x_msg_count OUT NOCOPY NUMBER,
852: x_msg_data OUT NOCOPY VARCHAR2

Line 891: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,

887: END Gen_PLH_order_cl;
888:
889: -- This procedure bind the variables for the Dynamic SQL
890: PROCEDURE Bind(
891: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,
892: -- Hint: Add more binding variables here
893: p_cur_get_PLH IN NUMBER
894: )
895: IS

Line 966: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,

962:
963: END Gen_Select;
964:
965: PROCEDURE Gen_PLH_Where(
966: P_PLH_Rec IN CSP_Packlist_Headers_PUB.PLH_Rec_Type,
967: x_PLH_where OUT NOCOPY VARCHAR2
968: )
969: IS
970: -- cursors to check if wildcard values '%' and '_' have been passed