DBA Data[Home] [Help]

APPS.PA_FP_CI_MERGE dependencies on PA_CI_SUPPLIER_DETAILS

Line 13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,

13259: l_count number;
13260: l_rec_index number;
13261:
13262: TYPE supp_rec is record(
13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,
13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,

Line 13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,

13260: l_rec_index number;
13261:
13262: TYPE supp_rec is record(
13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,
13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,

Line 13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,

13261:
13262: TYPE supp_rec is record(
13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,
13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,

Line 13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,

13262: TYPE supp_rec is record(
13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,
13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,

Line 13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,

13263: CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.CI_TRANSACTION_ID%type,
13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,

Line 13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,

13264: CI_ID PA_CI_SUPPLIER_DETAILS.CI_ID%type,
13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,

Line 13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,

13265: CI_TYPE_ID PA_CI_SUPPLIER_DETAILS.CI_TYPE_ID%type,
13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,

Line 13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,

13266: CI_IMPACT_ID PA_CI_SUPPLIER_DETAILS.CI_IMPACT_ID%TYPE,
13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,

Line 13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,

13267: VENDOR_ID PA_CI_SUPPLIER_DETAILS.VENDOR_ID%TYPE,
13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,

Line 13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,

13268: PO_HEADER_ID PA_CI_SUPPLIER_DETAILS.PO_HEADER_ID%TYPE,
13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,

Line 13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,

13269: PO_LINE_ID PA_CI_SUPPLIER_DETAILS.PO_LINE_ID%TYPE,
13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,

Line 13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,

13270: CHANGE_AMOUNT PA_CI_SUPPLIER_DETAILS.CHANGE_AMOUNT%TYPE,
13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,

Line 13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,

13271: CURRENCY_CODE PA_CI_SUPPLIER_DETAILS.CURRENCY_CODE%TYPE,
13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,

Line 13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,

13272: ADJUSTED_CI_TRANSACTION_ID PA_CI_SUPPLIER_DETAILS.ADJUSTED_CI_TRANSACTION_ID%TYPE,
13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,

Line 13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,

13273: CHANGE_DESCRIPTION PA_CI_SUPPLIER_DETAILS.CHANGE_DESCRIPTION%TYPE,
13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,

Line 13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,

13274: CHANGE_TYPE PA_CI_SUPPLIER_DETAILS.CHANGE_TYPE%TYPE,
13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,

Line 13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,

13275: CREATED_BY PA_CI_SUPPLIER_DETAILS.CREATED_BY%TYPE,
13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,

Line 13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,

13276: CREATION_DATE PA_CI_SUPPLIER_DETAILS.CREATION_DATE%TYPE,
13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,

Line 13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,

13277: LAST_UPDATED_BY PA_CI_SUPPLIER_DETAILS.LAST_UPDATED_BY%TYPE,
13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,

Line 13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,

13278: LAST_UPDATE_DATE PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_DATE%TYPE,
13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,

Line 13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,

13279: LAST_UPDATE_LOGIN PA_CI_SUPPLIER_DETAILS.LAST_UPDATE_LOGIN%TYPE,
13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,

Line 13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,

13280: CHANGE_APPROVER PA_CI_SUPPLIER_DETAILS.CHANGE_APPROVER%TYPE,
13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,

Line 13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,

13281: AUDIT_HISTORY_NUMBER PA_CI_SUPPLIER_DETAILS.AUDIT_HISTORY_NUMBER%TYPE,
13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,

Line 13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,

13282: CURRENT_AUDIT_FLAG PA_CI_SUPPLIER_DETAILS.CURRENT_AUDIT_FLAG%TYPE,
13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,

Line 13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,

13283: ORIGINAL_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.ORIGINAL_SUPP_TRANS_ID%TYPE,
13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,

Line 13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,

13284: SOURCE_SUPP_TRANS_ID PA_CI_SUPPLIER_DETAILS.SOURCE_SUPP_TRANS_ID%TYPE,
13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,

Line 13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,

13285: FROM_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.FROM_CHANGE_DATE%TYPE,
13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,

Line 13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,

13286: TO_CHANGE_DATE PA_CI_SUPPLIER_DETAILS.TO_CHANGE_DATE%TYPE,
13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,

Line 13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,

13287: RAW_COST PA_CI_SUPPLIER_DETAILS.RAW_COST%TYPE,
13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,

Line 13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,

13288: BURDENED_COST PA_CI_SUPPLIER_DETAILS.BURDENED_COST%TYPE,
13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,

Line 13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,

13289: REVENUE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_RATE%TYPE,
13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,

Line 13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,

13290: REVENUE_OVERRIDE_RATE PA_CI_SUPPLIER_DETAILS.REVENUE_OVERRIDE_RATE%TYPE,
13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,

Line 13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,

13291: REVENUE PA_CI_SUPPLIER_DETAILS.REVENUE%TYPE,
13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,

Line 13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,

13292: TOTAL_REVENUE PA_CI_SUPPLIER_DETAILS.TOTAL_REVENUE%TYPE,
13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,

Line 13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,

13293: SUP_QUOTE_REF_NO PA_CI_SUPPLIER_DETAILS.SUP_QUOTE_REF_NO%TYPE,
13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,

Line 13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,

13294: TASK_ID PA_CI_SUPPLIER_DETAILS.TASK_ID%TYPE,
13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,

Line 13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,

13295: RESOURCE_LIST_MEMBER_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_LIST_MEMBER_ID%TYPE,
13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,

Line 13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,

13296: EXPENDITURE_TYPE_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE_ID%TYPE,
13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,

Line 13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,

13297: ESTIMATED_COST PA_CI_SUPPLIER_DETAILS.ESTIMATED_COST%TYPE,
13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,

Line 13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,

13298: QUOTED_COST PA_CI_SUPPLIER_DETAILS.QUOTED_COST%TYPE,
13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,

Line 13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,

13299: NEGOTIATED_COST PA_CI_SUPPLIER_DETAILS.NEGOTIATED_COST%TYPE,
13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,

Line 13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,

13300: FINAL_COST PA_CI_SUPPLIER_DETAILS.FINAL_COST%TYPE,
13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,
13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);

Line 13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,

13301: MARKUP_COST PA_CI_SUPPLIER_DETAILS.MARKUP_COST%TYPE,
13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,
13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);
13309:

Line 13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,

13302: STATUS PA_CI_SUPPLIER_DETAILS.STATUS%TYPE,
13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,
13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);
13309:
13310: TYPE supp_rec_tbl is table of supp_rec index by binary_integer;

Line 13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,

13303: EXPENDITURE_ORG_ID PA_CI_SUPPLIER_DETAILS.EXPENDITURE_ORG_ID%TYPE,
13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,
13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);
13309:
13310: TYPE supp_rec_tbl is table of supp_rec index by binary_integer;
13311:

Line 13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);

13304: CHANGE_REASON_CODE PA_CI_SUPPLIER_DETAILS.CHANGE_REASON_CODE%TYPE,
13305: QUOTE_NEGOTIATION_REFERENCE PA_CI_SUPPLIER_DETAILS.QUOTE_NEGOTIATION_REFERENCE%TYPE,
13306: NEED_BY_DATE PA_CI_SUPPLIER_DETAILS.NEED_BY_DATE%TYPE,
13307: EXPENDITURE_TYPE PA_CI_SUPPLIER_DETAILS.EXPENDITURE_TYPE%TYPE,
13308: RESOURCE_ASSIGNMENT_ID PA_CI_SUPPLIER_DETAILS.RESOURCE_ASSIGNMENT_ID%TYPE);
13309:
13310: TYPE supp_rec_tbl is table of supp_rec index by binary_integer;
13311:
13312: supp_from_tbl supp_rec_tbl;

Line 13321: select * from PA_CI_SUPPLIER_DETAILS

13317: l_budget_version_id number;
13318:
13319: CURSOR get_supp_dtls(l_ci_id_f number)
13320: is
13321: select * from PA_CI_SUPPLIER_DETAILS
13322: WHERE ci_id = l_ci_id_f;
13323:
13324:
13325: CURSOR check_supp_cost_reg_flag (ci_id_t number,ci_id_f number)

Line 13519: update pa_ci_supplier_details a

13515: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
13516: RAISE G_EXCEPTION_ERROR;
13517: END IF;
13518:
13519: update pa_ci_supplier_details a
13520: set resource_assignment_id =
13521: (select prc.resource_assignment_id
13522: from pa_resource_asgn_curr prc, pa_resource_assignments pra
13523: where prc.resource_assignment_id = pra.resource_assignment_id

Line 13588: update pa_ci_supplier_details a

13584: from pa_budget_versions
13585: where ci_id = l_ci_id_to
13586: and version_type in ('COST', 'ALL');
13587:
13588: update pa_ci_supplier_details a
13589: set (resource_assignment_id, from_change_date, to_change_date, burdened_cost) =
13590: (select prc.resource_assignment_id,
13591: nvl(a.from_change_date, pra.planning_start_date),
13592: nvl(a.to_change_date, pra.planning_end_date),