DBA Data[Home] [Help]

APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on FND_PROFILE

Line 30: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

26:
27: Function Is_Reg_Loc_Enabled Return Boolean IS
28: l_country_code Varchar2(30);
29: Begin
30: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
31: If (l_country_code = 'TW' or l_country_code = 'AR') THEN
32: Return TRUE;
33: Elsif Is_context_enabled(l_country_code) THEN
34: Return TRUE;

Line 90: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

86: f_org_id Varchar2(15);
87: temp1 Number;
88: temp2 Number;
89: Begin
90: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
91: fnd_profile.get('ORG_ID',l_org_id);
92:
93: If l_country_code = 'TW' Then
94: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code TW';

Line 91: fnd_profile.get('ORG_ID',l_org_id);

87: temp1 Number;
88: temp2 Number;
89: Begin
90: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
91: fnd_profile.get('ORG_ID',l_org_id);
92:
93: If l_country_code = 'TW' Then
94: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code TW';
95: Open C_Trx_lines(p_request_id);

Line 144: fnd_profile.get('ORG_ID',f_org_id);

140: and request_id = p_request_id;
141: End If;
142:
143: Elsif l_country_code = 'AR' Then
144: fnd_profile.get('ORG_ID',f_org_id);
145: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code AR';
146: Open C_Trx_lines(p_request_id);
147: Fetch C_Trx_lines Bulk Collect Into trx_number, customer_trx_id;
148: Close C_Trx_lines;

Line 264: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);

260: l_last_trx_num Varchar2(8);
261: l_message_text Varchar2(240);
262: l_batch_source_name Varchar2(50);
263: BEGIN
264: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
265: fnd_profile.get('ORG_ID',l_org_id);
266: IF l_country_code = 'TW' THEN
267: p_flag := 0;
268: l_debug_loc := 'Country code TW';

Line 265: fnd_profile.get('ORG_ID',l_org_id);

261: l_message_text Varchar2(240);
262: l_batch_source_name Varchar2(50);
263: BEGIN
264: fnd_profile.get('JGZZ_COUNTRY_CODE', l_country_code);
265: fnd_profile.get('ORG_ID',l_org_id);
266: IF l_country_code = 'TW' THEN
267: p_flag := 0;
268: l_debug_loc := 'Country code TW';
269: