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.

APPS.JG_ZZ_JGZZALRL_PKG dependencies on FND_LOOKUP_VALUES

Line 19: l_source FND_LOOKUP_VALUES.meaning%Type := Null;

15: Return l_entity_identifier;
16: End get_entity_identifier;
17:
18: Function get_source Return Varchar2 Is
19: l_source FND_LOOKUP_VALUES.meaning%Type := Null;
20: Begin
21: select meaning
22: Into l_source
23: From FND_LOOKUP_VALUES

Line 23: From FND_LOOKUP_VALUES

19: l_source FND_LOOKUP_VALUES.meaning%Type := Null;
20: Begin
21: select meaning
22: Into l_source
23: From FND_LOOKUP_VALUES
24: Where lookup_type='JGZZ_SOURCE'
25: And lookup_code = p_source
26: And language = userenv('LANG');
27:

Line 35: l_fin_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;

31: Return l_source;
32: End get_source;
33:
34: Function get_fin_tran_type Return Varchar2 Is
35: l_fin_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;
36: Begin
37: Select meaning
38: Into l_fin_tran_type
39: From FND_LOOKUP_VALUES

Line 39: From FND_LOOKUP_VALUES

35: l_fin_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;
36: Begin
37: Select meaning
38: Into l_fin_tran_type
39: From FND_LOOKUP_VALUES
40: Where ( (p_source = 'AP'
41: and lookup_type = 'JGZZ_AP_OF_TRANS_TYPE')
42: Or
43: (p_source = 'AR'

Line 63: l_vat_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;

59: Return l_fin_tran_type;
60: End get_fin_tran_type;
61:
62: Function get_vat_tran_type Return Varchar2 Is
63: l_vat_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;
64: Begin
65: Select meaning
66: Into l_vat_tran_type
67: From FND_LOOKUP_VALUES

Line 67: From FND_LOOKUP_VALUES

63: l_vat_tran_type FND_LOOKUP_VALUES.meaning%Type := Null;
64: Begin
65: Select meaning
66: Into l_vat_tran_type
67: From FND_LOOKUP_VALUES
68: Where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
69: And lookup_code = p_vat_tran_type
70: And language = userenv('LANG');
71:

Line 110: l_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;

106: End get_tax_rate_code;
107:
108:
109: Function get_tax_box Return Varchar2 Is
110: l_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;
111: Begin
112: Select meaning
113: Into l_tax_box
114: From fnd_lookup_values

Line 114: From fnd_lookup_values

110: l_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;
111: Begin
112: Select meaning
113: Into l_tax_box
114: From fnd_lookup_values
115: WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
116: And lookup_code = p_tax_box
117: And language = userenv('LANG');
118:

Line 126: l_non_rec_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;

122: Return l_tax_box;
123: End get_tax_box;
124:
125: Function get_non_rec_tax_box Return Varchar2 Is
126: l_non_rec_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;
127: Begin
128: Select meaning
129: Into l_non_rec_tax_box
130: From fnd_lookup_values

Line 130: From fnd_lookup_values

126: l_non_rec_tax_box FND_LOOKUP_VALUES.meaning%Type := Null;
127: Begin
128: Select meaning
129: Into l_non_rec_tax_box
130: From fnd_lookup_values
131: WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
132: And lookup_code = p_non_rec_tax_box
133: And language = userenv('LANG');
134:

Line 142: l_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;

138: Return l_non_rec_tax_box;
139: End get_non_rec_tax_box;
140:
141: Function get_taxable_box Return Varchar2 Is
142: l_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;
143: Begin
144: Select meaning
145: Into l_taxable_box
146: From fnd_lookup_values

Line 146: From fnd_lookup_values

142: l_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;
143: Begin
144: Select meaning
145: Into l_taxable_box
146: From fnd_lookup_values
147: WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
148: And lookup_code = p_taxable_box
149: And language = userenv('LANG');
150:

Line 158: l_non_rec_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;

154: Return l_taxable_box;
155: End get_taxable_box;
156:
157: Function get_non_rec_taxable_box Return Varchar2 Is
158: l_non_rec_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;
159: Begin
160: Select meaning
161: Into l_non_rec_taxable_box
162: From fnd_lookup_values

Line 162: From fnd_lookup_values

158: l_non_rec_taxable_box FND_LOOKUP_VALUES.meaning%Type := Null;
159: Begin
160: Select meaning
161: Into l_non_rec_taxable_box
162: From fnd_lookup_values
163: WHERE lookup_type='JGZZ_VAT_REPORT_BOXES'
164: And lookup_code = p_non_rec_taxable_box
165: And language = userenv('LANG');
166: