1: package body ZX_PROCESS_RESULTS_PKG as
2: /* $Header: zxdprocessrsltsb.pls 120.3 2003/12/19 03:51:40 ssekuri ship $ */
3:
4: procedure bulk_insert_process_results (
5: X_CONTENT_OWNER_ID IN t_content_owner_id,
28:
29: begin
30: If x_tax_rule_id.count <> 0 then
31: forall i in x_tax_rule_id.first..x_tax_rule_id.last
32: INSERT INTO ZX_PROCESS_RESULTS (RESULT_ID,
33: CONTENT_OWNER_ID,
34: CONDITION_GROUP_ID,
35: CONDITION_GROUP_CODE,
36: TAX_RULE_ID,
61: REQUEST_ID ,
62: PROGRAM_APPLICATION_ID ,
63: PROGRAM_ID ,
64: PROGRAM_LOGIN_ID)
65: values (zx_process_results_s.nextval,
66: X_CONTENT_OWNER_ID(i),
67: X_CONDITION_GROUP_ID(i),
68: X_CONDITION_GROUP_CODE(i),
69: X_TAX_RULE_ID(i),
104: APP_EXCEPTION.RAISE_EXCEPTION;
105:
106: end bulk_insert_process_results;
107:
108: end ZX_PROCESS_RESULTS_PKG;