[Home] [Help]
PACKAGE: APPS.ONT_OIP_COMMON
Source
1 package ONT_OIP_Common as
2 /* $Header: ontcomns.pls 120.4 2006/01/19 12:03:20 smwong noship $ */
3
4 gContactID number :=0;
5 gOPMCustID number :=0;
6 gCustomerID number :=0;
7 gCustomerAddrID number :=0;
8 gCustName varchar2(80);
9 gUserFName Varchar2(150);
10 gUserLName Varchar2(150);
11 gUserEmail Varchar2(250);
12 gUserPhone Varchar2(250);
13
14 gProductID number := 559;
15
16 gAndVal varchar2(1) :='&';
17 gSpace varchar2(6) :=gAndVal||'nbsp';
18 gTab varchar2(50) :=gSpace||gspace||gspace||gspace;
19
20 gCustFContact varchar2(250); -- Feedback Contact email to send info to
21 gCustFContactID number := 0;
22 gCustDContact varchar2(250); -- Defect Contact email to send info to
23 gCustDContactID number := 0;
24 gCustCContact varchar2(250); -- Cancel Contact email to send info to
25 gCustCContactID number := 0;
26
27 -----------------------------------------------
28 -- Declare Global Message Instantiation here.
29 -----------------------------------------------
30
31 gHelp varchar2(1000);
32 gReload varchar2(1000);
33 gMenu varchar2(1000);
34 gSave varchar2(1000);
35 gExit varchar2(1000);
36
37
38 -------------------------------------------------
39 -- Generic funtion to get messages.
40 -------------------------------------------------
41 function getMessage(pMsgName varchar2,
42 pTokenName1 varchar2 DEFAULT NULL,
43 pTokenValue1 varchar2 DEFAULT NULL,
44 pTokenName2 varchar2 DEFAULT NULL,
45 pTokenValue2 varchar2 DEFAULT NULL,
46 pTokenName3 varchar2 DEFAULT NULL,
47 pTokenValue3 varchar2 DEFAULT NULL,
48 pTokenName4 varchar2 DEFAULT NULL,
49 pTokenValue4 varchar2 DEFAULT NULL,
50 pTokenName5 varchar2 DEFAULT NULL,
51 pTokenValue5 varchar2 DEFAULT NULL) return varchar2;
52
53 function getRecCount(pCurrent number,
54 pPageTot number,
55 pTotal number) return varchar2;
56
57 function Get_Released_Status_Name(p_source_code IN VARCHAR2,
58 p_released_status IN VARCHAR2,
59 p_oe_interfaced_flag IN VARCHAR2,
60 p_inv_interfaced_flag IN VARCHAR2,
61 p_move_order_line_id IN NUMBER) RETURN VARCHAR2;
62
63
64 procedure getContactId(lContactid in out NOCOPY varchar2);
65
66 procedure initialize;
67
68
69 procedure getContactDetails(lUserId in number,
70 pContactId out nocopy number,
71
72 pUserFName out nocopy varchar2,
73
74 pUserLName out nocopy varchar2,
75
76 pUserEmail out nocopy varchar2,
77
78 pCustName out nocopy varchar2,
79
80 pCustomerID out nocopy number,
81
82 pCustomerAddrID out nocopy number,
83
84 pStatusCode out nocopy number);
85
86
87 /****************************************************
88 * procedure Get_Price_Formatted
89 **********************************************************
90 * Logic :a) call FND_CURRENCY.get_info to get the precision and extend
91 * precision defined for the currency code.
92 *
93 * b)check profile OM: Unit Price Precision Type
94 * If the profile options value is "EXTENDED", call
95 * FND_CURRENCY.build_format_mask by passing the ext_precision
96 * from step(a) to get the format_mask.
97 *
98 * If the profile options value is "STANDARD", call
99 * FND_CURRENCY.build_format_mask by passing the precision from
100 * step(a) to get the format_mask.
101 *
102 * c)convert unit_selling_price from lines table to Char with correct
103 * format mask.
104 * Bug: 4058254
105 *
106 *
107 ************************************************************/
108
109 procedure Get_Price_formatted(
110 p_transactional_curr_code IN VARCHAR2,
111 p_price IN NUMBER,
112 p_line_category_code IN VARCHAR2,
113 x_price_formatted OUT NOCOPY VARCHAR2
114 );
115
116
117 end;
118