1 PACKAGE BODY CSD_UPDATE_SHIP_PROGRAM_CUHK as
2 /* $Header: csdcshpb.pls 120.1 2011/02/02 18:20:16 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 -- p_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 -- -----------------------------------------------------------------
41
42
43 PROCEDURE POST_UPDATE_PROD_TXN
44 (
45 p_repair_line_id IN NUMBER,
46 p_product_transaction_id IN NUMBER,
47 p_instance_id IN NUMBER,
48 p_comms_nl_trackable_flag IN VARCHAR2,
49 p_action_code IN VARCHAR2,
50 x_flag OUT NOCOPY NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2
54 ) IS
55 BEGIN
56
57 x_return_status := FND_API.G_RET_STS_SUCCESS;
58 x_flag := 0;
59
60 END POST_UPDATE_PROD_TXN;
61
62 --
63 END CSD_UPDATE_SHIP_PROGRAM_CUHK;
[Home] [Help]