APPS.JTF_IH_BULK dependencies on JTF_IH_BULK_ERRORS

Line 1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;

1969: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'p_ret_msg = ' || p_ret_msg);
1970: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'error_msg_2 = ' || error_msg_2);
1971: */
1972:
1973: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
1974:
1975: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
1976:
1977: -- Bug3781768 Perf issue with literal usage

Line 1980: INSERT INTO JTF_IH_BULK_ERRORS

1976:
1977: -- Bug3781768 Perf issue with literal usage
1978: l_obj_version_perf := 0;
1979:
1980: INSERT INTO JTF_IH_BULK_ERRORS
1981: (bulk_error_id, object_version_number, creation_date, created_by,
1982: last_update_date, last_updated_by, last_update_login, program_id,
1983: request_id, program_application_id, program_update_date,
1984: bulk_writer_code, bulk_batch_id, bulk_batch_type, bulk_interaction_id,

Line 1994: FROM jtf_ih_bulk_errors

1990: p_bulk_writer_code, p_bulk_batch_id, p_bulk_batch_type,
1991: p_bulk_interaction_id, error_msg_2, EMPTY_CLOB());
1992:
1993: SELECT inter_req_xml_doc INTO bad_int_clob
1994: FROM jtf_ih_bulk_errors
1995: WHERE bulk_error_id = rec_id;
1996:
1997: bad_int_clob := 'AAAA';
1998:

Line 2001: UPDATE jtf_ih_bulk_errors

1997: bad_int_clob := 'AAAA';
1998:
1999: dbms_xmldom.writeToClob(p_int_node, bad_int_clob);
2000:
2001: UPDATE jtf_ih_bulk_errors
2002: SET inter_req_xml_doc = bad_int_clob
2003: WHERE bulk_error_id = rec_id;
2004:
2005: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2100: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;

2096: error_msg_2 := SUBSTRB(p_error_msg, 0, 2000);
2097: error_msg_2 := error_msg_2 || SUBSTRB(' - ', 0, (2000 - LENGTHB(error_msg_2)));
2098: error_msg_2 := error_msg_2 || SUBSTRB(p_ret_msg, 0, (2000 - LENGTHB(error_msg_2)));
2099:
2100: SELECT JTF_IH_BULK_ERRORS_S1.NEXTVAL INTO rec_id FROM sys.dual;
2101:
2102: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'BULK_ERROR_ID = ' || rec_id);
2103:
2104: -- Bug3781768 Perf issue with literal usage

Line 2107: INSERT INTO JTF_IH_BULK_ERRORS

2103:
2104: -- Bug3781768 Perf issue with literal usage
2105: l_obj_version_perf := 0;
2106:
2107: INSERT INTO JTF_IH_BULK_ERRORS
2108: (bulk_error_id, object_version_number, creation_date, created_by,
2109: last_update_date, last_updated_by, last_update_login, program_id,
2110: request_id, program_application_id, program_update_date,
2111: bulk_writer_code, bulk_batch_id, bulk_batch_type, bulk_interaction_id,