APPS.CSP_PACK_SERIAL_LOTS_PUB dependencies on CSP_PACK_SERIAL_LOTS_PUB

Line 1: PACKAGE BODY CSP_Pack_Serial_Lots_PUB AS

1: PACKAGE BODY CSP_Pack_Serial_Lots_PUB AS
2: /* $Header: cspptspb.pls 115.5 2003/05/02 17:23:12 phegde ship $ */
3: -- Start of Comments
4: -- Package name : CSP_Pack_Serial_Lots_PUB
5: -- Purpose :

Line 4: -- Package name : CSP_Pack_Serial_Lots_PUB

1: PACKAGE BODY CSP_Pack_Serial_Lots_PUB AS
2: /* $Header: cspptspb.pls 115.5 2003/05/02 17:23:12 phegde ship $ */
3: -- Start of Comments
4: -- Package name : CSP_Pack_Serial_Lots_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 35: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,

31: -- Developer must manually add conversion logic to the attributes.
32: --
33: -- End of Comments
34: PROCEDURE Convert_plsl_Values_To_Ids(
35: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,
36: x_pvt_plsl_rec OUT NOCOPY CSP_pack_serial_lots_PVT.plsl_Rec_Type
37: )
38: IS
39: -- Hint: Declare cursor and local variables

Line 515: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,

511: PROCEDURE Get_pack_serial_lots(
512: P_Api_Version_Number IN NUMBER,
513: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
514: P_identity_salesforce_id IN NUMBER := NULL,
515: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,
516: -- Hint: Add list of bind variables here
517: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
518: p_start_rec_prt IN NUMBER := 1,
519: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

Line 521: p_order_by_rec IN CSP_pack_serial_lots_PUB.plsl_sort_rec_type,

517: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
518: p_start_rec_prt IN NUMBER := 1,
519: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
520: -- Hint: user defined record type
521: p_order_by_rec IN CSP_pack_serial_lots_PUB.plsl_sort_rec_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,
525: X_plsl_Tbl OUT NOCOPY CSP_pack_serial_lots_PUB.plsl_Tbl_Type,

Line 525: X_plsl_Tbl OUT NOCOPY CSP_pack_serial_lots_PUB.plsl_Tbl_Type,

521: p_order_by_rec IN CSP_pack_serial_lots_PUB.plsl_sort_rec_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,
525: X_plsl_Tbl OUT NOCOPY CSP_pack_serial_lots_PUB.plsl_Tbl_Type,
526: x_returned_rec_count OUT NOCOPY NUMBER,
527: x_next_rec_ptr OUT NOCOPY NUMBER,
528: x_tot_rec_count OUT NOCOPY NUMBER
529: -- other optional parameters

Line 648: End CSP_Pack_Serial_Lots_PUB;

644: ,X_RETURN_STATUS => X_RETURN_STATUS);
645: End Get_pack_serial_lots;
646:
647:
648: End CSP_Pack_Serial_Lots_PUB;