DBA Data[Home] [Help]

APPS.GMS_AWARDS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_AWARD_ID in NUMBER,
  X_AWARD_NUMBER in VARCHAR2,
  X_AWARD_SHORT_NAME in VARCHAR2,
  X_AWARD_FULL_NAME in VARCHAR2,
  X_FUNDING_SOURCE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_CLOSE_DATE in DATE,
  X_FUNDING_SOURCE_AWARD_NUMBER in VARCHAR2,
  X_AWARD_PURPOSE_CODE in VARCHAR2,
  X_STATUS in VARCHAR2,
  X_ALLOWABLE_SCHEDULE_ID in NUMBER,
  X_IDC_SCHEDULE_ID in NUMBER,
  X_REVENUE_DISTRIBUTION_RULE in VARCHAR2,
  X_BILLING_FREQUENCY in VARCHAR2,
  X_BILLING_CYCLE_ID  IN NUMBER,
  X_BILLING_OFFSET    IN NUMBER,
  X_BILLING_DISTRIBUTION_RULE in VARCHAR2,
  X_BILLING_FORMAT in VARCHAR2,
  X_BILLING_TERM in NUMBER,
  X_AWARD_PROJECT_ID in NUMBER,
  X_AGREEMENT_ID in NUMBER,
  X_AWARD_TEMPLATE_FLAG in VARCHAR2,
  X_PREAWARD_DATE in DATE,
  X_AGENCY_SPECIFIC_FORM in VARCHAR2,
  X_BILL_TO_CUSTOMER_ID in NUMBER,
  X_TRANSACTION_NUMBER in VARCHAR2,
  X_AMOUNT_TYPE in VARCHAR2,
  X_BOUNDARY_CODE in VARCHAR2,
  X_FUND_CONTROL_LEVEL_AWARD in VARCHAR2,
  X_FUND_CONTROL_LEVEL_TASK in VARCHAR2,
  X_FUND_CONTROL_LEVEL_RES_GRP in VARCHAR2,
  X_FUND_CONTROL_LEVEL_RES in VARCHAR2,
  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_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_TEMPLATE_START_DATE_ACTIVE in DATE,
  X_TEMPLATE_END_DATE_ACTIVE in DATE,
  X_ORG_ID in NUMBER, /* award_organization_id is created as org_id is now used due to multi- org */
  X_TYPE in VARCHAR2,
  X_COST_IND_SCH_FIXED_DATE in DATE,
  X_LABOR_INVOICE_FORMAT_ID in NUMBER,
  X_NON_LABOR_INVOICE_FORMAT_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_BILL_TO_ADDRESS_ID in NUMBER,
  X_SHIP_TO_ADDRESS_ID in NUMBER,
  X_LOC_BILL_TO_ADDRESS_ID in NUMBER,
  X_LOC_SHIP_TO_ADDRESS_ID in NUMBER,
  X_AWARD_ORGANIZATION_ID in NUMBER,
  X_HARD_LIMIT_FLAG in VARCHAR2 ,
  X_INVOICE_LIMIT_FLAG in VARCHAR2 , /*Bug 6642901 */
  X_PROPOSAL_ID IN NUMBER DEFAULT NULL,
  X_BUDGET_WF_ENABLED_FLAG in VARCHAR2
  ) is
    cursor C is select ROWID from GMS_AWARDS
      where AWARD_ID = X_AWARD_ID;
Line: 84

    X_LAST_UPDATE_DATE DATE;
Line: 85

    X_LAST_UPDATED_BY NUMBER;
Line: 86

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 95

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 97

    X_LAST_UPDATED_BY := 1;
Line: 98

    X_LAST_UPDATE_LOGIN := 0;
Line: 100

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 101

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 104

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 105

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 112

  insert into GMS_AWARDS (
    AWARD_ID,
    AWARD_NUMBER,
    AWARD_SHORT_NAME,
    AWARD_FULL_NAME,
    FUNDING_SOURCE_ID,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CLOSE_DATE,
    FUNDING_SOURCE_AWARD_NUMBER,
    AWARD_PURPOSE_CODE,
    STATUS,
    ALLOWABLE_SCHEDULE_ID,
    IDC_SCHEDULE_ID,
    REVENUE_DISTRIBUTION_RULE,
    BILLING_FREQUENCY,
    BILLING_CYCLE_ID,
    BILLING_OFFSET,
    BILLING_DISTRIBUTION_RULE,
    BILLING_FORMAT,
    BILLING_TERM,
    AWARD_PROJECT_ID,
    AGREEMENT_ID,
    AWARD_TEMPLATE_FLAG,
    PREAWARD_DATE,
    AGENCY_SPECIFIC_FORM,
    BILL_TO_CUSTOMER_ID,
    TRANSACTION_NUMBER,
    AMOUNT_TYPE,
    BOUNDARY_CODE,
    FUND_CONTROL_LEVEL_AWARD,
    FUND_CONTROL_LEVEL_TASK,
    FUND_CONTROL_LEVEL_RES_GRP,
    FUND_CONTROL_LEVEL_RES,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20,
    ATTRIBUTE21,
    ATTRIBUTE22,
    ATTRIBUTE23,
    ATTRIBUTE24,
    ATTRIBUTE25,
    TEMPLATE_START_DATE_ACTIVE,
    TEMPLATE_END_DATE_ACTIVE,
    ORG_ID,
    TYPE,
    COST_IND_SCH_FIXED_DATE,
    LABOR_INVOICE_FORMAT_ID,
    NON_LABOR_INVOICE_FORMAT_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    BILL_TO_ADDRESS_ID,
    SHIP_TO_ADDRESS_ID,
    LOC_BILL_TO_ADDRESS_ID,
    LOC_SHIP_TO_ADDRESS_ID,
    AWARD_ORGANIZATION_ID,
    HARD_LIMIT_FLAG ,
    INVOICE_LIMIT_FLAG , /*Bug 6642901 */
    PROPOSAL_ID ,
    BUDGET_WF_ENABLED_FLAG

  ) values (
    X_AWARD_ID,
    X_AWARD_NUMBER,
    X_AWARD_SHORT_NAME,
    X_AWARD_FULL_NAME,
    X_FUNDING_SOURCE_ID,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_CLOSE_DATE,
    X_FUNDING_SOURCE_AWARD_NUMBER,
    X_AWARD_PURPOSE_CODE,
    X_STATUS,
    X_ALLOWABLE_SCHEDULE_ID,
    X_IDC_SCHEDULE_ID,
    X_REVENUE_DISTRIBUTION_RULE,
    X_BILLING_FREQUENCY,
    X_BILLING_CYCLE_ID,
    X_BILLING_OFFSET,
    X_BILLING_DISTRIBUTION_RULE,
    X_BILLING_FORMAT,
    X_BILLING_TERM,
    X_AWARD_PROJECT_ID,
    X_AGREEMENT_ID,
    X_AWARD_TEMPLATE_FLAG,
    X_PREAWARD_DATE,
    X_AGENCY_SPECIFIC_FORM,
    X_BILL_TO_CUSTOMER_ID,
    X_TRANSACTION_NUMBER,
    X_AMOUNT_TYPE,
    X_BOUNDARY_CODE,
    X_FUND_CONTROL_LEVEL_AWARD,
    X_FUND_CONTROL_LEVEL_TASK,
    X_FUND_CONTROL_LEVEL_RES_GRP,
    X_FUND_CONTROL_LEVEL_RES,
    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_ATTRIBUTE16,
    X_ATTRIBUTE17,
    X_ATTRIBUTE18,
    X_ATTRIBUTE19,
    X_ATTRIBUTE20,
    X_ATTRIBUTE21,
    X_ATTRIBUTE22,
    X_ATTRIBUTE23,
    X_ATTRIBUTE24,
    X_ATTRIBUTE25,
    X_TEMPLATE_START_DATE_ACTIVE,
    X_TEMPLATE_END_DATE_ACTIVE,
    X_ORG_ID,
    X_TYPE,
    X_COST_IND_SCH_FIXED_DATE,
    X_LABOR_INVOICE_FORMAT_ID,
    X_NON_LABOR_INVOICE_FORMAT_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_BILL_TO_ADDRESS_ID,
    X_SHIP_TO_ADDRESS_ID,
    X_LOC_BILL_TO_ADDRESS_ID,
    X_LOC_SHIP_TO_ADDRESS_ID,
    X_AWARD_ORGANIZATION_ID,
    X_HARD_LIMIT_FLAG ,
    X_INVOICE_LIMIT_FLAG , /*Bug 6642901 */
    X_PROPOSAL_ID,
   X_BUDGET_WF_ENABLED_FLAG
  );
Line: 285

end INSERT_ROW;
Line: 362

  cursor c1 is select
      AWARD_NUMBER,
      AWARD_SHORT_NAME,
      AWARD_FULL_NAME,
      FUNDING_SOURCE_ID,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      CLOSE_DATE,
      FUNDING_SOURCE_AWARD_NUMBER,
      AWARD_PURPOSE_CODE,
      STATUS,
      ALLOWABLE_SCHEDULE_ID,
      IDC_SCHEDULE_ID,
      REVENUE_DISTRIBUTION_RULE,
      BILLING_FREQUENCY,
      BILLING_CYCLE_ID,
      BILLING_OFFSET,
      BILLING_DISTRIBUTION_RULE,
      BILLING_FORMAT,
      BILLING_TERM,
      AWARD_PROJECT_ID,
      AGREEMENT_ID,
      AWARD_TEMPLATE_FLAG,
      PREAWARD_DATE,
      AGENCY_SPECIFIC_FORM,
      BILL_TO_CUSTOMER_ID,
      TRANSACTION_NUMBER,
      AMOUNT_TYPE,
      BOUNDARY_CODE,
      FUND_CONTROL_LEVEL_AWARD,
      FUND_CONTROL_LEVEL_TASK,
      FUND_CONTROL_LEVEL_RES_GRP,
      FUND_CONTROL_LEVEL_RES,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20,
      ATTRIBUTE21,
      ATTRIBUTE22,
      ATTRIBUTE23,
      ATTRIBUTE24,
      ATTRIBUTE25,
      TEMPLATE_START_DATE_ACTIVE,
      TEMPLATE_END_DATE_ACTIVE,
      ORG_ID,
      TYPE,
      COST_IND_SCH_FIXED_DATE,
      LABOR_INVOICE_FORMAT_ID,
      NON_LABOR_INVOICE_FORMAT_ID,
      BILL_TO_ADDRESS_ID,
      SHIP_TO_ADDRESS_ID,
      lOC_BILL_TO_ADDRESS_ID,
      LOC_SHIP_TO_ADDRESS_ID,
      AWARD_ORGANIZATION_ID,
      HARD_LIMIT_FLAG,
      INVOICE_LIMIT_FLAG /*Bug6642901 */
    from GMS_AWARDS
    where AWARD_ID = X_AWARD_ID
    for update of AWARD_ID nowait;
Line: 669

procedure UPDATE_ROW (
  X_AWARD_ID in NUMBER,
  X_AWARD_NUMBER in VARCHAR2,
  X_AWARD_SHORT_NAME in VARCHAR2,
  X_AWARD_FULL_NAME in VARCHAR2,
  X_FUNDING_SOURCE_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_CLOSE_DATE in DATE,
  X_FUNDING_SOURCE_AWARD_NUMBER in VARCHAR2,
  X_AWARD_PURPOSE_CODE in VARCHAR2,
  X_STATUS in VARCHAR2,
  X_ALLOWABLE_SCHEDULE_ID in NUMBER,
  X_IDC_SCHEDULE_ID in NUMBER,
  X_REVENUE_DISTRIBUTION_RULE in VARCHAR2,
  X_BILLING_FREQUENCY in VARCHAR2,
  X_BILLING_CYCLE_ID  IN NUMBER,
  X_BILLING_OFFSET    IN NUMBER,
  X_BILLING_DISTRIBUTION_RULE in VARCHAR2,
  X_BILLING_FORMAT in VARCHAR2,
  X_BILLING_TERM in NUMBER,
  X_AWARD_PROJECT_ID in NUMBER,
  X_AGREEMENT_ID in NUMBER,
  X_AWARD_TEMPLATE_FLAG in VARCHAR2,
  X_PREAWARD_DATE in DATE,
  X_AGENCY_SPECIFIC_FORM in VARCHAR2,
  X_BILL_TO_CUSTOMER_ID in NUMBER,
  X_TRANSACTION_NUMBER in VARCHAR2,
  X_AMOUNT_TYPE in VARCHAR2,
  X_BOUNDARY_CODE in VARCHAR2,
  X_FUND_CONTROL_LEVEL_AWARD in VARCHAR2,
  X_FUND_CONTROL_LEVEL_TASK in VARCHAR2,
  X_FUND_CONTROL_LEVEL_RES_GRP in VARCHAR2,
  X_FUND_CONTROL_LEVEL_RES in VARCHAR2,
  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_ATTRIBUTE16 in VARCHAR2,
  X_ATTRIBUTE17 in VARCHAR2,
  X_ATTRIBUTE18 in VARCHAR2,
  X_ATTRIBUTE19 in VARCHAR2,
  X_ATTRIBUTE20 in VARCHAR2,
  X_ATTRIBUTE21 in VARCHAR2,
  X_ATTRIBUTE22 in VARCHAR2,
  X_ATTRIBUTE23 in VARCHAR2,
  X_ATTRIBUTE24 in VARCHAR2,
  X_ATTRIBUTE25 in VARCHAR2,
  X_TEMPLATE_START_DATE_ACTIVE in DATE,
  X_TEMPLATE_END_DATE_ACTIVE in DATE,
 -- X_ORG_ID in NUMBER,
  X_TYPE in VARCHAR2,
  X_COST_IND_SCH_FIXED_DATE in DATE,
  X_LABOR_INVOICE_FORMAT_ID in NUMBER,
  X_NON_LABOR_INVOICE_FORMAT_ID in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_BILL_TO_ADDRESS_ID in NUMBER,
  X_SHIP_TO_ADDRESS_ID in NUMBER,
  X_LOC_BILL_TO_ADDRESS_ID in NUMBER,
  X_LOC_SHIP_TO_ADDRESS_ID in NUMBER,
  X_AWARD_ORGANIZATION_ID in NUMBER,
  X_HARD_LIMIT_FLAG in VARCHAR2  ,
  X_INVOICE_LIMIT_FLAG in VARCHAR2 , /*Bug 6445688 */
  X_BUDGET_WF_ENABLED_FLAG in VARCHAR2
  ) is
    X_LAST_UPDATE_DATE DATE;
Line: 747

    X_LAST_UPDATED_BY NUMBER;
Line: 748

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 750

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 752

    X_LAST_UPDATED_BY := 1;
Line: 753

    X_LAST_UPDATE_LOGIN := 0;
Line: 755

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 756

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 759

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 760

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 767

  update GMS_AWARDS set
    AWARD_NUMBER = X_AWARD_NUMBER,
    AWARD_SHORT_NAME = X_AWARD_SHORT_NAME,
    AWARD_FULL_NAME = X_AWARD_FULL_NAME,
    FUNDING_SOURCE_ID = X_FUNDING_SOURCE_ID,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    CLOSE_DATE = X_CLOSE_DATE,
    FUNDING_SOURCE_AWARD_NUMBER = X_FUNDING_SOURCE_AWARD_NUMBER,
    AWARD_PURPOSE_CODE = X_AWARD_PURPOSE_CODE,
    STATUS = X_STATUS,
    ALLOWABLE_SCHEDULE_ID = X_ALLOWABLE_SCHEDULE_ID,
    IDC_SCHEDULE_ID = X_IDC_SCHEDULE_ID,
    REVENUE_DISTRIBUTION_RULE = X_REVENUE_DISTRIBUTION_RULE,
    BILLING_FREQUENCY = X_BILLING_FREQUENCY,
    BILLING_CYCLE_ID  = X_BILLING_CYCLE_ID,
    BILLING_OFFSET    = X_BILLING_OFFSET,
    BILLING_DISTRIBUTION_RULE = X_BILLING_DISTRIBUTION_RULE,
    BILLING_FORMAT = X_BILLING_FORMAT,
    BILLING_TERM = X_BILLING_TERM,
    AWARD_PROJECT_ID = X_AWARD_PROJECT_ID,
    AGREEMENT_ID = X_AGREEMENT_ID,
    AWARD_TEMPLATE_FLAG = X_AWARD_TEMPLATE_FLAG,
    PREAWARD_DATE = X_PREAWARD_DATE,
    AGENCY_SPECIFIC_FORM = X_AGENCY_SPECIFIC_FORM,
    BILL_TO_CUSTOMER_ID = X_BILL_TO_CUSTOMER_ID,
    TRANSACTION_NUMBER = X_TRANSACTION_NUMBER,
    AMOUNT_TYPE = X_AMOUNT_TYPE,
    BOUNDARY_CODE = X_BOUNDARY_CODE,
    FUND_CONTROL_LEVEL_AWARD = X_FUND_CONTROL_LEVEL_AWARD,
    FUND_CONTROL_LEVEL_TASK = X_FUND_CONTROL_LEVEL_TASK,
    FUND_CONTROL_LEVEL_RES_GRP = X_FUND_CONTROL_LEVEL_RES_GRP,
    FUND_CONTROL_LEVEL_RES = X_FUND_CONTROL_LEVEL_RES,
    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,
   ATTRIBUTE16 = X_ATTRIBUTE16,
    ATTRIBUTE17 = X_ATTRIBUTE17,
    ATTRIBUTE18 = X_ATTRIBUTE18,
    ATTRIBUTE19 = X_ATTRIBUTE19,
    ATTRIBUTE20 = X_ATTRIBUTE20,
    ATTRIBUTE21 = X_ATTRIBUTE21,
    ATTRIBUTE22 = X_ATTRIBUTE22,
    ATTRIBUTE23 = X_ATTRIBUTE23,
    ATTRIBUTE24 = X_ATTRIBUTE24,
    ATTRIBUTE25 = X_ATTRIBUTE25,
    TEMPLATE_START_DATE_ACTIVE = X_TEMPLATE_START_DATE_ACTIVE,
    TEMPLATE_END_DATE_ACTIVE   = X_TEMPLATE_END_DATE_ACTIVE,
   -- ORG_ID = X_ORG_ID,
    TYPE = X_TYPE,
    COST_IND_SCH_FIXED_DATE = X_COST_IND_SCH_FIXED_DATE,
    LABOR_INVOICE_FORMAT_ID = X_LABOR_INVOICE_FORMAT_ID,
    NON_LABOR_INVOICE_FORMAT_ID = X_NON_LABOR_INVOICE_FORMAT_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    BILL_TO_ADDRESS_ID = X_BILL_TO_ADDRESS_ID,
    SHIP_TO_ADDRESS_ID = X_SHIP_TO_ADDRESS_ID,
    LOC_BILL_TO_ADDRESS_ID = X_LOC_BILL_TO_ADDRESS_ID,
    LOC_SHIP_TO_ADDRESS_ID = X_LOC_SHIP_TO_ADDRESS_ID,
    AWARD_ORGANIZATION_ID =  X_AWARD_ORGANIZATION_ID,
    HARD_LIMIT_FLAG =   X_HARD_LIMIT_FLAG ,
    INVOICE_LIMIT_FLAG =  X_INVOICE_LIMIT_FLAG , /*Bug 6445688 */
    BUDGET_WF_ENABLED_FLAG = X_BUDGET_WF_ENABLED_FLAG
  where AWARD_ID = X_AWARD_ID
  ;
Line: 849

end UPDATE_ROW;
Line: 851

procedure DELETE_ROW (
  X_AWARD_ID            IN  NUMBER,
  x_award_project_id    IN  NUMBER,
  x_agreement_id        IN  NUMBER,
  x_Award_Template_flag IN  VARCHAR2,
  x_msg_count           OUT NOCOPY NUMBER,
  RETCODE               OUT NOCOPY VARCHAR2,
  ERRBUFF               OUT NOCOPY VARCHAR2
) is
begin
     -- Added call to below API to fix bug 2355648
           GMS_AWARD_DELETE_PKG.DELETE_AWARD_DETAIL(
  				p_award_id 	      =>x_award_id ,
				p_award_project_id    =>x_award_project_id  ,
                                p_agreement_id        =>x_agreement_id   ,
                               	p_Award_Template_flag =>x_Award_Template_flag,
				p_msg_count           =>x_msg_count,
                                RETCODE	              =>RETCODE,
                                ERRBUFF	              =>ERRBUFF);
Line: 876

  delete from GMS_AWARDS
  where AWARD_ID = X_AWARD_ID;
Line: 888

             FND_MESSAGE.SET_TOKEN('PROGRAM_NAME','GMS_AWARDS_PKG: DELETE_ROW');
Line: 894

end DELETE_ROW;
Line: 902

Procedure UPDATE_AWARD_PROJECT_STATUS(
  X_award_project_id IN NUMBER,
  X_Status IN VARCHAR2
) is
begin
  update pa_projects
     set project_status_code = nvl(X_Status,'CLOSED')
   where project_id = X_award_project_id;
Line: 910

end UPDATE_AWARD_PROJECT_STATUS;