eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGW_PROPOSALS_ALL_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_PROPOSAL_ID in NUMBER,
  X_SPONSOR_ACTION_CODE in VARCHAR2,
  X_SPONSOR_ACTION_DATE in DATE,
  X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
  X_AWARD_AMOUNT in NUMBER,
  X_PROPOSAL_NUMBER in VARCHAR2,
  X_LEAD_ORGANIZATION_ID in NUMBER,
  X_PROPOSAL_STATUS in VARCHAR2,
  X_PROPOSAL_START_DATE in DATE,
  X_PROPOSAL_END_DATE in DATE,
  X_PROPOSAL_TITLE in VARCHAR2,
  X_PROPOSAL_TYPE_CODE in VARCHAR2,
  X_AWARD_NUMBER in VARCHAR2,
  X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
  X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
  X_ORIGINAL_PROPOSAL_START_DATE in DATE,
  X_ORIGINAL_PROPOSAL_END_DATE in DATE,
  X_ACTIVITY_TYPE_CODE in VARCHAR2,
  X_SPONSOR_ID in NUMBER,
  X_FUNDING_SPONSOR_UNIT in VARCHAR2,
  X_ORIGINAL_SPONSOR_ID in NUMBER,
  X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
  X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
  X_PROGRAM_NUMBER in VARCHAR2,
  X_PROGRAM_TITLE in VARCHAR2,
  X_PROGRAM_URL in VARCHAR2,
  X_SUBMITTING_ORGANIZATION_ID in NUMBER,
  X_SIGNING_OFFICIAL_ID in NUMBER,
  X_ADMIN_OFFICIAL_ID in NUMBER,
  X_DEADLINE_DATE in DATE,
  X_DEADLINE_TYPE in VARCHAR2,
  X_LETTER_OF_INTENT_DUE_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from IGW_PROPOSALS_ALL
      where PROPOSAL_ID = X_PROPOSAL_ID;

Line: 57


    X_LAST_UPDATE_DATE DATE;

Line: 58


    X_LAST_UPDATED_BY NUMBER;

Line: 59


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 61


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 63


    X_LAST_UPDATED_BY := 1;

Line: 64


    X_LAST_UPDATE_LOGIN := 0;

Line: 66


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 67


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 70


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 71


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 78


  insert into IGW_PROPOSALS_ALL (
    SPONSOR_ACTION_CODE,
    SPONSOR_ACTION_DATE,
    SPONSOR_ACTION_COMMENTS,
    AWARD_AMOUNT,
    PROPOSAL_ID,
    PROPOSAL_NUMBER,
    LEAD_ORGANIZATION_ID,
    PROPOSAL_STATUS,
    PROPOSAL_START_DATE,
    PROPOSAL_END_DATE,
    PROPOSAL_TITLE,
    PROPOSAL_TYPE_CODE,
    AWARD_NUMBER,
    ORIGINAL_PROPOSAL_NUMBER,
    ORIGINAL_AWARD_NUMBER,
    ORIGINAL_PROPOSAL_START_DATE,
    ORIGINAL_PROPOSAL_END_DATE,
    ACTIVITY_TYPE_CODE,
    SPONSOR_ID,
    FUNDING_SPONSOR_UNIT,
    ORIGINAL_SPONSOR_ID,
    SPONSOR_PROPOSAL_NUMBER,
    NOTICE_OF_OPPORTUNITY_CODE,
    PROGRAM_NUMBER,
    PROGRAM_TITLE,
    PROGRAM_URL,
    SUBMITTING_ORGANIZATION_ID,
    SIGNING_OFFICIAL_ID,
    ADMIN_OFFICIAL_ID,
    DEADLINE_DATE,
    DEADLINE_TYPE,
    LETTER_OF_INTENT_DUE_DATE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_SPONSOR_ACTION_CODE,
    X_SPONSOR_ACTION_DATE,
    X_SPONSOR_ACTION_COMMENTS,
    X_AWARD_AMOUNT,
    X_PROPOSAL_ID,
    X_PROPOSAL_NUMBER,
    X_LEAD_ORGANIZATION_ID,
    X_PROPOSAL_STATUS,
    X_PROPOSAL_START_DATE,
    X_PROPOSAL_END_DATE,
    X_PROPOSAL_TITLE,
    X_PROPOSAL_TYPE_CODE,
    X_AWARD_NUMBER,
    X_ORIGINAL_PROPOSAL_NUMBER,
    X_ORIGINAL_AWARD_NUMBER,
    X_ORIGINAL_PROPOSAL_START_DATE,
    X_ORIGINAL_PROPOSAL_END_DATE,
    X_ACTIVITY_TYPE_CODE,
    X_SPONSOR_ID,
    X_FUNDING_SPONSOR_UNIT,
    X_ORIGINAL_SPONSOR_ID,
    X_SPONSOR_PROPOSAL_NUMBER,
    X_NOTICE_OF_OPPORTUNITY_CODE,
    X_PROGRAM_NUMBER,
    X_PROGRAM_TITLE,
    X_PROGRAM_URL,
    X_SUBMITTING_ORGANIZATION_ID,
    X_SIGNING_OFFICIAL_ID,
    X_ADMIN_OFFICIAL_ID,
    X_DEADLINE_DATE,
    X_DEADLINE_TYPE,
    X_LETTER_OF_INTENT_DUE_DATE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 196


end INSERT_ROW;

Line: 249


  cursor c1 is select
      SPONSOR_ACTION_CODE,
      SPONSOR_ACTION_DATE,
      SPONSOR_ACTION_COMMENTS,
      AWARD_AMOUNT,
      PROPOSAL_NUMBER,
      LEAD_ORGANIZATION_ID,
      PROPOSAL_STATUS,
      PROPOSAL_START_DATE,
      PROPOSAL_END_DATE,
      PROPOSAL_TITLE,
      PROPOSAL_TYPE_CODE,
      AWARD_NUMBER,
      ORIGINAL_PROPOSAL_NUMBER,
      ORIGINAL_AWARD_NUMBER,
      ORIGINAL_PROPOSAL_START_DATE,
      ORIGINAL_PROPOSAL_END_DATE,
      ACTIVITY_TYPE_CODE,
      SPONSOR_ID,
      FUNDING_SPONSOR_UNIT,
      ORIGINAL_SPONSOR_ID,
      SPONSOR_PROPOSAL_NUMBER,
      NOTICE_OF_OPPORTUNITY_CODE,
      PROGRAM_NUMBER,
      PROGRAM_TITLE,
      PROGRAM_URL,
      SUBMITTING_ORGANIZATION_ID,
      SIGNING_OFFICIAL_ID,
      ADMIN_OFFICIAL_ID,
      DEADLINE_DATE,
      DEADLINE_TYPE,
      LETTER_OF_INTENT_DUE_DATE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from IGW_PROPOSALS_ALL
    where ROWID = X_ROWID
    for update of PROPOSAL_ID nowait;

Line: 451


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PROPOSAL_ID in NUMBER,
  X_SPONSOR_ACTION_CODE in VARCHAR2,
  X_SPONSOR_ACTION_DATE in DATE,
  X_SPONSOR_ACTION_COMMENTS in VARCHAR2,
  X_AWARD_AMOUNT in NUMBER,
  X_PROPOSAL_NUMBER in VARCHAR2,
  X_LEAD_ORGANIZATION_ID in NUMBER,
  X_PROPOSAL_STATUS in VARCHAR2,
  X_PROPOSAL_START_DATE in DATE,
  X_PROPOSAL_END_DATE in DATE,
  X_PROPOSAL_TITLE in VARCHAR2,
  X_PROPOSAL_TYPE_CODE in VARCHAR2,
  X_AWARD_NUMBER in VARCHAR2,
  X_ORIGINAL_PROPOSAL_NUMBER in VARCHAR2,
  X_ORIGINAL_AWARD_NUMBER in VARCHAR2,
  X_ORIGINAL_PROPOSAL_START_DATE in DATE,
  X_ORIGINAL_PROPOSAL_END_DATE in DATE,
  X_ACTIVITY_TYPE_CODE in VARCHAR2,
  X_SPONSOR_ID in NUMBER,
  X_FUNDING_SPONSOR_UNIT in VARCHAR2,
  X_ORIGINAL_SPONSOR_ID in NUMBER,
  X_SPONSOR_PROPOSAL_NUMBER in VARCHAR2,
  X_NOTICE_OF_OPPORTUNITY_CODE in VARCHAR2,
  X_PROGRAM_NUMBER in VARCHAR2,
  X_PROGRAM_TITLE in VARCHAR2,
  X_PROGRAM_URL in VARCHAR2,
  X_SUBMITTING_ORGANIZATION_ID in NUMBER,
  X_SIGNING_OFFICIAL_ID in NUMBER,
  X_ADMIN_OFFICIAL_ID in NUMBER,
  X_DEADLINE_DATE in DATE,
  X_DEADLINE_TYPE in VARCHAR2,
  X_LETTER_OF_INTENT_DUE_DATE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is

    X_LAST_UPDATE_DATE DATE;

Line: 505


    X_LAST_UPDATED_BY NUMBER;

Line: 506


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 513


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 515


    X_LAST_UPDATED_BY := 1;

Line: 516


    X_LAST_UPDATE_LOGIN := 0;

Line: 518


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 519


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 522


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 523


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 531


  select sponsor_action_date,
         sponsor_action_code,
         sponsor_action_comments
  into   l_old_sponsor_action_date,
         l_old_sponsor_action_code,
         l_old_sponsor_action_comments
  from   igw_proposals_all
  where  proposal_id = x_proposal_id;

Line: 540


  update IGW_PROPOSALS_ALL set
    SPONSOR_ACTION_CODE = X_SPONSOR_ACTION_CODE,
    SPONSOR_ACTION_DATE = X_SPONSOR_ACTION_DATE,
    SPONSOR_ACTION_COMMENTS = X_SPONSOR_ACTION_COMMENTS,
    AWARD_AMOUNT = X_AWARD_AMOUNT,
    PROPOSAL_NUMBER = X_PROPOSAL_NUMBER,
    LEAD_ORGANIZATION_ID = X_LEAD_ORGANIZATION_ID,
    PROPOSAL_STATUS = X_PROPOSAL_STATUS,
    PROPOSAL_START_DATE = X_PROPOSAL_START_DATE,
    PROPOSAL_END_DATE = X_PROPOSAL_END_DATE,
    PROPOSAL_TITLE = X_PROPOSAL_TITLE,
    PROPOSAL_TYPE_CODE = X_PROPOSAL_TYPE_CODE,
    AWARD_NUMBER = X_AWARD_NUMBER,
    ORIGINAL_PROPOSAL_NUMBER = X_ORIGINAL_PROPOSAL_NUMBER,
    ORIGINAL_AWARD_NUMBER = X_ORIGINAL_AWARD_NUMBER,
    ORIGINAL_PROPOSAL_START_DATE = X_ORIGINAL_PROPOSAL_START_DATE,
    ORIGINAL_PROPOSAL_END_DATE = X_ORIGINAL_PROPOSAL_END_DATE,
    ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
    SPONSOR_ID = X_SPONSOR_ID,
    FUNDING_SPONSOR_UNIT = X_FUNDING_SPONSOR_UNIT,
    ORIGINAL_SPONSOR_ID = X_ORIGINAL_SPONSOR_ID,
    SPONSOR_PROPOSAL_NUMBER = X_SPONSOR_PROPOSAL_NUMBER,
    NOTICE_OF_OPPORTUNITY_CODE = X_NOTICE_OF_OPPORTUNITY_CODE,
    PROGRAM_NUMBER = X_PROGRAM_NUMBER,
    PROGRAM_TITLE = X_PROGRAM_TITLE,
    PROGRAM_URL = X_PROGRAM_URL,
    SUBMITTING_ORGANIZATION_ID = X_SUBMITTING_ORGANIZATION_ID,
    SIGNING_OFFICIAL_ID = X_SIGNING_OFFICIAL_ID,
    ADMIN_OFFICIAL_ID = X_ADMIN_OFFICIAL_ID,
    DEADLINE_DATE = X_DEADLINE_DATE,
    DEADLINE_TYPE = X_DEADLINE_TYPE,
    LETTER_OF_INTENT_DUE_DATE = X_LETTER_OF_INTENT_DUE_DATE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where ROWID = X_ROWID
  ;

Line: 603


     insert into igw_prop_comments
     (
     PROPOSAL_ID,
     COMMENT_ID,
     COMMENTS,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_LOGIN,
     RECORD_VERSION_NUMBER,
     SPONSOR_ACTION_CODE,
     SPONSOR_ACTION_DATE
     )
     values
     (
     X_PROPOSAL_ID,
     IGW_PROP_COMMENTS_S.NEXTVAL,
     X_SPONSOR_ACTION_COMMENTS,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN,
     1,
     X_SPONSOR_ACTION_CODE,
     X_SPONSOR_ACTION_DATE
     );

Line: 637


end UPDATE_ROW;

Line: 691


  cursor c1 is select rowid from IGW_PROPOSALS_ALL
     where PROPOSAL_ID = X_PROPOSAL_ID
  ;

Line: 700


    INSERT_ROW (
     X_ROWID,
     X_PROPOSAL_ID,
     X_SPONSOR_ACTION_CODE,
     X_SPONSOR_ACTION_DATE,
     X_SPONSOR_ACTION_COMMENTS,
     X_AWARD_AMOUNT,
     X_PROPOSAL_NUMBER,
     X_LEAD_ORGANIZATION_ID,
     X_PROPOSAL_STATUS,
     X_PROPOSAL_START_DATE,
     X_PROPOSAL_END_DATE,
     X_PROPOSAL_TITLE,
     X_PROPOSAL_TYPE_CODE,
     X_AWARD_NUMBER,
     X_ORIGINAL_PROPOSAL_NUMBER,
     X_ORIGINAL_AWARD_NUMBER,
     X_ORIGINAL_PROPOSAL_START_DATE,
     X_ORIGINAL_PROPOSAL_END_DATE,
     X_ACTIVITY_TYPE_CODE,
     X_SPONSOR_ID,
     X_FUNDING_SPONSOR_UNIT,
     X_ORIGINAL_SPONSOR_ID,
     X_SPONSOR_PROPOSAL_NUMBER,
     X_NOTICE_OF_OPPORTUNITY_CODE,
     X_PROGRAM_NUMBER,
     X_PROGRAM_TITLE,
     X_PROGRAM_URL,
     X_SUBMITTING_ORGANIZATION_ID,
     X_SIGNING_OFFICIAL_ID,
     X_ADMIN_OFFICIAL_ID,
     X_DEADLINE_DATE,
     X_DEADLINE_TYPE,
     X_LETTER_OF_INTENT_DUE_DATE,
     X_ATTRIBUTE_CATEGORY,
     X_ATTRIBUTE1,
     X_ATTRIBUTE2,
     X_ATTRIBUTE3,
     X_ATTRIBUTE4,
     X_ATTRIBUTE5,
     X_ATTRIBUTE6,
     X_ATTRIBUTE7,
     X_ATTRIBUTE8,
     X_ATTRIBUTE9,
     X_ATTRIBUTE10,
     X_ATTRIBUTE11,
     X_ATTRIBUTE12,
     X_ATTRIBUTE13,
     X_ATTRIBUTE14,
     X_ATTRIBUTE15,
     X_MODE);

Line: 754


  UPDATE_ROW (
   X_ROWID,
   X_PROPOSAL_ID,
   X_SPONSOR_ACTION_CODE,
   X_SPONSOR_ACTION_DATE,
   X_SPONSOR_ACTION_COMMENTS,
   X_AWARD_AMOUNT,
   X_PROPOSAL_NUMBER,
   X_LEAD_ORGANIZATION_ID,
   X_PROPOSAL_STATUS,
   X_PROPOSAL_START_DATE,
   X_PROPOSAL_END_DATE,
   X_PROPOSAL_TITLE,
   X_PROPOSAL_TYPE_CODE,
   X_AWARD_NUMBER,
   X_ORIGINAL_PROPOSAL_NUMBER,
   X_ORIGINAL_AWARD_NUMBER,
   X_ORIGINAL_PROPOSAL_START_DATE,
   X_ORIGINAL_PROPOSAL_END_DATE,
   X_ACTIVITY_TYPE_CODE,
   X_SPONSOR_ID,
   X_FUNDING_SPONSOR_UNIT,
   X_ORIGINAL_SPONSOR_ID,
   X_SPONSOR_PROPOSAL_NUMBER,
   X_NOTICE_OF_OPPORTUNITY_CODE,
   X_PROGRAM_NUMBER,
   X_PROGRAM_TITLE,
   X_PROGRAM_URL,
   X_SUBMITTING_ORGANIZATION_ID,
   X_SIGNING_OFFICIAL_ID,
   X_ADMIN_OFFICIAL_ID,
   X_DEADLINE_DATE,
   X_DEADLINE_TYPE,
   X_LETTER_OF_INTENT_DUE_DATE,
   X_ATTRIBUTE_CATEGORY,
   X_ATTRIBUTE1,
   X_ATTRIBUTE2,
   X_ATTRIBUTE3,
   X_ATTRIBUTE4,
   X_ATTRIBUTE5,
   X_ATTRIBUTE6,
   X_ATTRIBUTE7,
   X_ATTRIBUTE8,
   X_ATTRIBUTE9,
   X_ATTRIBUTE10,
   X_ATTRIBUTE11,
   X_ATTRIBUTE12,
   X_ATTRIBUTE13,
   X_ATTRIBUTE14,
   X_ATTRIBUTE15,
   X_MODE);

Line: 807


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) is
begin
  delete from IGW_PROPOSALS_ALL
  where ROWID = X_ROWID;

Line: 816


end DELETE_ROW;