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.AP_TCA_SUPPLIER_SYNC_PKG dependencies on AP_SUPPLIERS

Line 21: l_num_1099 ap_suppliers.num_1099%type;

17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2,
19: x_party_id IN NUMBER) IS
20:
21: l_num_1099 ap_suppliers.num_1099%type;
22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;

Line 22: l_vat_registration_num ap_suppliers.vat_registration_num%type;

18: x_msg_data OUT NOCOPY VARCHAR2,
19: x_party_id IN NUMBER) IS
20:
21: l_num_1099 ap_suppliers.num_1099%type;
22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;

Line 23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;

19: x_party_id IN NUMBER) IS
20:
21: l_num_1099 ap_suppliers.num_1099%type;
22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;

Line 24: l_vendor_name ap_suppliers.vendor_name%type;

20:
21: l_num_1099 ap_suppliers.num_1099%type;
22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;
28: l_upgraded_num_1099 ap_suppliers.num_1099%type;

Line 25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;

21: l_num_1099 ap_suppliers.num_1099%type;
22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;
28: l_upgraded_num_1099 ap_suppliers.num_1099%type;
29: l_check_num_1099 ap_suppliers.tca_sync_num_1099%type;

Line 26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;

22: l_vat_registration_num ap_suppliers.vat_registration_num%type;
23: l_vendor_name_alt ap_suppliers.vendor_name_alt%type;
24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;
28: l_upgraded_num_1099 ap_suppliers.num_1099%type;
29: l_check_num_1099 ap_suppliers.tca_sync_num_1099%type;
30:

Line 28: l_upgraded_num_1099 ap_suppliers.num_1099%type;

24: l_vendor_name ap_suppliers.vendor_name%type;
25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;
28: l_upgraded_num_1099 ap_suppliers.num_1099%type;
29: l_check_num_1099 ap_suppliers.tca_sync_num_1099%type;
30:
31: -- Logging Infra:
32: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_Supplier';

Line 29: l_check_num_1099 ap_suppliers.tca_sync_num_1099%type;

25: l_tca_vendor_name ap_suppliers.tca_sync_vendor_name%type;
26: l_tca_vat_registration_num ap_suppliers.tca_sync_vat_reg_num%type;
27: l_check_party_id hz_parties.party_id%type;
28: l_upgraded_num_1099 ap_suppliers.num_1099%type;
29: l_check_num_1099 ap_suppliers.tca_sync_num_1099%type;
30:
31: -- Logging Infra:
32: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_Supplier';
33: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 112: FROM ap_suppliers

108: tca_sync_num_1099
109: INTO l_check_party_id,
110: l_upgraded_num_1099,
111: l_check_num_1099
112: FROM ap_suppliers
113: WHERE party_id = x_party_id;
114: EXCEPTION
115: WHEN OTHERS THEN
116: NULL;

Line 124: --num_1099 of the ap_suppliers.We store the TIN numbers of the contractors

120:
121: --bug6050423.We maintain the sync from tca to ap only if the vendor type is
122: --not contractor individual.For contractor individuals,if we update the
123: --the jgzz_fisacl_code in tca,the same thing will not be reflected in
124: --num_1099 of the ap_suppliers.We store the TIN numbers of the contractors
125: --in the field individual_1099 of ap_suppliers and not in TCA.
126:
127:
128: UPDATE ap_suppliers

Line 125: --in the field individual_1099 of ap_suppliers and not in TCA.

121: --bug6050423.We maintain the sync from tca to ap only if the vendor type is
122: --not contractor individual.For contractor individuals,if we update the
123: --the jgzz_fisacl_code in tca,the same thing will not be reflected in
124: --num_1099 of the ap_suppliers.We store the TIN numbers of the contractors
125: --in the field individual_1099 of ap_suppliers and not in TCA.
126:
127:
128: UPDATE ap_suppliers
129: SET

Line 128: UPDATE ap_suppliers

124: --num_1099 of the ap_suppliers.We store the TIN numbers of the contractors
125: --in the field individual_1099 of ap_suppliers and not in TCA.
126:
127:
128: UPDATE ap_suppliers
129: SET
130: --bug6691916.commented the below assignment statement and added
131: --the one below that.As per analysis,only organization type lookup
132: --code of individual or foreign individual are considered