1 PACKAGE CSD_UPDATE_SHIP_PROGRAM_CUHK AUTHID CURRENT_USER as
2 /* $Header: csdcshps.pls 120.1 2011/02/02 18:19:27 takwong noship $ */
3 --
4 -- Package name : CSD_UPDATE_SHIP_PROGRAM_CUHK
5 -- Purpose : This package contains custom hooks for the update
6 -- shipping concurrent program.
7 -- History :
8
9
10 -- History :
11 -- Version Date Name Description
12 -- 12.0 08/24/08 takwong Created.
13 --
14 -- NOTE :
15 --
16
17 -- -----------------------------------------------------------------
18 -- procedure name: POST_UPDATE_PROD_TXN
19 -- description : This custom user hooks procedure called inside of the
20 -- CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE procedure.
21 -- It is called after updating csd_product_transactions
22 -- table and before call log activity to the csd history
23 -- table.
24 -- Please review procedure -
25 -- CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE
26 -- before use this custom user hooks.
27 -- Parameters: p_repair_line_id repair line id
28 -- p_product_transaction_id product transaction id
29 -- p_instance_id instance id of item shipped.
30 -- p_comms_nl_trackable_flag comms_nl_trackable_flag is
31 -- column in the mtl_system_items table
32 -- for shipped item id.
33 -- x_flag if the value return is = 0, the main program
34 -- CSD_UPDATE_PROGRAMS_PVT.SO_SHIP_UPDATE will
35 -- log activity to the csd history table, otherwise
36 -- it will not log activity and next time the so_ship_update
37 -- will process this shipped line again.
38 --
39 -- p_action_code Depot action code on the shipped prod trxn line.
40 -- x_return_status The return status, if it is SUCCESS, it
41 -- will return FND_API.G_RET_STS_SUCCESS
42 -- x_msg_count standard msg count return
43 -- x_msg_data standard msg data return
44 -- -----------------------------------------------------------------
45
46 PROCEDURE POST_UPDATE_PROD_TXN
47 (
48 p_repair_line_id IN NUMBER,
49 p_product_transaction_id IN NUMBER,
50 p_instance_id IN NUMBER,
51 p_comms_nl_trackable_flag IN VARCHAR2,
52 p_action_code IN VARCHAR2,
53 x_flag OUT NOCOPY NUMBER,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 --
60 END CSD_UPDATE_SHIP_PROGRAM_CUHK;