DBA Data[Home] [Help]

APPS.CS_AUDIT_OWNER_UPD_CON_PRG dependencies on CS_INCIDENTS_AUDIT_B

Line 77: FROM cs_incidents_audit_b a,

73: cii1.instance_id, cii2.instance_id,
74: mp1.master_organization_id, mp2.master_organization_id,
75: a.customer_product_id, a.old_customer_product_id, t.maintenance_flag,
76: a.maint_organization_id, a.old_maint_organization_id
77: FROM cs_incidents_audit_b a,
78: cs_incidents_all_b i,
79: cs_incident_types_b t,
80: csi_item_instances cii1,
81: csi_item_instances cii2,

Line 105: l_table_name VARCHAR2(30) := 'CS_INCIDENTS_AUDIT_B';

101: AND a.group_id IS NOT NULL));
102:
103: l_worker_id NUMBER;
104: l_product VARCHAR2(30) := 'CS';
105: l_table_name VARCHAR2(30) := 'CS_INCIDENTS_AUDIT_B';
106: l_table_owner VARCHAR2(30);
107: l_update_name VARCHAR2(30) := 'csxaownb.pls.120.0';
108: l_start_rowid ROWID;
109: l_end_rowid ROWID;

Line 174: UPDATE cs_incidents_audit_b

170: CLOSE c_all_audit_csr;
171: l_cur_fetch := rowid_arr.COUNT;
172: IF (rowid_arr.COUNT > 0) THEN
173: FORALL i in rowid_arr.first..rowid_arr.last
174: UPDATE cs_incidents_audit_b
175: SET incident_owner_id = DECODE(res_type(i),
176: 'RS_TEAM', NULL,
177: 'RS_GROUP', NULL,
178: inc_owner_id(i)),