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.PAY_CA_T4A_CANCEL_MAG dependencies on PER_ADDRESSES

Line 1164: l_address_line1 per_addresses.address_line1%TYPE;

1160: l_asg_id NUMBER;
1161: l_neg_bal_exists BOOLEAN := FALSE;
1162:
1163: l_person_id per_people_f.person_id%TYPE;
1164: l_address_line1 per_addresses.address_line1%TYPE;
1165: l_address_line2 per_addresses.address_line2%TYPE;
1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;

Line 1165: l_address_line2 per_addresses.address_line2%TYPE;

1161: l_neg_bal_exists BOOLEAN := FALSE;
1162:
1163: l_person_id per_people_f.person_id%TYPE;
1164: l_address_line1 per_addresses.address_line1%TYPE;
1165: l_address_line2 per_addresses.address_line2%TYPE;
1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;
1169: l_country VARCHAR2(60);

Line 1166: l_address_line3 per_addresses.address_line3%TYPE;

1162:
1163: l_person_id per_people_f.person_id%TYPE;
1164: l_address_line1 per_addresses.address_line1%TYPE;
1165: l_address_line2 per_addresses.address_line2%TYPE;
1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;
1169: l_country VARCHAR2(60);
1170: l_emp_province per_addresses.region_1%TYPE;

Line 1167: l_city per_addresses.town_or_city%TYPE;

1163: l_person_id per_people_f.person_id%TYPE;
1164: l_address_line1 per_addresses.address_line1%TYPE;
1165: l_address_line2 per_addresses.address_line2%TYPE;
1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;
1169: l_country VARCHAR2(60);
1170: l_emp_province per_addresses.region_1%TYPE;
1171:

Line 1168: l_postal_code per_addresses.postal_code%TYPE;

1164: l_address_line1 per_addresses.address_line1%TYPE;
1165: l_address_line2 per_addresses.address_line2%TYPE;
1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;
1169: l_country VARCHAR2(60);
1170: l_emp_province per_addresses.region_1%TYPE;
1171:
1172: l_return VARCHAR2(240);

Line 1170: l_emp_province per_addresses.region_1%TYPE;

1166: l_address_line3 per_addresses.address_line3%TYPE;
1167: l_city per_addresses.town_or_city%TYPE;
1168: l_postal_code per_addresses.postal_code%TYPE;
1169: l_country VARCHAR2(60);
1170: l_emp_province per_addresses.region_1%TYPE;
1171:
1172: l_return VARCHAR2(240);
1173: l_return_xml VARCHAR2(200);
1174: l_status BOOLEAN := TRUE;