DBA Data[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on AP_SUPPLIER_INT_REJECTIONS

Line 674: DELETE ap_supplier_int_rejections

670: BEGIN
671: -- Initialize API return status to success
672: x_return_status := fnd_api.g_ret_sts_success;
673:
674: DELETE ap_supplier_int_rejections
675: WHERE parent_table = 'AP_SUPPLIERS_INT';
676:
677: fnd_file.put_line(fnd_file.log,
678: ' Validating vendor record before the party is created. ');

Line 802: FROM ap_supplier_int_rejections

798: last_update_date,
799: last_update_login,
800: created_by,
801: creation_date
802: FROM ap_supplier_int_rejections
803: WHERE parent_table = 'AP_SUPPLIERS_INT';
804:
805: IF (g_level_procedure >= g_current_runtime_level) THEN
806: fnd_log.string(g_level_procedure,

Line 1298: DELETE ap_supplier_int_rejections

1294: BEGIN
1295: -- Initialize API return status to success
1296: x_return_status := fnd_api.g_ret_sts_success;
1297:
1298: DELETE ap_supplier_int_rejections
1299: WHERE parent_table = 'AP_SUPPLIERS_INT';
1300:
1301: OPEN party_int_cur;
1302:

Line 1420: FROM ap_supplier_int_rejections

1416: last_update_date,
1417: last_update_login,
1418: created_by,
1419: creation_date
1420: FROM ap_supplier_int_rejections
1421: WHERE parent_table = 'AP_SUPPLIERS_INT';
1422:
1423: IF (g_level_procedure >= g_current_runtime_level) THEN
1424: fnd_log.string(g_level_procedure,

Line 1481: FROM ap_supplier_int_rejections

1477: last_update_date,
1478: last_update_login,
1479: created_by,
1480: creation_date
1481: FROM ap_supplier_int_rejections
1482: WHERE parent_table = 'AP_SUPPLIERS_INT';
1483:
1484: IF (g_level_procedure >= g_current_runtime_level) THEN
1485: fnd_log.string(g_level_procedure,

Line 1985: FROM ap_supplier_int_rejections

1981: last_update_date,
1982: last_update_login,
1983: created_by,
1984: creation_date
1985: FROM ap_supplier_int_rejections
1986: WHERE parent_table = 'AP_SUPPLIERS_INT'
1987: AND parent_id = p_vendor_rec.vendor_interface_id;
1988:
1989: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 2095: DELETE ap_supplier_int_rejections

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';
2097:
2098: -- API body
2099:

Line 2517: FROM ap_supplier_int_rejections

2513: last_update_date,
2514: last_update_login,
2515: created_by,
2516: creation_date
2517: FROM ap_supplier_int_rejections
2518: WHERE parent_table = 'AP_SUPPLIERS_INT'
2519: AND parent_id = vendor_rec.vendor_interface_id;
2520:
2521: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 2965: FROM ap_supplier_int_rejections

2961: last_update_date,
2962: last_update_login,
2963: created_by,
2964: creation_date
2965: FROM ap_supplier_int_rejections
2966: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'
2967: AND parent_id = p_site_rec.vendor_site_interface_id;
2968:
2969: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 3086: DELETE ap_supplier_int_rejections

3082:
3083: -- Initialize API return status to success
3084: x_return_status := fnd_api.g_ret_sts_success;
3085:
3086: DELETE ap_supplier_int_rejections
3087: WHERE parent_table = 'AP_SUPPLIER_SITES_INT';
3088:
3089: -- API body
3090:

Line 3549: FROM ap_supplier_int_rejections

3545: last_update_date,
3546: last_update_login,
3547: created_by,
3548: creation_date
3549: FROM ap_supplier_int_rejections
3550: WHERE parent_table = 'AP_SUPPLIER_SITES_INT'
3551: AND parent_id = site_rec.vendor_site_interface_id;
3552:
3553: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 3776: DELETE ap_supplier_int_rejections

3772: BEGIN
3773: -- Initialize API return status to success
3774: x_return_status := fnd_api.g_ret_sts_success;
3775:
3776: DELETE ap_supplier_int_rejections
3777: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT';
3778:
3779: -- API body
3780:

Line 4266: FROM ap_supplier_int_rejections

4262: last_update_date,
4263: last_update_login,
4264: created_by,
4265: creation_date
4266: FROM ap_supplier_int_rejections
4267: WHERE parent_table = 'AP_SUP_SITE_CONTACT_INT'
4268: AND parent_id = vendor_contact_rec.vendor_contact_interface_id;
4269: END IF;
4270: x_return_status := l_return_status;