APPS.CSP_PICK_SERIAL_LOTS_PUB dependencies on CSP_PICK_SERIAL_LOTS_PUB

Line 1: PACKAGE BODY csp_pick_serial_lots_PUB AS

1: PACKAGE BODY csp_pick_serial_lots_PUB AS
2: /* $Header: cspptslb.pls 115.4 2003/05/02 17:21:54 phegde ship $ */
3: -- Start of Comments
4: -- Package name : csp_pick_serial_lots_PUB
5: -- Purpose :

Line 4: -- Package name : csp_pick_serial_lots_PUB

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

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

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

Line 35: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,

31: -- Developer must manually add conversion logic to the attributes.
32: --
33: -- End of Comments
34: PROCEDURE Convert_psl_Values_To_Ids(
35: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
36: x_pvt_psl_rec OUT NOCOPY csp_pick_serial_lots_PVT.psl_Rec_Type
37: )
38: IS
39: -- Hint: Declare cursor and local variables

Line 515: P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,

511: PROCEDURE Get_pick_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_psl_Rec IN csp_pick_serial_lots_PUB.psl_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_pick_serial_lots_PUB.psl_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_pick_serial_lots_PUB.psl_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_psl_Tbl OUT NOCOPY csp_pick_serial_lots_PUB.psl_Tbl_Type,

Line 525: X_psl_Tbl OUT NOCOPY csp_pick_serial_lots_PUB.psl_Tbl_Type,

521: p_order_by_rec IN csp_pick_serial_lots_PUB.psl_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_psl_Tbl OUT NOCOPY csp_pick_serial_lots_PUB.psl_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 647: End csp_pick_serial_lots_PUB;

643: ,X_RETURN_STATUS => X_RETURN_STATUS);
644: End Get_pick_serial_lots;
645:
646:
647: End csp_pick_serial_lots_PUB;