DBA Data[Home] [Help]

APPS.PSB_ALLOCRULE_PERCENTS_PVT SQL Statements

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

Line: 9

PROCEDURE Insert_Row
( p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level    IN      NUMBER  :=  FND_API.G_VALID_LEVEL_FULL,
  p_return_status       OUT  NOCOPY     VARCHAR2,
  p_msg_count           OUT  NOCOPY     NUMBER,
  p_msg_data            OUT  NOCOPY     VARCHAR2,
  P_ALLOCATION_RULE_PERCENT_ID  IN OUT  NOCOPY NUMBER,
  P_ALLOCATION_RULE_ID   IN     NUMBER,
  P_PERIOD_NUM           IN     NUMBER,
  P_MONTHLY              IN     NUMBER,
  P_QUARTERLY            IN     NUMBER,
  P_SEMI_ANNUAL          IN     NUMBER,
  P_ATTRIBUTE1           IN     VARCHAR2,
  P_ATTRIBUTE2           IN     VARCHAR2,
  P_ATTRIBUTE3           IN     VARCHAR2,
  P_ATTRIBUTE4           IN     VARCHAR2,
  P_ATTRIBUTE5           IN     VARCHAR2,
  P_CONTEXT              IN     VARCHAR2,
  P_LAST_UPDATE_DATE     IN     DATE,
  P_LAST_UPDATED_BY      IN     NUMBER,
  P_LAST_UPDATE_LOGIN    IN     NUMBER,
  P_CREATED_BY           IN     NUMBER,
  P_CREATION_DATE        IN     DATE
)   IS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Insert_Row';
Line: 42

 select PSB_Allocrule_percents_S.NEXTVAL from DUAL ;
Line: 47

     SAVEPOINT Insert_Row_Pvt;
Line: 76

  INSERT INTO PSB_ALLOCRULE_PERCENTS (
	      allocation_rule_percent_id,
	      allocation_rule_id,
	      number_of_periods,
	      period_num,
	      percent,
	      last_update_date,
	      last_updated_by,
	      last_update_login,
	      created_by,
	      creation_date,
	      attribute1,
	      attribute2,
	      attribute3,
	      attribute4,
	      attribute5,
	      context)
     VALUES  (
	      P_ALLOCATION_RULE_PERCENT_ID,
	      P_ALLOCATION_RULE_ID,
	      12,
	      P_PERIOD_NUM,
	      P_MONTHLY,
	      P_LAST_UPDATE_DATE,
	      P_LAST_UPDATED_BY,
	      P_LAST_UPDATE_LOGIN,
	      P_CREATED_BY,
	      P_CREATION_DATE,
	      P_ATTRIBUTE1,
	      P_ATTRIBUTE2,
	      P_ATTRIBUTE3,
	      P_ATTRIBUTE4,
	      P_ATTRIBUTE5,
	      P_CONTEXT);
Line: 117

  INSERT INTO PSB_ALLOCRULE_PERCENTS (
	      allocation_rule_percent_id,
	      allocation_rule_id,
	      number_of_periods,
	      period_num,
	      percent,
	      last_update_date,
	      last_updated_by,
	      last_update_login,
	      created_by,
	      creation_date,
	      attribute1,
	      attribute2,
	      attribute3,
	      attribute4,
	      attribute5,
	      context)
     VALUES  (
	      P_ALLOCATION_RULE_PERCENT_ID,
	      P_ALLOCATION_RULE_ID,
	      4,
	      P_PERIOD_NUM,
	      P_QUARTERLY,
	      P_LAST_UPDATE_DATE,
	      P_LAST_UPDATED_BY,
	      P_LAST_UPDATE_LOGIN,
	      P_CREATED_BY,
	      P_CREATION_DATE,
	      P_ATTRIBUTE1,
	      P_ATTRIBUTE2,
	      P_ATTRIBUTE3,
	      P_ATTRIBUTE4,
	      P_ATTRIBUTE5,
	      P_CONTEXT);
Line: 158

  INSERT INTO PSB_ALLOCRULE_PERCENTS (
	      allocation_rule_percent_id,
	      allocation_rule_id,
	      number_of_periods,
	      period_num,
	      percent,
	      last_update_date,
	      last_updated_by,
	      last_update_login,
	      created_by,
	      creation_date,
	      attribute1,
	      attribute2,
	      attribute3,
	      attribute4,
	      attribute5,
	      context)
     VALUES  (
	      P_ALLOCATION_RULE_PERCENT_ID,
	      P_ALLOCATION_RULE_ID,
	      2,
	      P_PERIOD_NUM,
	      P_SEMI_ANNUAL,
	      P_LAST_UPDATE_DATE,
	      P_LAST_UPDATED_BY,
	      P_LAST_UPDATE_LOGIN,
	      P_CREATED_BY,
	      P_CREATION_DATE,
	      P_ATTRIBUTE1,
	      P_ATTRIBUTE2,
	      P_ATTRIBUTE3,
	      P_ATTRIBUTE4,
	      P_ATTRIBUTE5,
	      P_CONTEXT);
Line: 211

     rollback to Insert_Row_Pvt;
Line: 221

     rollback to Insert_Row_Pvt;
Line: 231

     rollback to Insert_Row_Pvt;
Line: 244

END Insert_Row;
Line: 246

PROCEDURE Update_Row
( p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level    IN      NUMBER  :=  FND_API.G_VALID_LEVEL_FULL,
  p_return_status       OUT  NOCOPY     VARCHAR2,
  p_msg_count           OUT  NOCOPY     NUMBER,
  p_msg_data            OUT  NOCOPY     VARCHAR2,
  P_ALLOCATION_RULE_ID   IN     NUMBER,
  P_PERIOD_NUM           IN     NUMBER,
  P_MONTHLY              IN     NUMBER,
  P_QUARTERLY            IN     NUMBER,
  P_SEMI_ANNUAL          IN     NUMBER,
  P_ATTRIBUTE1           IN     VARCHAR2,
  P_ATTRIBUTE2           IN     VARCHAR2,
  P_ATTRIBUTE3           IN     VARCHAR2,
  P_ATTRIBUTE4           IN     VARCHAR2,
  P_ATTRIBUTE5           IN     VARCHAR2,
  P_CONTEXT              IN     VARCHAR2,
  P_LAST_UPDATE_DATE     IN     DATE,
  P_LAST_UPDATED_BY      IN     NUMBER,
  P_LAST_UPDATE_LOGIN    IN     NUMBER
)   IS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Update_Row';
Line: 277

     SAVEPOINT Update_Row_Pvt;
Line: 301

  UPDATE PSB_ALLOCRULE_PERCENTS
  SET
	      percent            = P_MONTHLY,
	      last_update_date   = P_LAST_UPDATE_DATE,
	      last_updated_by    = P_LAST_UPDATED_BY,
	      last_update_login  = P_LAST_UPDATE_LOGIN,
	      attribute1         = P_ATTRIBUTE1,
	      attribute2         = P_ATTRIBUTE2,
	      attribute3         = P_ATTRIBUTE3,
	      attribute4         = P_ATTRIBUTE4,
	      attribute5         = P_ATTRIBUTE5,
	      context            = P_CONTEXT
  WHERE       allocation_rule_id = P_ALLOCATION_RULE_ID
    AND       number_of_periods  = 12
    AND       period_num         = P_PERIOD_NUM;
Line: 322

  UPDATE PSB_ALLOCRULE_PERCENTS
  SET
	      percent            = P_QUARTERLY,
	      last_update_date   = P_LAST_UPDATE_DATE,
	      last_updated_by    = P_LAST_UPDATED_BY,
	      last_update_login  = P_LAST_UPDATE_LOGIN,
	      attribute1         = P_ATTRIBUTE1,
	      attribute2         = P_ATTRIBUTE2,
	      attribute3         = P_ATTRIBUTE3,
	      attribute4         = P_ATTRIBUTE4,
	      attribute5         = P_ATTRIBUTE5,
	      context            = P_CONTEXT
  WHERE       allocation_rule_id = P_ALLOCATION_RULE_ID
    AND       number_of_periods  = 4
    AND       period_num         = P_PERIOD_NUM;
Line: 342

  UPDATE PSB_ALLOCRULE_PERCENTS
  SET
	      percent            = P_SEMI_ANNUAL,
	      last_update_date   = P_LAST_UPDATE_DATE,
	      last_updated_by    = P_LAST_UPDATED_BY,
	      last_update_login  = P_LAST_UPDATE_LOGIN,
	      attribute1         = P_ATTRIBUTE1,
	      attribute2         = P_ATTRIBUTE2,
	      attribute3         = P_ATTRIBUTE3,
	      attribute4         = P_ATTRIBUTE4,
	      attribute5         = P_ATTRIBUTE5,
	      context            = P_CONTEXT
  WHERE       allocation_rule_id = P_ALLOCATION_RULE_ID
    AND       number_of_periods  = 2
    AND       period_num         = P_PERIOD_NUM;
Line: 377

     rollback to Update_Row_Pvt;
Line: 387

     rollback to Update_Row_Pvt;
Line: 397

     rollback to Update_Row_Pvt;
Line: 410

END Update_Row;
Line: 412

PROCEDURE Delete_Row
( p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2 := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2 := FND_API.G_FALSE,
  p_validation_level    IN      NUMBER  :=  FND_API.G_VALID_LEVEL_FULL,
  p_return_status       OUT  NOCOPY     VARCHAR2,
  p_msg_count           OUT  NOCOPY     NUMBER,
  p_msg_data            OUT  NOCOPY     VARCHAR2,
  P_ALLOCATION_RULE_ID   IN     NUMBER,
  P_PERIOD_NUM           IN     NUMBER
)   IS

  l_api_name            CONSTANT VARCHAR2(30)   := 'Delete_Row';
Line: 428

 select PSB_Allocrule_percents_S.NEXTVAL from DUAL ;
Line: 433

     SAVEPOINT Delete_Row_Pvt;
Line: 457

  DELETE FROM PSB_ALLOCRULE_PERCENTS
  WHERE  ALLOCATION_RULE_ID = P_ALLOCATION_RULE_ID
    AND  PERIOD_NUM         = P_PERIOD_NUM;
Line: 482

     rollback to Delete_Row_Pvt;
Line: 492

     rollback to Delete_Row_Pvt;
Line: 502

     rollback to Delete_Row_Pvt;
Line: 515

END Delete_Row;
Line: 541

	 SELECT ALLOCATION_RULE_ID,
		PERIOD_NUM,
		NUMBER_OF_PERIODS,
		PERCENT
	   FROM PSB_ALLOCRULE_PERCENTS
	  WHERE ALLOCATION_RULE_ID = P_ALLOCATION_RULE_ID
	    AND PERIOD_NUM         = P_PERIOD_NUM
	  ORDER BY NUMBER_OF_PERIODS
	 FOR UPDATE OF PERCENT NOWAIT;
Line: 587

	FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
Line: 610

	FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
Line: 633

	FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');