APPS.CSC_CUSTOMIZED_PLANS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

PROCEDURE Insert_Row(
          px_ID                    IN OUT NOCOPY NUMBER,
          p_PLAN_ID                IN     NUMBER,
          p_PARTY_ID               IN     NUMBER,
		p_cust_account_id        IN     NUMBER,
		p_request_id             IN     NUMBER,
		p_program_application_id IN     NUMBER,
		p_program_id             IN     NUMBER,
		p_program_update_date    IN     DATE,
		p_plan_status_code       IN     VARCHAR2)
IS
   CURSOR C2 IS
	 SELECT CSC_CUSTOMIZED_PLANS_S.nextval
	 FROM sys.dual;

Line: 51

   INSERT INTO CSC_CUSTOMIZED_PLANS(
        ID,
        PLAN_ID,
        PARTY_ID ,
	   CUST_ACCOUNT_ID ,
	   REQUEST_ID,
	   PROGRAM_APPLICATION_ID,
	   PROGRAM_ID,
	   PROGRAM_UPDATE_DATE,
	   PLAN_STATUS_CODE )
   VALUES (
        px_ID,
        p_PLAN_ID,
        p_PARTY_ID,
        p_cust_account_id,
	   p_request_id,
	   p_program_application_id,
	   p_program_id,
	   p_program_update_date,
	   p_plan_status_code );

Line: 72

End Insert_Row;

Line: 75

PROCEDURE Delete_Row(
          P_ID                     IN     NUMBER,
	     P_PLAN_ID                IN     NUMBER,
	     P_PARTY_ID               IN     NUMBER)
IS
BEGIN
   if ( P_ID IS NOT NULL OR P_ID <> FND_API.G_MISS_NUM ) THEN
      DELETE FROM CSC_CUSTOMIZED_PLANS
      WHERE  ID = p_ID;

Line: 86

	    DELETE FROM CSC_CUSTOMIZED_PLANS
	    WHERE  PLAN_ID  = P_PLAN_ID
	    AND    PARTY_ID = P_PARTY_ID;

Line: 90

	    DELETE FROM CSC_CUSTOMIZED_PLANS
	    WHERE  PLAN_ID = P_PLAN_ID;

Line: 94

	 DELETE FROM CSC_CUSTOMIZED_PLANS
	 WHERE PARTY_ID = P_PARTY_ID;

Line: 102

END Delete_Row;