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.PA_MULTI_CURRENCY_TXN dependencies on PA_CC_IDENT

Line 1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;

1528: IF P_DEBUG_MODE THEN
1529: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before setting Array variables');
1530: END IF;
1531:
1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;

Line 1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;

1529: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before setting Array variables');
1530: END IF;
1531:
1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;

Line 1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;

1530: END IF;
1531:
1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;

Line 1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;

1531:
1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;

Line 1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;

1532: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;

Line 1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;

1533: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;

Line 1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;

1534: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;

Line 1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;

1535: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;

Line 1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;

1536: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;

Line 1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;

1537: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;

Line 1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;

1538: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;

Line 1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;

1539: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;

Line 1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;

1540: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;

Line 1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;

1541: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;

Line 1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;

1542: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;

Line 1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;

1543: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;

Line 1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;

1544: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1552: V_acct_rate_date := expenditure_item_rec.acct_rate_date;

Line 1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;

1545: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1552: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1553: V_acct_rate_type := expenditure_item_rec.acct_rate_type;

Line 1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;

1546: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1552: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1553: V_acct_rate_type := expenditure_item_rec.acct_rate_type;
1554: V_acct_exchange_rate := expenditure_item_rec.acct_exchange_rate;

Line 1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;

1547: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1548: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1549: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1550: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1551: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1552: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1553: V_acct_rate_type := expenditure_item_rec.acct_rate_type;
1554: V_acct_exchange_rate := expenditure_item_rec.acct_exchange_rate;
1555: V_projfunc_cost_rate_type := expenditure_item_rec.projfunc_cost_rate_type;

Line 1729: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;

1725: IF P_DEBUG_MODE THEN
1726: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before storing in Array ');
1727: END IF;
1728:
1729: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1730: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1731: /* This needs to be changed later bug951161 */
1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1733: 'dd-mon-yyyy hh:mi:ss');

Line 1730: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;

1726: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before storing in Array ');
1727: END IF;
1728:
1729: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1730: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1731: /* This needs to be changed later bug951161 */
1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1733: 'dd-mon-yyyy hh:mi:ss');
1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;

Line 1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,

1728:
1729: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1730: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1731: /* This needs to be changed later bug951161 */
1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1733: 'dd-mon-yyyy hh:mi:ss');
1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1736:

Line 1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;

1730: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1731: /* This needs to be changed later bug951161 */
1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1733: 'dd-mon-yyyy hh:mi:ss');
1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1736:
1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,

Line 1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;

1731: /* This needs to be changed later bug951161 */
1732: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1733: 'dd-mon-yyyy hh:mi:ss');
1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1736:
1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');

Line 1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;

1733: 'dd-mon-yyyy hh:mi:ss');
1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1736:
1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;

Line 1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,

1734: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1735: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1736:
1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1742:

Line 1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;

1736:
1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1742:
1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1744: /* This needs to be changed later bug951161 */

Line 1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;

1737: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1738: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1742:
1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1744: /* This needs to be changed later bug951161 */
1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,

Line 1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;

1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1742:
1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1744: /* This needs to be changed later bug951161 */
1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1746: 'dd-mon-yyyy hh:mi:ss');
1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;

Line 1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,

1741: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1742:
1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1744: /* This needs to be changed later bug951161 */
1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1746: 'dd-mon-yyyy hh:mi:ss');
1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1748: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1749: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;

Line 1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;

1743: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1744: /* This needs to be changed later bug951161 */
1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1746: 'dd-mon-yyyy hh:mi:ss');
1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1748: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1749: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1750: IF P_DEBUG_MODE THEN
1751: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');

Line 1748: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;

1744: /* This needs to be changed later bug951161 */
1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1746: 'dd-mon-yyyy hh:mi:ss');
1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1748: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1749: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1750: IF P_DEBUG_MODE THEN
1751: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');
1752: END IF;

Line 1749: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;

1745: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1746: 'dd-mon-yyyy hh:mi:ss');
1747: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1748: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1749: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1750: IF P_DEBUG_MODE THEN
1751: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');
1752: END IF;
1753: /*

Line 1788: PA_CC_IDENT.StatusTab(v_loop_index) := 'ADD_TRANSACTIONS_EXT_FAIL';

1784: P_MC_IC_status := v_cur_status;
1785: RAISE E_local_exception;
1786: END IF;
1787: IF ( v_cur_status > 0 ) THEN
1788: PA_CC_IDENT.StatusTab(v_loop_index) := 'ADD_TRANSACTIONS_EXT_FAIL';
1789: END IF;
1790: END IF;
1791:
1792: V_loop_index := V_loop_index + 1;

Line 1815: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');

1811: * and cross-charge code
1812: */
1813: IF V_loop_index > 0 THEN
1814: IF P_DEBUG_MODE THEN
1815: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1816: END IF;
1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,

Line 1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(

1813: IF V_loop_index > 0 THEN
1814: IF P_DEBUG_MODE THEN
1815: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1816: END IF;
1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,

Line 1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,

1814: IF P_DEBUG_MODE THEN
1815: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1816: END IF;
1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,

Line 1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,

1815: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1816: END IF;
1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,

Line 1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,

1816: END IF;
1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,

Line 1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,

1817: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,

Line 1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,

1818: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,

Line 1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,

1819: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,

Line 1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,

1820: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,

Line 1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,

1821: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,

Line 1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,

1822: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,

Line 1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,

1823: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,

Line 1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,

1824: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,

Line 1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,

1825: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,

Line 1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,

1826: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,

Line 1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,

1827: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,

Line 1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,

1828: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,

Line 1833: X_StatusTab => PA_CC_IDENT.StatusTab,

1829: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,

Line 1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,

1830: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,

Line 1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,

1831: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1839: X_Error_Stage => V_Errorstage,

Line 1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,

1832: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1839: X_Error_Stage => V_Errorstage,
1840: X_Error_Code => V_Errorcode);

Line 1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,

1833: X_StatusTab => PA_CC_IDENT.StatusTab,
1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1839: X_Error_Stage => V_Errorstage,
1840: X_Error_Code => V_Errorcode);
1841: IF P_DEBUG_MODE THEN

Line 1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,

1834: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1835: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1836: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1837: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1839: X_Error_Stage => V_Errorstage,
1840: X_Error_Code => V_Errorcode);
1841: IF P_DEBUG_MODE THEN
1842: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After Call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');

Line 1842: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After Call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');

1838: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1839: X_Error_Stage => V_Errorstage,
1840: X_Error_Code => V_Errorcode);
1841: IF P_DEBUG_MODE THEN
1842: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After Call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1843: END IF;
1844: END IF;
1845:
1846: /** To be uncommented after decing upon rates-model.

Line 1915: where expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)

1911: /* added for bug#2919885 */
1912: FOR LOOP_INDEX IN 1..V_loop_index LOOP
1913: select count(*) into l_cc_dist_count_tab(loop_index)
1914: from pa_cc_dist_lines_all
1915: where expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)
1916: and line_type = 'BL' ; /*Bug# 3184731 :Excluding line_type ='PC' here */
1917: END LOOP;
1918:
1919: /* bug 12983087 Fetching Parent EIs Cost_distributed_flag */

Line 1930: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index);

1926: l_parent_Cc_Prvdr_Org_Id(loop_index),l_parent_Cc_Recvr_Org_Id(loop_index),
1927: l_parent_Recvr_Org_Id(loop_index) from
1928: pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
1929: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
1930: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index);
1931: EXCEPTION
1932: WHEN NO_DATA_FOUND THEN
1933: l_parent_cdf_tab(loop_index) := 'N';
1934: l_parent_CCharge_Type(loop_index) := NULL;

Line 1952: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

1948:
1949: UPDATE Pa_Expenditure_Items ITEM
1950: SET ITEM.Denom_Currency_Code =
1951: DECODE(ITEM.Denom_Currency_Code, NULL,
1952: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1953: PA_CC_IDENT.DenomCurrCodeTab(loop_index),
1954: ITEM.Denom_Currency_Code),
1955: ITEM.Denom_Currency_Code),
1956:

Line 1953: PA_CC_IDENT.DenomCurrCodeTab(loop_index),

1949: UPDATE Pa_Expenditure_Items ITEM
1950: SET ITEM.Denom_Currency_Code =
1951: DECODE(ITEM.Denom_Currency_Code, NULL,
1952: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1953: PA_CC_IDENT.DenomCurrCodeTab(loop_index),
1954: ITEM.Denom_Currency_Code),
1955: ITEM.Denom_Currency_Code),
1956:
1957: ITEM.Cost_Dist_Rejection_Code =

Line 1958: PA_CC_IDENT.StatusTab(loop_index),

1954: ITEM.Denom_Currency_Code),
1955: ITEM.Denom_Currency_Code),
1956:
1957: ITEM.Cost_Dist_Rejection_Code =
1958: PA_CC_IDENT.StatusTab(loop_index),
1959:
1960: /** To be uncommented after decing upon rates-model.
1961: ** CBGA StatusTab contains the status information for the call pa_cc_identify_txn.
1962: ** ErrorStageTab contains the status information for the call GetMappedToJobs.

Line 1961: ** CBGA StatusTab contains the status information for the call pa_cc_identify_txn.

1957: ITEM.Cost_Dist_Rejection_Code =
1958: PA_CC_IDENT.StatusTab(loop_index),
1959:
1960: /** To be uncommented after decing upon rates-model.
1961: ** CBGA StatusTab contains the status information for the call pa_cc_identify_txn.
1962: ** ErrorStageTab contains the status information for the call GetMappedToJobs.
1963: ** The rejection code is set - when either of them is NOT NULL.
1964: **
1965: ** ITEM.Cost_Dist_Rejection_Code =

Line 1966: ** decode ( PA_CC_IDENT.StatusTab(loop_index), NULL,

1962: ** ErrorStageTab contains the status information for the call GetMappedToJobs.
1963: ** The rejection code is set - when either of them is NOT NULL.
1964: **
1965: ** ITEM.Cost_Dist_Rejection_Code =
1966: ** decode ( PA_CC_IDENT.StatusTab(loop_index), NULL,
1967: ** ErrorStageTab(loop_index) ,
1968: ** PA_CC_IDENT.StatusTab(loop_index)
1969: ** ),
1970: **/

Line 1968: ** PA_CC_IDENT.StatusTab(loop_index)

1964: **
1965: ** ITEM.Cost_Dist_Rejection_Code =
1966: ** decode ( PA_CC_IDENT.StatusTab(loop_index), NULL,
1967: ** ErrorStageTab(loop_index) ,
1968: ** PA_CC_IDENT.StatusTab(loop_index)
1969: ** ),
1970: **/
1971: ITEM.Burden_Cost =
1972: DECODE(ITEM.Burden_Cost,NULL,

Line 1973: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

1969: ** ),
1970: **/
1971: ITEM.Burden_Cost =
1972: DECODE(ITEM.Burden_Cost,NULL,
1973: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1974: DECODE(ITEM.System_Linkage_Function,'BTC',
1975: PA_CC_IDENT.ProjFuncRawCostTab(loop_index), /* Replaced ProjRawCostTab by ProjFuncRawCostTab for bug 3285759 */
1976: ITEM.Burden_Cost),
1977: ITEM.Burden_Cost),

Line 1975: PA_CC_IDENT.ProjFuncRawCostTab(loop_index), /* Replaced ProjRawCostTab by ProjFuncRawCostTab for bug 3285759 */

1971: ITEM.Burden_Cost =
1972: DECODE(ITEM.Burden_Cost,NULL,
1973: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1974: DECODE(ITEM.System_Linkage_Function,'BTC',
1975: PA_CC_IDENT.ProjFuncRawCostTab(loop_index), /* Replaced ProjRawCostTab by ProjFuncRawCostTab for bug 3285759 */
1976: ITEM.Burden_Cost),
1977: ITEM.Burden_Cost),
1978: ITEM.Burden_Cost),
1979: /***** Added for 3285759 */

Line 1982: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

1978: ITEM.Burden_Cost),
1979: /***** Added for 3285759 */
1980: ITEM.Project_Burdened_Cost =
1981: DECODE(ITEM.Project_Burdened_Cost,NULL,
1982: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1983: DECODE(ITEM.System_Linkage_Function,'BTC',
1984: PA_CC_IDENT.ProjRawCostTab(loop_index),
1985: ITEM.Project_Burdened_Cost),
1986: ITEM.Project_Burdened_Cost),

Line 1984: PA_CC_IDENT.ProjRawCostTab(loop_index),

1980: ITEM.Project_Burdened_Cost =
1981: DECODE(ITEM.Project_Burdened_Cost,NULL,
1982: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1983: DECODE(ITEM.System_Linkage_Function,'BTC',
1984: PA_CC_IDENT.ProjRawCostTab(loop_index),
1985: ITEM.Project_Burdened_Cost),
1986: ITEM.Project_Burdened_Cost),
1987: ITEM.Project_Burdened_Cost),
1988: /***** Added for 3285759 End */

Line 1991: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

1987: ITEM.Project_Burdened_Cost),
1988: /***** Added for 3285759 End */
1989: ITEM.Acct_Burdened_Cost =
1990: DECODE(ITEM.Acct_Burdened_Cost,NULL,
1991: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1992: DECODE(ITEM.System_Linkage_Function,'BTC',
1993: PA_CC_IDENT.AcctRawCostTab(loop_index),
1994: ITEM.Acct_Burdened_Cost),
1995: ITEM.Acct_Burdened_Cost),

Line 1993: PA_CC_IDENT.AcctRawCostTab(loop_index),

1989: ITEM.Acct_Burdened_Cost =
1990: DECODE(ITEM.Acct_Burdened_Cost,NULL,
1991: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1992: DECODE(ITEM.System_Linkage_Function,'BTC',
1993: PA_CC_IDENT.AcctRawCostTab(loop_index),
1994: ITEM.Acct_Burdened_Cost),
1995: ITEM.Acct_Burdened_Cost),
1996: ITEM.Acct_Burdened_Cost),
1997: ITEM.Raw_Cost =

Line 1999: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

1995: ITEM.Acct_Burdened_Cost),
1996: ITEM.Acct_Burdened_Cost),
1997: ITEM.Raw_Cost =
1998: DECODE(ITEM.Raw_Cost, NULL,
1999: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2000: DECODE(ITEM.System_Linkage_Function,'BTC',
2001: 0,
2002: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),
2003: ITEM.Raw_Cost),

Line 2002: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),

1998: DECODE(ITEM.Raw_Cost, NULL,
1999: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2000: DECODE(ITEM.System_Linkage_Function,'BTC',
2001: 0,
2002: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),
2003: ITEM.Raw_Cost),
2004: ITEM.Raw_Cost),
2005: ITEM.ProjFunc_Cost_Exchange_Rate =
2006: DECODE(ITEM.Raw_Cost,NULL,

Line 2007: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2003: ITEM.Raw_Cost),
2004: ITEM.Raw_Cost),
2005: ITEM.ProjFunc_Cost_Exchange_Rate =
2006: DECODE(ITEM.Raw_Cost,NULL,
2007: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2008: PA_CC_IDENT.ProjFuncRateTab(loop_index),
2009: ITEM.ProjFunc_Cost_Exchange_Rate),
2010: ITEM.ProjFunc_Cost_exchange_Rate),
2011: ITEM.projfunc_cost_rate_Date =

Line 2008: PA_CC_IDENT.ProjFuncRateTab(loop_index),

2004: ITEM.Raw_Cost),
2005: ITEM.ProjFunc_Cost_Exchange_Rate =
2006: DECODE(ITEM.Raw_Cost,NULL,
2007: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2008: PA_CC_IDENT.ProjFuncRateTab(loop_index),
2009: ITEM.ProjFunc_Cost_Exchange_Rate),
2010: ITEM.ProjFunc_Cost_exchange_Rate),
2011: ITEM.projfunc_cost_rate_Date =
2012: DECODE(ITEM.Raw_Cost,NULL,

Line 2013: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2009: ITEM.ProjFunc_Cost_Exchange_Rate),
2010: ITEM.ProjFunc_Cost_exchange_Rate),
2011: ITEM.projfunc_cost_rate_Date =
2012: DECODE(ITEM.Raw_Cost,NULL,
2013: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2014: to_date(PA_CC_IDENT.ProjFuncRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2015: ITEM.projfunc_cost_rate_Date),
2016: ITEM.projfunc_cost_rate_Date),
2017: ITEM.projfunc_cost_rate_Type =

Line 2014: to_date(PA_CC_IDENT.ProjFuncRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),

2010: ITEM.ProjFunc_Cost_exchange_Rate),
2011: ITEM.projfunc_cost_rate_Date =
2012: DECODE(ITEM.Raw_Cost,NULL,
2013: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2014: to_date(PA_CC_IDENT.ProjFuncRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2015: ITEM.projfunc_cost_rate_Date),
2016: ITEM.projfunc_cost_rate_Date),
2017: ITEM.projfunc_cost_rate_Type =
2018: DECODE(ITEM.Raw_Cost,NULL,

Line 2019: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2015: ITEM.projfunc_cost_rate_Date),
2016: ITEM.projfunc_cost_rate_Date),
2017: ITEM.projfunc_cost_rate_Type =
2018: DECODE(ITEM.Raw_Cost,NULL,
2019: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2020: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),
2021: ITEM.projfunc_cost_rate_Type),
2022: ITEM.projfunc_cost_rate_Type),
2023: ITEM.Project_Raw_Cost =

Line 2020: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),

2016: ITEM.projfunc_cost_rate_Date),
2017: ITEM.projfunc_cost_rate_Type =
2018: DECODE(ITEM.Raw_Cost,NULL,
2019: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2020: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),
2021: ITEM.projfunc_cost_rate_Type),
2022: ITEM.projfunc_cost_rate_Type),
2023: ITEM.Project_Raw_Cost =
2024: DECODE(ITEM.Project_Raw_Cost, NULL,

Line 2025: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2021: ITEM.projfunc_cost_rate_Type),
2022: ITEM.projfunc_cost_rate_Type),
2023: ITEM.Project_Raw_Cost =
2024: DECODE(ITEM.Project_Raw_Cost, NULL,
2025: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2026: DECODE(ITEM.System_Linkage_Function,'BTC',
2027: 0,
2028: PA_CC_IDENT.ProjRawCostTab(loop_index)),
2029: ITEM.Project_Raw_Cost),

Line 2028: PA_CC_IDENT.ProjRawCostTab(loop_index)),

2024: DECODE(ITEM.Project_Raw_Cost, NULL,
2025: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2026: DECODE(ITEM.System_Linkage_Function,'BTC',
2027: 0,
2028: PA_CC_IDENT.ProjRawCostTab(loop_index)),
2029: ITEM.Project_Raw_Cost),
2030: ITEM.Project_Raw_Cost),
2031: ITEM.Project_Exchange_Rate =
2032: DECODE(ITEM.Project_Raw_Cost,NULL,

Line 2033: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2029: ITEM.Project_Raw_Cost),
2030: ITEM.Project_Raw_Cost),
2031: ITEM.Project_Exchange_Rate =
2032: DECODE(ITEM.Project_Raw_Cost,NULL,
2033: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2034: PA_CC_IDENT.ProjRateTab(loop_index),
2035: ITEM.Project_Exchange_Rate),
2036: ITEM.Project_exchange_Rate),
2037: ITEM.Project_Rate_Date =

Line 2034: PA_CC_IDENT.ProjRateTab(loop_index),

2030: ITEM.Project_Raw_Cost),
2031: ITEM.Project_Exchange_Rate =
2032: DECODE(ITEM.Project_Raw_Cost,NULL,
2033: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2034: PA_CC_IDENT.ProjRateTab(loop_index),
2035: ITEM.Project_Exchange_Rate),
2036: ITEM.Project_exchange_Rate),
2037: ITEM.Project_Rate_Date =
2038: DECODE(ITEM.Project_Raw_Cost,NULL,

Line 2039: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2035: ITEM.Project_Exchange_Rate),
2036: ITEM.Project_exchange_Rate),
2037: ITEM.Project_Rate_Date =
2038: DECODE(ITEM.Project_Raw_Cost,NULL,
2039: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2040: to_date(PA_CC_IDENT.ProjRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2041: ITEM.Project_Rate_Date),
2042: ITEM.Project_Rate_Date),
2043: ITEM.Project_Rate_Type =

Line 2040: to_date(PA_CC_IDENT.ProjRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),

2036: ITEM.Project_exchange_Rate),
2037: ITEM.Project_Rate_Date =
2038: DECODE(ITEM.Project_Raw_Cost,NULL,
2039: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2040: to_date(PA_CC_IDENT.ProjRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2041: ITEM.Project_Rate_Date),
2042: ITEM.Project_Rate_Date),
2043: ITEM.Project_Rate_Type =
2044: DECODE(ITEM.Project_Raw_Cost,NULL,

Line 2045: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2041: ITEM.Project_Rate_Date),
2042: ITEM.Project_Rate_Date),
2043: ITEM.Project_Rate_Type =
2044: DECODE(ITEM.Project_Raw_Cost,NULL,
2045: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2046: PA_CC_IDENT.ProjRateTypeTab(loop_index),
2047: ITEM.Project_Rate_Type),
2048: ITEM.Project_Rate_Type),
2049: ITEM.Acct_Raw_Cost =

Line 2046: PA_CC_IDENT.ProjRateTypeTab(loop_index),

2042: ITEM.Project_Rate_Date),
2043: ITEM.Project_Rate_Type =
2044: DECODE(ITEM.Project_Raw_Cost,NULL,
2045: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2046: PA_CC_IDENT.ProjRateTypeTab(loop_index),
2047: ITEM.Project_Rate_Type),
2048: ITEM.Project_Rate_Type),
2049: ITEM.Acct_Raw_Cost =
2050: DECODE(ITEM.Acct_Raw_Cost,NULL,

Line 2051: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2047: ITEM.Project_Rate_Type),
2048: ITEM.Project_Rate_Type),
2049: ITEM.Acct_Raw_Cost =
2050: DECODE(ITEM.Acct_Raw_Cost,NULL,
2051: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2052: DECODE(ITEM.System_Linkage_Function,'BTC',
2053: 0,
2054: PA_CC_IDENT.AcctRawCostTab(loop_index)),
2055: ITEM.Acct_Raw_Cost),

Line 2054: PA_CC_IDENT.AcctRawCostTab(loop_index)),

2050: DECODE(ITEM.Acct_Raw_Cost,NULL,
2051: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2052: DECODE(ITEM.System_Linkage_Function,'BTC',
2053: 0,
2054: PA_CC_IDENT.AcctRawCostTab(loop_index)),
2055: ITEM.Acct_Raw_Cost),
2056: ITEM.Acct_Raw_Cost),
2057: ITEM.Acct_Exchange_Rate =
2058: DECODE(ITEM.Acct_Raw_Cost,NULL,

Line 2059: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2055: ITEM.Acct_Raw_Cost),
2056: ITEM.Acct_Raw_Cost),
2057: ITEM.Acct_Exchange_Rate =
2058: DECODE(ITEM.Acct_Raw_Cost,NULL,
2059: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2060: PA_CC_IDENT.AcctRateTab(loop_index),
2061: ITEM.Acct_Exchange_Rate),
2062: ITEM.Acct_Exchange_Rate),
2063: ITEM.Acct_Rate_Date =

Line 2060: PA_CC_IDENT.AcctRateTab(loop_index),

2056: ITEM.Acct_Raw_Cost),
2057: ITEM.Acct_Exchange_Rate =
2058: DECODE(ITEM.Acct_Raw_Cost,NULL,
2059: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2060: PA_CC_IDENT.AcctRateTab(loop_index),
2061: ITEM.Acct_Exchange_Rate),
2062: ITEM.Acct_Exchange_Rate),
2063: ITEM.Acct_Rate_Date =
2064: DECODE(ITEM.Acct_Raw_Cost,NULL,

Line 2065: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2061: ITEM.Acct_Exchange_Rate),
2062: ITEM.Acct_Exchange_Rate),
2063: ITEM.Acct_Rate_Date =
2064: DECODE(ITEM.Acct_Raw_Cost,NULL,
2065: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2066: to_date(PA_CC_IDENT.AcctRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2067: ITEM.Acct_Rate_Date),
2068: ITEM.Acct_Rate_Date),
2069: ITEM.Acct_Rate_Type =

Line 2066: to_date(PA_CC_IDENT.AcctRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),

2062: ITEM.Acct_Exchange_Rate),
2063: ITEM.Acct_Rate_Date =
2064: DECODE(ITEM.Acct_Raw_Cost,NULL,
2065: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2066: to_date(PA_CC_IDENT.AcctRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2067: ITEM.Acct_Rate_Date),
2068: ITEM.Acct_Rate_Date),
2069: ITEM.Acct_Rate_Type =
2070: DECODE(ITEM.Acct_Raw_Cost,NULL,

Line 2071: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2067: ITEM.Acct_Rate_Date),
2068: ITEM.Acct_Rate_Date),
2069: ITEM.Acct_Rate_Type =
2070: DECODE(ITEM.Acct_Raw_Cost,NULL,
2071: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2072: PA_CC_IDENT.AcctRateTypeTab(loop_index),
2073: ITEM.Acct_Rate_Type),
2074: ITEM.Acct_Rate_Type),
2075: ITEM.Cc_Cross_Charge_Code =

Line 2072: PA_CC_IDENT.AcctRateTypeTab(loop_index),

2068: ITEM.Acct_Rate_Date),
2069: ITEM.Acct_Rate_Type =
2070: DECODE(ITEM.Acct_Raw_Cost,NULL,
2071: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2072: PA_CC_IDENT.AcctRateTypeTab(loop_index),
2073: ITEM.Acct_Rate_Type),
2074: ITEM.Acct_Rate_Type),
2075: ITEM.Cc_Cross_Charge_Code =
2076: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932

Line 2077: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2073: ITEM.Acct_Rate_Type),
2074: ITEM.Acct_Rate_Type),
2075: ITEM.Cc_Cross_Charge_Code =
2076: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932
2077: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2078: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2079: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2080: ITEM.Cc_Cross_Charge_Type =
2081: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_CCharge_Type(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/

Line 2078: PA_CC_IDENT.CrossChargeCodeTab(loop_index),

2074: ITEM.Acct_Rate_Type),
2075: ITEM.Cc_Cross_Charge_Code =
2076: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932
2077: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2078: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2079: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2080: ITEM.Cc_Cross_Charge_Type =
2081: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_CCharge_Type(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2082: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2082: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2078: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2079: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2080: ITEM.Cc_Cross_Charge_Type =
2081: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_CCharge_Type(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2082: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2083: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2084: ITEM.Cc_Cross_Charge_Type)),
2085: ITEM.Cc_Bl_Distributed_Code =
2086: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/

Line 2083: PA_CC_IDENT.CrossChargeTypeTab(loop_index),

2079: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2080: ITEM.Cc_Cross_Charge_Type =
2081: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_CCharge_Type(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2082: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2083: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2084: ITEM.Cc_Cross_Charge_Type)),
2085: ITEM.Cc_Bl_Distributed_Code =
2086: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2087: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,

Line 2087: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,

2083: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2084: ITEM.Cc_Cross_Charge_Type)),
2085: ITEM.Cc_Bl_Distributed_Code =
2086: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2087: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2088: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',
2089: 'N',
2090: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2091: ITEM.Cc_Bl_Distributed_Code)),

Line 2088: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',

2084: ITEM.Cc_Cross_Charge_Type)),
2085: ITEM.Cc_Bl_Distributed_Code =
2086: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2087: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2088: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',
2089: 'N',
2090: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2091: ITEM.Cc_Bl_Distributed_Code)),
2092: ITEM.Cc_IC_Processed_Code =

Line 2094: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,

2090: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2091: ITEM.Cc_Bl_Distributed_Code)),
2092: ITEM.Cc_IC_Processed_Code =
2093: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2094: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2095: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'I',
2096: 'N',
2097: 'X'),
2098: ITEM.Cc_IC_processed_Code)),

Line 2095: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'I',

2091: ITEM.Cc_Bl_Distributed_Code)),
2092: ITEM.Cc_IC_Processed_Code =
2093: DECODE(l_parent_cdf_tab(loop_index),'Y','N', /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2094: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2095: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'I',
2096: 'N',
2097: 'X'),
2098: ITEM.Cc_IC_processed_Code)),
2099: ITEM.Cc_Prvdr_Organization_Id =

Line 2101: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2097: 'X'),
2098: ITEM.Cc_IC_processed_Code)),
2099: ITEM.Cc_Prvdr_Organization_Id =
2100: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Prvdr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2101: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2102: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2103: ITEM.Cc_Prvdr_Organization_Id)),
2104: ITEM.Cc_Recvr_Organization_Id =
2105: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/

Line 2102: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),

2098: ITEM.Cc_IC_processed_Code)),
2099: ITEM.Cc_Prvdr_Organization_Id =
2100: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Prvdr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2101: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2102: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2103: ITEM.Cc_Prvdr_Organization_Id)),
2104: ITEM.Cc_Recvr_Organization_Id =
2105: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2106: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2106: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2102: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2103: ITEM.Cc_Prvdr_Organization_Id)),
2104: ITEM.Cc_Recvr_Organization_Id =
2105: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2106: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2107: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2108: ITEM.Cc_Recvr_Organization_Id)),
2109: ITEM.Recvr_Org_Id =
2110: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/

Line 2107: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),

2103: ITEM.Cc_Prvdr_Organization_Id)),
2104: ITEM.Cc_Recvr_Organization_Id =
2105: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Cc_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2106: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2107: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2108: ITEM.Cc_Recvr_Organization_Id)),
2109: ITEM.Recvr_Org_Id =
2110: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2111: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2111: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

2107: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2108: ITEM.Cc_Recvr_Organization_Id)),
2109: ITEM.Recvr_Org_Id =
2110: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2111: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2112: PA_CC_IDENT.RecvrOrgIdTab(loop_index),
2113: ITEM.Recvr_Org_Id))
2114:
2115: /** To be uncommented after decing upon rates-model.

Line 2112: PA_CC_IDENT.RecvrOrgIdTab(loop_index),

2108: ITEM.Cc_Recvr_Organization_Id)),
2109: ITEM.Recvr_Org_Id =
2110: DECODE(l_parent_cdf_tab(loop_index),'Y',l_parent_Recvr_Org_Id(loop_index), /*Added Decode wrapper not to rederive if parent ei is cost distributed bug 12983087*/
2111: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2112: PA_CC_IDENT.RecvrOrgIdTab(loop_index),
2113: ITEM.Recvr_Org_Id))
2114:
2115: /** To be uncommented after decing upon rates-model.
2116: ** CBGA Updating Cost_Job_Id in EI.

Line 2122: WHERE ITEM.Expenditure_Item_Id = PA_CC_IDENT.ExpItemIdTab(loop_index);

2118: ** DECODE(ErrorStageTab(loop_index),NULL,
2119: ** CostJobIdTab(loop_index),
2120: ** ITEM.cost_job_id)
2121: **/
2122: WHERE ITEM.Expenditure_Item_Id = PA_CC_IDENT.ExpItemIdTab(loop_index);
2123:
2124: /*Code Changes for Bug No.2984871 start */
2125: P_Update_Count := SQL%ROWCOUNT;
2126: /*Code Changes for Bug No.2984871 end */

Line 2143: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)

2139: l_parent_Cc_Prvdr_Org_Id(loop_index),l_parent_Cc_Recvr_Org_Id(loop_index),
2140: l_parent_Recvr_Org_Id(loop_index)
2141: from pa_expenditure_items_all ei1,pa_expenditure_items_all ei2
2142: where ei1.expenditure_item_id = ei2.adjusted_expenditure_item_id and
2143: ei2.expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)
2144: AND ei1.Request_id = P_request_id;
2145: EXCEPTION
2146: WHEN NO_DATA_FOUND THEN
2147: l_parent_cdf_tab(loop_index) := 'N';

Line 2175: WHERE ITEM.Expenditure_Item_Id = PA_CC_IDENT.ExpItemIdTab(loop_index)

2171: ITEM.Cc_Recvr_Organization_Id =
2172: DECODE(l_parent_cdf_tab(loop_index),'S',l_parent_Cc_Recvr_Org_Id(loop_index), ITEM.Cc_Recvr_Organization_Id),
2173: ITEM.Recvr_Org_Id =
2174: DECODE(l_parent_cdf_tab(loop_index),'S',l_parent_Recvr_Org_Id(loop_index), ITEM.Recvr_Org_Id)
2175: WHERE ITEM.Expenditure_Item_Id = PA_CC_IDENT.ExpItemIdTab(loop_index)
2176: AND ITEM.adjusted_expenditure_item_id is NOT NULL;
2177:
2178: END IF;
2179: IF P_DEBUG_MODE THEN