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 113: FROM ap_suppliers

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

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

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

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

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

Line 129: UPDATE ap_suppliers

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