eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.GMS_INSTALLMENTS_PKG

Source


1 package GMS_INSTALLMENTS_PKG AUTHID CURRENT_USER as
2 -- $Header: gmsawins.pls 115.6 2003/06/18 15:31:58 mmalhotr ship $
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_INSTALLMENT_ID in NUMBER,
6   X_INSTALLMENT_NUM in VARCHAR2,
7   X_AWARD_ID in NUMBER,
8   X_START_DATE_ACTIVE in DATE,
9   X_END_DATE_ACTIVE in DATE,
10   X_CLOSE_DATE in DATE,
11   X_DIRECT_COST in NUMBER,
12   X_INDIRECT_COST in NUMBER,
13   X_ACTIVE_FLAG in VARCHAR2,
14   X_BILLABLE_FLAG in VARCHAR2,
15   X_TYPE in VARCHAR2,
16   X_ISSUE_DATE in DATE,
17   X_DESCRIPTION in VARCHAR2,
18   X_ATTRIBUTE_CATEGORY in VARCHAR2,
19   X_ATTRIBUTE1 in VARCHAR2,
20   X_ATTRIBUTE2 in VARCHAR2,
21   X_ATTRIBUTE3 in VARCHAR2,
22   X_ATTRIBUTE4 in VARCHAR2,
23   X_ATTRIBUTE5 in VARCHAR2,
24   X_ATTRIBUTE6 in VARCHAR2,
25   X_ATTRIBUTE7 in VARCHAR2,
26   X_ATTRIBUTE8 in VARCHAR2,
27   X_ATTRIBUTE9 in VARCHAR2,
28   X_ATTRIBUTE10 in VARCHAR2,
29   X_ATTRIBUTE11 in VARCHAR2,
30   X_ATTRIBUTE12 in VARCHAR2,
31   X_ATTRIBUTE13 in VARCHAR2,
32   X_ATTRIBUTE14 in VARCHAR2,
33   X_ATTRIBUTE15 in VARCHAR2,
34   X_MODE in VARCHAR2 default 'R'
35   );
36 procedure LOCK_ROW (
37   X_INSTALLMENT_ID in NUMBER,
38   X_INSTALLMENT_NUM in VARCHAR2,
39   X_AWARD_ID in NUMBER,
40   X_START_DATE_ACTIVE in DATE,
41   X_END_DATE_ACTIVE in DATE,
42   X_CLOSE_DATE in DATE,
43   X_DIRECT_COST in NUMBER,
44   X_INDIRECT_COST in NUMBER,
45   X_ACTIVE_FLAG in VARCHAR2,
46   X_BILLABLE_FLAG in VARCHAR2,
47   X_TYPE in VARCHAR2,
48   X_ISSUE_DATE in DATE,
49   X_DESCRIPTION in VARCHAR2,
50   X_ATTRIBUTE_CATEGORY in VARCHAR2,
51   X_ATTRIBUTE1 in VARCHAR2,
52   X_ATTRIBUTE2 in VARCHAR2,
53   X_ATTRIBUTE3 in VARCHAR2,
54   X_ATTRIBUTE4 in VARCHAR2,
55   X_ATTRIBUTE5 in VARCHAR2,
56   X_ATTRIBUTE6 in VARCHAR2,
57   X_ATTRIBUTE7 in VARCHAR2,
58   X_ATTRIBUTE8 in VARCHAR2,
59   X_ATTRIBUTE9 in VARCHAR2,
60   X_ATTRIBUTE10 in VARCHAR2,
61   X_ATTRIBUTE11 in VARCHAR2,
62   X_ATTRIBUTE12 in VARCHAR2,
63   X_ATTRIBUTE13 in VARCHAR2,
64   X_ATTRIBUTE14 in VARCHAR2,
65   X_ATTRIBUTE15 in VARCHAR2
66 );
67 procedure UPDATE_ROW (
68   X_INSTALLMENT_ID in NUMBER,
69   X_INSTALLMENT_NUM in VARCHAR2,
70   X_AWARD_ID in NUMBER,
71   X_START_DATE_ACTIVE in DATE,
72   X_END_DATE_ACTIVE in DATE,
73   X_CLOSE_DATE in DATE,
74   X_DIRECT_COST in NUMBER,
75   X_INDIRECT_COST in NUMBER,
76   X_ACTIVE_FLAG in VARCHAR2,
77   X_BILLABLE_FLAG in VARCHAR2,
78   X_TYPE in VARCHAR2,
79   X_ISSUE_DATE in DATE,
80   X_DESCRIPTION in VARCHAR2,
81   X_ATTRIBUTE_CATEGORY in VARCHAR2,
82   X_ATTRIBUTE1 in VARCHAR2,
83   X_ATTRIBUTE2 in VARCHAR2,
84   X_ATTRIBUTE3 in VARCHAR2,
85   X_ATTRIBUTE4 in VARCHAR2,
86   X_ATTRIBUTE5 in VARCHAR2,
87   X_ATTRIBUTE6 in VARCHAR2,
88   X_ATTRIBUTE7 in VARCHAR2,
89   X_ATTRIBUTE8 in VARCHAR2,
90   X_ATTRIBUTE9 in VARCHAR2,
91   X_ATTRIBUTE10 in VARCHAR2,
92   X_ATTRIBUTE11 in VARCHAR2,
93   X_ATTRIBUTE12 in VARCHAR2,
94   X_ATTRIBUTE13 in VARCHAR2,
95   X_ATTRIBUTE14 in VARCHAR2,
96   X_ATTRIBUTE15 in VARCHAR2,
97   X_MODE in VARCHAR2 default 'R'
98   );
99 procedure ADD_ROW (
100   X_ROWID in out NOCOPY VARCHAR2,
101   X_INSTALLMENT_ID in NUMBER,
102   X_INSTALLMENT_NUM in VARCHAR2,
103   X_AWARD_ID in NUMBER,
104   X_START_DATE_ACTIVE in DATE,
105   X_END_DATE_ACTIVE in DATE,
106   X_CLOSE_DATE in DATE,
107   X_DIRECT_COST in NUMBER,
108   X_INDIRECT_COST in NUMBER,
109   X_ACTIVE_FLAG in VARCHAR2,
110   X_BILLABLE_FLAG in VARCHAR2,
111   X_TYPE in VARCHAR2,
112   X_ISSUE_DATE in DATE,
113   X_DESCRIPTION in VARCHAR2,
114   X_ATTRIBUTE_CATEGORY in VARCHAR2,
115   X_ATTRIBUTE1 in VARCHAR2,
116   X_ATTRIBUTE2 in VARCHAR2,
117   X_ATTRIBUTE3 in VARCHAR2,
118   X_ATTRIBUTE4 in VARCHAR2,
119   X_ATTRIBUTE5 in VARCHAR2,
120   X_ATTRIBUTE6 in VARCHAR2,
121   X_ATTRIBUTE7 in VARCHAR2,
122   X_ATTRIBUTE8 in VARCHAR2,
123   X_ATTRIBUTE9 in VARCHAR2,
124   X_ATTRIBUTE10 in VARCHAR2,
125   X_ATTRIBUTE11 in VARCHAR2,
126   X_ATTRIBUTE12 in VARCHAR2,
127   X_ATTRIBUTE13 in VARCHAR2,
128   X_ATTRIBUTE14 in VARCHAR2,
129   X_ATTRIBUTE15 in VARCHAR2,
130   X_MODE in VARCHAR2 default 'R'
131   );
132 procedure DELETE_ROW (
133   X_INSTALLMENT_ID in NUMBER
134 );
135 
136 FUNCTION installment_order(p_installment_num VARCHAR2) RETURN NUMBER;
137 PRAGMA RESTRICT_REFERENCES (installment_order, WNDS, WNPS);
138 
139 end GMS_INSTALLMENTS_PKG;