DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on STANDARD

Line 2092: -- Standard Start of API savepoint

2088: BEGIN
2089: -- Initialize API return status to success
2090: x_return_status := fnd_api.g_ret_sts_success;
2091:
2092: -- Standard Start of API savepoint
2093: SAVEPOINT import_vendor_pub;
2094:
2095: DELETE ap_supplier_int_rejections
2096: WHERE parent_table = 'AP_SUPPLIERS_INT';

Line 2242: vendor_rec.sic_code := vendor_int_rec.standard_industry_class;

2238: vendor_rec.end_date_active := vendor_int_rec.end_date_active;
2239: vendor_rec.minority_group_lookup_code := vendor_int_rec.minority_group_lookup_code;
2240: vendor_rec.women_owned_flag := vendor_int_rec.women_owned_flag;
2241: vendor_rec.small_business_flag := vendor_int_rec.small_business_flag;
2242: vendor_rec.sic_code := vendor_int_rec.standard_industry_class;
2243: vendor_rec.hold_flag := vendor_int_rec.hold_flag;
2244: vendor_rec.purchasing_hold_reason := vendor_int_rec.purchasing_hold_reason;
2245: vendor_rec.hold_by := vendor_int_rec.hold_by;
2246: vendor_rec.hold_date := vendor_int_rec.hold_date;

Line 2567: -- Standard call to get message count and if count is 1,

2563: CLOSE vendor_int_cur;
2564:
2565: COMMIT WORK;
2566:
2567: -- Standard call to get message count and if count is 1,
2568: -- get message info.
2569: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2570: EXCEPTION
2571: WHEN fnd_api.g_exc_error THEN

Line 3078: -- Standard Start of API savepoint

3074:
3075: l_vendor_site_exists NUMBER := 0;
3076: BEGIN
3077:
3078: -- Standard Start of API savepoint
3079: SAVEPOINT import_vendor_sites_pub;
3080:
3081: -- fnd_msg_pub.initialize;
3082:

Line 3595: -- Standard check of p_commit.

3591: CLOSE site_int_cur;
3592:
3593: -- End of API body.
3594:
3595: -- Standard check of p_commit.
3596: COMMIT WORK;
3597:
3598: -- Standard call to get message count and if count is 1,
3599: -- get message info.

Line 3598: -- Standard call to get message count and if count is 1,

3594:
3595: -- Standard check of p_commit.
3596: COMMIT WORK;
3597:
3598: -- Standard call to get message count and if count is 1,
3599: -- get message info.
3600: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3601:
3602: EXCEPTION

Line 4283: -- Standard call to get message count and if count is 1,

4279: -- End of API body.
4280:
4281: COMMIT WORK;
4282:
4283: -- Standard call to get message count and if count is 1,
4284: -- get message info.
4285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4286:
4287: EXCEPTION

Line 5930: -- Standard call to get message count and if count is 1,

5926:
5927: CLOSE vendor_int_buss_class_cur;
5928: COMMIT;
5929:
5930: -- Standard call to get message count and if count is 1,
5931: -- get message info.
5932: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5933:
5934: EXCEPTION