APPS.CS_CP_AUDIT_PKG dependencies on CS_CP_AUDIT

Line 1: PACKAGE BODY CS_CP_AUDIT_PKG as

1: PACKAGE BODY CS_CP_AUDIT_PKG as
2: /* $Header: csxciaub.pls 115.2 2000/07/18 21:43:34 pkm ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
5:

Line 49: CURSOR C IS SELECT rowid FROM CS_CP_AUDIT

45: X_Old_Type_Code VARCHAR2,
46: X_Current_Type_Code VARCHAR2
47: ) IS
48: l_cp_audit_id NUMBER;
49: CURSOR C IS SELECT rowid FROM CS_CP_AUDIT
50: WHERE customer_product_id = X_Customer_Product_Id;
51:
52: BEGIN
53: select cs_cp_audit_s.NEXTVAL

Line 53: select cs_cp_audit_s.NEXTVAL

49: CURSOR C IS SELECT rowid FROM CS_CP_AUDIT
50: WHERE customer_product_id = X_Customer_Product_Id;
51:
52: BEGIN
53: select cs_cp_audit_s.NEXTVAL
54: into l_cp_audit_id
55: from dual;
56:
57: INSERT INTO CS_CP_AUDIT(

Line 57: INSERT INTO CS_CP_AUDIT(

53: select cs_cp_audit_s.NEXTVAL
54: into l_cp_audit_id
55: from dual;
56:
57: INSERT INTO CS_CP_AUDIT(
58: cp_audit_id,
59: customer_product_id,
60: last_update_date,
61: last_updated_by,

Line 197: FROM CS_CP_AUDIT

193: X_Current_Type_Code VARCHAR2
194: ) IS
195: CURSOR C IS
196: SELECT *
197: FROM CS_CP_AUDIT
198: WHERE rowid = X_Rowid
199: FOR UPDATE of Customer_Product_Id NOWAIT;
200: Recinfo C%ROWTYPE;
201:

Line 362: UPDATE CS_CP_AUDIT

358: X_Current_Type_Code VARCHAR2
359:
360: ) IS
361: BEGIN
362: UPDATE CS_CP_AUDIT
363: SET
364: customer_product_id = X_Customer_Product_Id,
365: last_update_date = X_Last_Update_Date,
366: last_updated_by = X_Last_Updated_By,

Line 410: END CS_CP_AUDIT_PKG;

406: Raise NO_DATA_FOUND;
407: end if;
408: END Update_Row;
409:
410: END CS_CP_AUDIT_PKG;