APPS.CSP_PACKLIST_HEADERS_PUB dependencies on CSP_PACKLIST_HEADERS_PUB

Line 1: PACKAGE BODY CSP_Packlist_Headers_PUB AS

1: PACKAGE BODY CSP_Packlist_Headers_PUB AS
2: /* $Header: cspptahb.pls 115.6 2003/05/02 17:26:54 phegde ship $ */
3: -- Start of Comments
4: -- Package name : CSP_Packlist_Headers_PUB
5: -- Purpose :

Line 4: -- Package name : CSP_Packlist_Headers_PUB

1: PACKAGE BODY CSP_Packlist_Headers_PUB AS
2: /* $Header: cspptahb.pls 115.6 2003/05/02 17:26:54 phegde ship $ */
3: -- Start of Comments
4: -- Package name : CSP_Packlist_Headers_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_Packlist_Headers_PUB';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSP_Packlist_Headers_PUB';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspptahb.pls';
13:
14: -- Start of Comments
15: -- ***************** Private Conversion Routines Values -> Ids **************

Line 35: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,

31: -- Developer must manually add conversion logic to the attributes.
32: --
33: -- End of Comments
34: PROCEDURE Convert_PLH_Values_To_Ids(
35: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
36: x_pvt_PLH_rec OUT NOCOPY CSP_packlist_headers_PVT.PLH_Rec_Type
37: )
38: IS
39: -- Hint: Declare cursor and local variables

Line 546: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,

542: PROCEDURE Get_packlist_headers(
543: P_Api_Version_Number IN NUMBER,
544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
545: P_identity_salesforce_id IN NUMBER := NULL,
546: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
547: -- Hint: Add list of bind variables here
548: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
549: p_start_rec_prt IN NUMBER := 1,
550: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

Line 552: p_order_by_rec IN CSP_packlist_headers_PUB.PLH_sort_rec_type,

548: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
549: p_start_rec_prt IN NUMBER := 1,
550: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
551: -- Hint: user defined record type
552: p_order_by_rec IN CSP_packlist_headers_PUB.PLH_sort_rec_type,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: X_PLH_Tbl OUT NOCOPY CSP_packlist_headers_PUB.PLH_Tbl_Type,

Line 556: X_PLH_Tbl OUT NOCOPY CSP_packlist_headers_PUB.PLH_Tbl_Type,

552: p_order_by_rec IN CSP_packlist_headers_PUB.PLH_sort_rec_type,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: X_PLH_Tbl OUT NOCOPY CSP_packlist_headers_PUB.PLH_Tbl_Type,
557: x_returned_rec_count OUT NOCOPY NUMBER,
558: x_next_rec_ptr OUT NOCOPY NUMBER,
559: x_tot_rec_count OUT NOCOPY NUMBER
560: -- other optional parameters

Line 679: End CSP_Packlist_Headers_PUB;

675: ,X_RETURN_STATUS => X_RETURN_STATUS);
676: End Get_packlist_headers;
677:
678:
679: End CSP_Packlist_Headers_PUB;