APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on HZ_CUST_ACCOUNTS_ALL

Line 89: l_account_id hz_cust_accounts_all.cust_account_id%TYPE;

85: l_party_type VARCHAR2(25);
86: l_hdr_printed BOOLEAN := FALSE;
87: l_sub_hdr_printed BOOLEAN := FALSE;
88: l_aid_select varchar2(5000);
89: l_account_id hz_cust_accounts_all.cust_account_id%TYPE;
90: l_account_name hz_cust_accounts_all.account_name%TYPE;
91: l_agency_id VARCHAR2(2);
92: l_main_acct VARCHAR2(4);
93: l_update_statement varchar2(5000);

Line 90: l_account_name hz_cust_accounts_all.account_name%TYPE;

86: l_hdr_printed BOOLEAN := FALSE;
87: l_sub_hdr_printed BOOLEAN := FALSE;
88: l_aid_select varchar2(5000);
89: l_account_id hz_cust_accounts_all.cust_account_id%TYPE;
90: l_account_name hz_cust_accounts_all.account_name%TYPE;
91: l_agency_id VARCHAR2(2);
92: l_main_acct VARCHAR2(4);
93: l_update_statement varchar2(5000);
94: l_err_string varchar2(500);

Line 178: l_table := 'hz_cust_accounts_all';

174: IF i = 1 THEN
175: l_col_select := ' select c.cust_account_id, c.account_name,';
176: l_where_clause := 'and c.customer_class_code = ''FEDERAL'' ';
177: l_attrib := l_facts1_cust_attribute;
178: l_table := 'hz_cust_accounts_all';
179: l_party_type := '-----CUSTOMERS-----';
180: l_sub_hdr_printed := FALSE;
181: ELSE
182: l_col_select := ' select c.vendor_id, c.vendor_name,';

Line 241: FROM hz_cust_accounts_all c ';

237: l_hdr_printed := FALSE;
238: FOR i in 1..2 LOOP
239: IF i = 1 THEN
240: l_col_select := ' SELECT SUBSTR(c.account_name,1,80)
241: FROM hz_cust_accounts_all c ';
242: l_where_clause := 'and c.customer_class_code = ''FEDERAL'' ';
243: l_attrib := l_facts1_cust_attribute;
244:
245: l_party_type := '-----CUSTOMERS-----';

Line 301: --Update new column in hz_cust_accounts_all

297: --from the mapping table
298: fv_utility.log_mesg('Updating cust/supp with 3 digit agency id.');
299: FOR j in 1..2 LOOP
300: IF j = 1 THEN
301: --Update new column in hz_cust_accounts_all
302: l_attrib := l_facts1_cust_attribute;
303: IF l_cust_col_exists = 'Y' THEN
304:
305: l_update_statement := '

Line 306: update hz_cust_accounts_all c

302: l_attrib := l_facts1_cust_attribute;
303: IF l_cust_col_exists = 'Y' THEN
304:
305: l_update_statement := '
306: update hz_cust_accounts_all c
307: set TRADING_PARTNER_AGENCY_ID =
308: (select f.aid
309: from fv_agency_id_map f
310: where f.star_dept_reg = SUBSTR(c.'||l_attrib||',1,2)

Line 328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');

324:
325: fnd_file.put_line(fnd_file.log,' ');
326: fnd_file.put_line(fnd_file.log,' ');
327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:
330: ELSE
331: --Update dff column in hz_cust_accounts_all
332: l_update_statement :=

Line 331: --Update dff column in hz_cust_accounts_all

327: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
328: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.TRADING_PARTNER_AGENCY_ID');
329:
330: ELSE
331: --Update dff column in hz_cust_accounts_all
332: l_update_statement :=
333: 'update hz_cust_accounts_all c
334: set '||l_gtas_cust_attribute||' =
335: (select f.aid

Line 333: 'update hz_cust_accounts_all c

329:
330: ELSE
331: --Update dff column in hz_cust_accounts_all
332: l_update_statement :=
333: 'update hz_cust_accounts_all c
334: set '||l_gtas_cust_attribute||' =
335: (select f.aid
336: from fv_agency_id_map f
337: where f.star_dept_reg = SUBSTR(c.'||l_attrib||',1,2)

Line 355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);

351:
352: fnd_file.put_line(fnd_file.log,' ');
353: fnd_file.put_line(fnd_file.log,' ');
354: fnd_file.put_line(fnd_file.log,'------------------------------------------------------');
355: fnd_file.put_line(fnd_file.log,'Updated hz_cust_accounts_all.'||l_gtas_cust_attribute);
356: END IF;
357:
358:
359: EXECUTE IMMEDIATE l_update_statement;