DBA Data[Home] [Help]

PACKAGE BODY: APPS.IBY_PSON_CUSTOMIZER_PKG

Source


1 PACKAGE BODY IBY_PSON_CUSTOMIZER_PKG AS
2 /*$Header: ibypsonb.pls 120.3.12010000.1 2009/12/02 09:25:05 pschalla noship $*/
3 
4 --
5 -- This procedure can be used for customizing PSON
6 --
7   PROCEDURE Get_Custom_Tangible_Id
8             (
9             p_app_short_name    IN fnd_application.application_short_name%TYPE,
10 	    p_trxn_extn_id      IN iby_fndcpt_tx_extensions.trxn_extension_id%TYPE,
11             x_cust_pson        OUT NOCOPY VARCHAR2,
12             x_msg              OUT NOCOPY VARCHAR2
13             )
14   IS
15 
16   BEGIN
17     -- by default this procdeure returns x_msg as CUST_PSON_NO
18     -- and x_cust_pson as NULL
19     x_msg := G_CUST_PSON_NO;
20     x_cust_pson := NULL;
21 
22     --
23     -- Implent custom code here to retun customized PSON
24     -- and set x_msg as CUST_PSON_YES
25     -- ORDER_ID,TRXN_REF_NUMBER1 and TRXN_REF_NUMBER2 can be
26     -- queried from the table IBY_FNDCPT_TX_EXTENSIONS using TRXN_EXTENSION_ID
27     /*
28     Example# 1
29       x_cust_pson:= p_app_short_name || p_trxn_extn_id;
30       x_msg := G_CUST_PSON_YES;
31 
32     Example# 2
33       x_cust_pson:= p_app_short_name || '_' || p_trxn_extn_id;
34       x_msg := G_CUST_PSON_YES;
35 
36     */
37 
38 
39 
40     -- End custom code
41 
42   END Get_Custom_Tangible_Id;
43 
44 
45 END IBY_PSON_CUSTOMIZER_PKG;