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 1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;

1521: IF P_DEBUG_MODE THEN
1522: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before setting Array variables');
1523: END IF;
1524:
1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;

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

1522: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before setting Array variables');
1523: END IF;
1524:
1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;

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

1523: END IF;
1524:
1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;

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

1524:
1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;

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

1525: PA_CC_IDENT.ProjectIdTab(v_loop_index) := NULL;
1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;

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

1526: PA_CC_IDENT.PrjOrganizationIdTab(v_loop_index) := NULL;
1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;

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

1527: PA_CC_IDENT.PrjOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;

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

1528: PA_CC_IDENT.PrvdrLEIdTab(v_loop_index) := NULL;
1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;

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

1529: PA_CC_IDENT.RecvrLEIdTab(v_loop_index) := NULL;
1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;

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

1530: PA_CC_IDENT.ExpItemDateTab(v_loop_index) := expenditure_item_rec.expenditure_item_date;
1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;

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

1531: PA_CC_IDENT.TaskIdTab(v_loop_index) := expenditure_item_rec.task_id;
1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;

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

1532: PA_CC_IDENT.ExpItemIdTab(v_loop_index) := expenditure_item_rec.expenditure_item_id;
1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;

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

1533: PA_CC_IDENT.ExpOrgIdTab(v_loop_index) := expenditure_item_rec.org_id;
1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;

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

1534: PA_CC_IDENT.ExpTypeTab(v_loop_index) := expenditure_item_rec.expenditure_type;
1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;

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

1535: PA_CC_IDENT.SysLinkTab(v_loop_index) := expenditure_item_rec.system_linkage_function;
1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;

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

1536: PA_CC_IDENT.TransSourceTab(v_loop_index) := expenditure_item_rec.transaction_source;
1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1544: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;

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

1537: PA_CC_IDENT.ExpOrganizationIdTab(v_loop_index) := expenditure_item_rec.exp_organization_id;
1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1544: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1545: V_acct_rate_date := expenditure_item_rec.acct_rate_date;

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

1538: PA_CC_IDENT.NLROrganizationIdTab(v_loop_index) := expenditure_item_rec.nlr_organization_id;
1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1544: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1545: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1546: V_acct_rate_type := expenditure_item_rec.acct_rate_type;

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

1539: PA_CC_IDENT.PersonIdTab(v_loop_index) := expenditure_item_rec.incurred_by_person_id;
1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1544: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1545: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1546: V_acct_rate_type := expenditure_item_rec.acct_rate_type;
1547: V_acct_exchange_rate := expenditure_item_rec.acct_exchange_rate;

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

1540: PA_CC_IDENT.CrossChargeTypeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_type;
1541: PA_CC_IDENT.CrossChargeCodeTab(v_loop_index) := expenditure_item_rec.cc_cross_charge_code;
1542: PA_CC_IDENT.PrvdrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_prvdr_organization_id;
1543: PA_CC_IDENT.RecvrOrganizationIdTab(v_loop_index):= expenditure_item_rec.cc_recvr_organization_id;
1544: PA_CC_IDENT.RecvrOrgIdTab(v_loop_index) := expenditure_item_rec.recvr_org_id;
1545: V_acct_rate_date := expenditure_item_rec.acct_rate_date;
1546: V_acct_rate_type := expenditure_item_rec.acct_rate_type;
1547: V_acct_exchange_rate := expenditure_item_rec.acct_exchange_rate;
1548: V_projfunc_cost_rate_type := expenditure_item_rec.projfunc_cost_rate_type;

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

1718: IF P_DEBUG_MODE THEN
1719: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before storing in Array ');
1720: END IF;
1721:
1722: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1723: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1724: /* This needs to be changed later bug951161 */
1725: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1726: 'dd-mon-yyyy hh:mi:ss');

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

1719: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before storing in Array ');
1720: END IF;
1721:
1722: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1723: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1724: /* This needs to be changed later bug951161 */
1725: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1726: 'dd-mon-yyyy hh:mi:ss');
1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;

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

1721:
1722: PA_CC_IDENT.DenomCurrCodeTab(v_loop_index) := expenditure_item_rec.denom_currency_code;
1723: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1724: /* This needs to be changed later bug951161 */
1725: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1726: 'dd-mon-yyyy hh:mi:ss');
1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1728: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1729:

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

1723: PA_CC_IDENT.AcctRawCostTab(v_loop_index) := V_acct_raw_cost;
1724: /* This needs to be changed later bug951161 */
1725: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1726: 'dd-mon-yyyy hh:mi:ss');
1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1728: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1729:
1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,

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

1724: /* This needs to be changed later bug951161 */
1725: PA_CC_IDENT.AcctRateDateTab(v_loop_index) := to_char(V_acct_rate_date,
1726: 'dd-mon-yyyy hh:mi:ss');
1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1728: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1729:
1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1732: 'dd-mon-yyyy hh:mi:ss');

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

1726: 'dd-mon-yyyy hh:mi:ss');
1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1728: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1729:
1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1732: 'dd-mon-yyyy hh:mi:ss');
1733: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;

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

1727: PA_CC_IDENT.AcctRateTypeTab(v_loop_index) := V_acct_rate_type;
1728: PA_CC_IDENT.AcctRateTab(v_loop_index) := V_acct_exchange_rate;
1729:
1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1732: 'dd-mon-yyyy hh:mi:ss');
1733: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1735:

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

1729:
1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1732: 'dd-mon-yyyy hh:mi:ss');
1733: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1735:
1736: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1737: /* This needs to be changed later bug951161 */

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

1730: PA_CC_IDENT.ProjFuncRawCostTab(v_loop_index) := V_projfunc_raw_cost;
1731: PA_CC_IDENT.ProjFuncRateDateTab(v_loop_index) := to_char(V_projfunc_cost_rate_date,
1732: 'dd-mon-yyyy hh:mi:ss');
1733: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1735:
1736: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1737: /* This needs to be changed later bug951161 */
1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,

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

1732: 'dd-mon-yyyy hh:mi:ss');
1733: PA_CC_IDENT.ProjFuncRateTypeTab(v_loop_index) := V_projfunc_cost_rate_type;
1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1735:
1736: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1737: /* This needs to be changed later bug951161 */
1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;

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

1734: PA_CC_IDENT.ProjFuncRateTab(v_loop_index) := V_projfunc_cost_exchange_rate;
1735:
1736: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1737: /* This needs to be changed later bug951161 */
1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1741: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1742: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;

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

1736: PA_CC_IDENT.ProjRawCostTab(v_loop_index) := V_project_raw_cost;
1737: /* This needs to be changed later bug951161 */
1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1741: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1742: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1743: IF P_DEBUG_MODE THEN
1744: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');

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

1737: /* This needs to be changed later bug951161 */
1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1741: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1742: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1743: IF P_DEBUG_MODE THEN
1744: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');
1745: END IF;

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

1738: PA_CC_IDENT.ProjRateDateTab(v_loop_index) := to_char(V_project_rate_date,
1739: 'dd-mon-yyyy hh:mi:ss');
1740: PA_CC_IDENT.ProjRateTypeTab(v_loop_index) := V_project_rate_type;
1741: PA_CC_IDENT.ProjRateTab(v_loop_index) := V_project_exchange_rate;
1742: PA_CC_IDENT.StatusTab(v_loop_index) := V_status;
1743: IF P_DEBUG_MODE THEN
1744: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After storing in Array ');
1745: END IF;
1746: /*

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

1777: P_MC_IC_status := v_cur_status;
1778: RAISE E_local_exception;
1779: END IF;
1780: IF ( v_cur_status > 0 ) THEN
1781: PA_CC_IDENT.StatusTab(v_loop_index) := 'ADD_TRANSACTIONS_EXT_FAIL';
1782: END IF;
1783: END IF;
1784:
1785: V_loop_index := V_loop_index + 1;

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

1804: * and cross-charge code
1805: */
1806: IF V_loop_index > 0 THEN
1807: IF P_DEBUG_MODE THEN
1808: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1809: END IF;
1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,

Line 1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(

1806: IF V_loop_index > 0 THEN
1807: IF P_DEBUG_MODE THEN
1808: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1809: END IF;
1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,

Line 1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,

1807: IF P_DEBUG_MODE THEN
1808: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1809: END IF;
1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,

Line 1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,

1808: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'Before call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1809: END IF;
1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,

Line 1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,

1809: END IF;
1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,

Line 1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,

1810: PA_CC_IDENT.PA_CC_IDENTIFY_TXN(
1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,

Line 1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,

1811: P_ExpOrganizationIdTab => PA_CC_IDENT.ExpOrganizationIdTab,
1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,

Line 1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,

1812: P_ExpOrgIdTab => PA_CC_IDENT.ExpOrgIdTab,
1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,

Line 1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,

1813: P_ProjectIdTab => PA_CC_IDENT.ProjectIdTab,
1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,

Line 1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,

1814: P_TaskIdTab => PA_CC_IDENT.TaskIdTab,
1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,

Line 1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,

1815: P_ExpItemDateTab => PA_CC_IDENT.ExpItemDateTab,
1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,

Line 1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,

1816: P_ExpItemIdTab => PA_CC_IDENT.ExpItemIdTab,
1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,

Line 1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,

1817: P_PersonIdTab => PA_CC_IDENT.PersonIdTab,
1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,

Line 1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,

1818: P_ExpTypeTab => PA_CC_IDENT.ExpTypeTab,
1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,

Line 1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,

1819: P_SysLinkTab => PA_CC_IDENT.SysLinkTab,
1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,

Line 1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,

1820: P_PrjOrganizationIdTab => PA_CC_IDENT.PrjOrganizationIdTab,
1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,

Line 1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,

1821: P_PrjOrgIdTab => PA_CC_IDENT.PrjOrgIdTab,
1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,

Line 1826: X_StatusTab => PA_CC_IDENT.StatusTab,

1822: P_TransSourceTab => PA_CC_IDENT.TransSourceTab,
1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,

Line 1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,

1823: P_NLROrganizationIdTab => PA_CC_IDENT.NLROrganizationIdTab,
1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,

Line 1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,

1824: P_PrvdrLEIdTab => PA_CC_IDENT.PrvdrLEIdTab,
1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1832: X_Error_Stage => V_Errorstage,

Line 1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,

1825: P_RecvrLEIdTab => PA_CC_IDENT.RecvrLEIdTab,
1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1832: X_Error_Stage => V_Errorstage,
1833: X_Error_Code => V_Errorcode);

Line 1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,

1826: X_StatusTab => PA_CC_IDENT.StatusTab,
1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1832: X_Error_Stage => V_Errorstage,
1833: X_Error_Code => V_Errorcode);
1834: IF P_DEBUG_MODE THEN

Line 1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,

1827: X_CrossChargeTypeTab => PA_CC_IDENT.CrossChargeTypeTab,
1828: X_CrossChargeCodeTab => PA_CC_IDENT.CrossChargeCodeTab,
1829: X_PrvdrOrganizationIdTab => PA_CC_IDENT.PrvdrOrganizationIdTab,
1830: X_RecvrOrganizationIdTab => PA_CC_IDENT.RecvrOrganizationIdTab,
1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1832: X_Error_Stage => V_Errorstage,
1833: X_Error_Code => V_Errorcode);
1834: IF P_DEBUG_MODE THEN
1835: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After Call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');

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

1831: X_RecvrOrgIdTab => PA_CC_IDENT.RecvrOrgIdTab,
1832: X_Error_Stage => V_Errorstage,
1833: X_Error_Code => V_Errorcode);
1834: IF P_DEBUG_MODE THEN
1835: pa_cc_utils.log_message('Perform_MC_and_IC_processing: ' || 'After Call to PA_CC_IDENT.PA_CC_IDENTIFY_TXN');
1836: END IF;
1837: END IF;
1838:
1839: /** To be uncommented after decing upon rates-model.

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

1904: /* added for bug#2919885 */
1905: FOR LOOP_INDEX IN 1..V_loop_index LOOP
1906: select count(*) into l_cc_dist_count_tab(loop_index)
1907: from pa_cc_dist_lines_all
1908: where expenditure_item_id = PA_CC_IDENT.ExpItemIdTab(loop_index)
1909: and line_type = 'BL' ; /*Bug# 3184731 :Excluding line_type ='PC' here */
1910: END LOOP;
1911:
1912:

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

1915:
1916: UPDATE Pa_Expenditure_Items ITEM
1917: SET ITEM.Denom_Currency_Code =
1918: DECODE(ITEM.Denom_Currency_Code, NULL,
1919: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1920: PA_CC_IDENT.DenomCurrCodeTab(loop_index),
1921: ITEM.Denom_Currency_Code),
1922: ITEM.Denom_Currency_Code),
1923:

Line 1920: PA_CC_IDENT.DenomCurrCodeTab(loop_index),

1916: UPDATE Pa_Expenditure_Items ITEM
1917: SET ITEM.Denom_Currency_Code =
1918: DECODE(ITEM.Denom_Currency_Code, NULL,
1919: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1920: PA_CC_IDENT.DenomCurrCodeTab(loop_index),
1921: ITEM.Denom_Currency_Code),
1922: ITEM.Denom_Currency_Code),
1923:
1924: ITEM.Cost_Dist_Rejection_Code =

Line 1925: PA_CC_IDENT.StatusTab(loop_index),

1921: ITEM.Denom_Currency_Code),
1922: ITEM.Denom_Currency_Code),
1923:
1924: ITEM.Cost_Dist_Rejection_Code =
1925: PA_CC_IDENT.StatusTab(loop_index),
1926:
1927: /** To be uncommented after decing upon rates-model.
1928: ** CBGA StatusTab contains the status information for the call pa_cc_identify_txn.
1929: ** ErrorStageTab contains the status information for the call GetMappedToJobs.

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

1924: ITEM.Cost_Dist_Rejection_Code =
1925: PA_CC_IDENT.StatusTab(loop_index),
1926:
1927: /** To be uncommented after decing upon rates-model.
1928: ** CBGA StatusTab contains the status information for the call pa_cc_identify_txn.
1929: ** ErrorStageTab contains the status information for the call GetMappedToJobs.
1930: ** The rejection code is set - when either of them is NOT NULL.
1931: **
1932: ** ITEM.Cost_Dist_Rejection_Code =

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

1929: ** ErrorStageTab contains the status information for the call GetMappedToJobs.
1930: ** The rejection code is set - when either of them is NOT NULL.
1931: **
1932: ** ITEM.Cost_Dist_Rejection_Code =
1933: ** decode ( PA_CC_IDENT.StatusTab(loop_index), NULL,
1934: ** ErrorStageTab(loop_index) ,
1935: ** PA_CC_IDENT.StatusTab(loop_index)
1936: ** ),
1937: **/

Line 1935: ** PA_CC_IDENT.StatusTab(loop_index)

1931: **
1932: ** ITEM.Cost_Dist_Rejection_Code =
1933: ** decode ( PA_CC_IDENT.StatusTab(loop_index), NULL,
1934: ** ErrorStageTab(loop_index) ,
1935: ** PA_CC_IDENT.StatusTab(loop_index)
1936: ** ),
1937: **/
1938: ITEM.Burden_Cost =
1939: DECODE(ITEM.Burden_Cost,NULL,

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

1936: ** ),
1937: **/
1938: ITEM.Burden_Cost =
1939: DECODE(ITEM.Burden_Cost,NULL,
1940: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1941: DECODE(ITEM.System_Linkage_Function,'BTC',
1942: PA_CC_IDENT.ProjFuncRawCostTab(loop_index), /* Replaced ProjRawCostTab by ProjFuncRawCostTab for bug 3285759 */
1943: ITEM.Burden_Cost),
1944: ITEM.Burden_Cost),

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

1938: ITEM.Burden_Cost =
1939: DECODE(ITEM.Burden_Cost,NULL,
1940: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1941: DECODE(ITEM.System_Linkage_Function,'BTC',
1942: PA_CC_IDENT.ProjFuncRawCostTab(loop_index), /* Replaced ProjRawCostTab by ProjFuncRawCostTab for bug 3285759 */
1943: ITEM.Burden_Cost),
1944: ITEM.Burden_Cost),
1945: ITEM.Burden_Cost),
1946: /***** Added for 3285759 */

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

1945: ITEM.Burden_Cost),
1946: /***** Added for 3285759 */
1947: ITEM.Project_Burdened_Cost =
1948: DECODE(ITEM.Project_Burdened_Cost,NULL,
1949: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1950: DECODE(ITEM.System_Linkage_Function,'BTC',
1951: PA_CC_IDENT.ProjRawCostTab(loop_index),
1952: ITEM.Project_Burdened_Cost),
1953: ITEM.Project_Burdened_Cost),

Line 1951: PA_CC_IDENT.ProjRawCostTab(loop_index),

1947: ITEM.Project_Burdened_Cost =
1948: DECODE(ITEM.Project_Burdened_Cost,NULL,
1949: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1950: DECODE(ITEM.System_Linkage_Function,'BTC',
1951: PA_CC_IDENT.ProjRawCostTab(loop_index),
1952: ITEM.Project_Burdened_Cost),
1953: ITEM.Project_Burdened_Cost),
1954: ITEM.Project_Burdened_Cost),
1955: /***** Added for 3285759 End */

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

1954: ITEM.Project_Burdened_Cost),
1955: /***** Added for 3285759 End */
1956: ITEM.Acct_Burdened_Cost =
1957: DECODE(ITEM.Acct_Burdened_Cost,NULL,
1958: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1959: DECODE(ITEM.System_Linkage_Function,'BTC',
1960: PA_CC_IDENT.AcctRawCostTab(loop_index),
1961: ITEM.Acct_Burdened_Cost),
1962: ITEM.Acct_Burdened_Cost),

Line 1960: PA_CC_IDENT.AcctRawCostTab(loop_index),

1956: ITEM.Acct_Burdened_Cost =
1957: DECODE(ITEM.Acct_Burdened_Cost,NULL,
1958: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1959: DECODE(ITEM.System_Linkage_Function,'BTC',
1960: PA_CC_IDENT.AcctRawCostTab(loop_index),
1961: ITEM.Acct_Burdened_Cost),
1962: ITEM.Acct_Burdened_Cost),
1963: ITEM.Acct_Burdened_Cost),
1964: ITEM.Raw_Cost =

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

1962: ITEM.Acct_Burdened_Cost),
1963: ITEM.Acct_Burdened_Cost),
1964: ITEM.Raw_Cost =
1965: DECODE(ITEM.Raw_Cost, NULL,
1966: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1967: DECODE(ITEM.System_Linkage_Function,'BTC',
1968: 0,
1969: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),
1970: ITEM.Raw_Cost),

Line 1969: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),

1965: DECODE(ITEM.Raw_Cost, NULL,
1966: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1967: DECODE(ITEM.System_Linkage_Function,'BTC',
1968: 0,
1969: PA_CC_IDENT.ProjFuncRawCostTab(loop_index)),
1970: ITEM.Raw_Cost),
1971: ITEM.Raw_Cost),
1972: ITEM.ProjFunc_Cost_Exchange_Rate =
1973: DECODE(ITEM.Raw_Cost,NULL,

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

1970: ITEM.Raw_Cost),
1971: ITEM.Raw_Cost),
1972: ITEM.ProjFunc_Cost_Exchange_Rate =
1973: DECODE(ITEM.Raw_Cost,NULL,
1974: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1975: PA_CC_IDENT.ProjFuncRateTab(loop_index),
1976: ITEM.ProjFunc_Cost_Exchange_Rate),
1977: ITEM.ProjFunc_Cost_exchange_Rate),
1978: ITEM.projfunc_cost_rate_Date =

Line 1975: PA_CC_IDENT.ProjFuncRateTab(loop_index),

1971: ITEM.Raw_Cost),
1972: ITEM.ProjFunc_Cost_Exchange_Rate =
1973: DECODE(ITEM.Raw_Cost,NULL,
1974: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1975: PA_CC_IDENT.ProjFuncRateTab(loop_index),
1976: ITEM.ProjFunc_Cost_Exchange_Rate),
1977: ITEM.ProjFunc_Cost_exchange_Rate),
1978: ITEM.projfunc_cost_rate_Date =
1979: DECODE(ITEM.Raw_Cost,NULL,

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

1976: ITEM.ProjFunc_Cost_Exchange_Rate),
1977: ITEM.ProjFunc_Cost_exchange_Rate),
1978: ITEM.projfunc_cost_rate_Date =
1979: DECODE(ITEM.Raw_Cost,NULL,
1980: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1981: to_date(PA_CC_IDENT.ProjFuncRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
1982: ITEM.projfunc_cost_rate_Date),
1983: ITEM.projfunc_cost_rate_Date),
1984: ITEM.projfunc_cost_rate_Type =

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

1977: ITEM.ProjFunc_Cost_exchange_Rate),
1978: ITEM.projfunc_cost_rate_Date =
1979: DECODE(ITEM.Raw_Cost,NULL,
1980: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1981: to_date(PA_CC_IDENT.ProjFuncRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
1982: ITEM.projfunc_cost_rate_Date),
1983: ITEM.projfunc_cost_rate_Date),
1984: ITEM.projfunc_cost_rate_Type =
1985: DECODE(ITEM.Raw_Cost,NULL,

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

1982: ITEM.projfunc_cost_rate_Date),
1983: ITEM.projfunc_cost_rate_Date),
1984: ITEM.projfunc_cost_rate_Type =
1985: DECODE(ITEM.Raw_Cost,NULL,
1986: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1987: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),
1988: ITEM.projfunc_cost_rate_Type),
1989: ITEM.projfunc_cost_rate_Type),
1990: ITEM.Project_Raw_Cost =

Line 1987: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),

1983: ITEM.projfunc_cost_rate_Date),
1984: ITEM.projfunc_cost_rate_Type =
1985: DECODE(ITEM.Raw_Cost,NULL,
1986: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1987: PA_CC_IDENT.ProjFuncRateTypeTab(loop_index),
1988: ITEM.projfunc_cost_rate_Type),
1989: ITEM.projfunc_cost_rate_Type),
1990: ITEM.Project_Raw_Cost =
1991: DECODE(ITEM.Project_Raw_Cost, NULL,

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

1988: ITEM.projfunc_cost_rate_Type),
1989: ITEM.projfunc_cost_rate_Type),
1990: ITEM.Project_Raw_Cost =
1991: DECODE(ITEM.Project_Raw_Cost, NULL,
1992: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1993: DECODE(ITEM.System_Linkage_Function,'BTC',
1994: 0,
1995: PA_CC_IDENT.ProjRawCostTab(loop_index)),
1996: ITEM.Project_Raw_Cost),

Line 1995: PA_CC_IDENT.ProjRawCostTab(loop_index)),

1991: DECODE(ITEM.Project_Raw_Cost, NULL,
1992: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
1993: DECODE(ITEM.System_Linkage_Function,'BTC',
1994: 0,
1995: PA_CC_IDENT.ProjRawCostTab(loop_index)),
1996: ITEM.Project_Raw_Cost),
1997: ITEM.Project_Raw_Cost),
1998: ITEM.Project_Exchange_Rate =
1999: DECODE(ITEM.Project_Raw_Cost,NULL,

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

1996: ITEM.Project_Raw_Cost),
1997: ITEM.Project_Raw_Cost),
1998: ITEM.Project_Exchange_Rate =
1999: DECODE(ITEM.Project_Raw_Cost,NULL,
2000: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2001: PA_CC_IDENT.ProjRateTab(loop_index),
2002: ITEM.Project_Exchange_Rate),
2003: ITEM.Project_exchange_Rate),
2004: ITEM.Project_Rate_Date =

Line 2001: PA_CC_IDENT.ProjRateTab(loop_index),

1997: ITEM.Project_Raw_Cost),
1998: ITEM.Project_Exchange_Rate =
1999: DECODE(ITEM.Project_Raw_Cost,NULL,
2000: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2001: PA_CC_IDENT.ProjRateTab(loop_index),
2002: ITEM.Project_Exchange_Rate),
2003: ITEM.Project_exchange_Rate),
2004: ITEM.Project_Rate_Date =
2005: DECODE(ITEM.Project_Raw_Cost,NULL,

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

2002: ITEM.Project_Exchange_Rate),
2003: ITEM.Project_exchange_Rate),
2004: ITEM.Project_Rate_Date =
2005: DECODE(ITEM.Project_Raw_Cost,NULL,
2006: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2007: to_date(PA_CC_IDENT.ProjRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2008: ITEM.Project_Rate_Date),
2009: ITEM.Project_Rate_Date),
2010: ITEM.Project_Rate_Type =

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

2003: ITEM.Project_exchange_Rate),
2004: ITEM.Project_Rate_Date =
2005: DECODE(ITEM.Project_Raw_Cost,NULL,
2006: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2007: to_date(PA_CC_IDENT.ProjRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2008: ITEM.Project_Rate_Date),
2009: ITEM.Project_Rate_Date),
2010: ITEM.Project_Rate_Type =
2011: DECODE(ITEM.Project_Raw_Cost,NULL,

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

2008: ITEM.Project_Rate_Date),
2009: ITEM.Project_Rate_Date),
2010: ITEM.Project_Rate_Type =
2011: DECODE(ITEM.Project_Raw_Cost,NULL,
2012: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2013: PA_CC_IDENT.ProjRateTypeTab(loop_index),
2014: ITEM.Project_Rate_Type),
2015: ITEM.Project_Rate_Type),
2016: ITEM.Acct_Raw_Cost =

Line 2013: PA_CC_IDENT.ProjRateTypeTab(loop_index),

2009: ITEM.Project_Rate_Date),
2010: ITEM.Project_Rate_Type =
2011: DECODE(ITEM.Project_Raw_Cost,NULL,
2012: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2013: PA_CC_IDENT.ProjRateTypeTab(loop_index),
2014: ITEM.Project_Rate_Type),
2015: ITEM.Project_Rate_Type),
2016: ITEM.Acct_Raw_Cost =
2017: DECODE(ITEM.Acct_Raw_Cost,NULL,

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

2014: ITEM.Project_Rate_Type),
2015: ITEM.Project_Rate_Type),
2016: ITEM.Acct_Raw_Cost =
2017: DECODE(ITEM.Acct_Raw_Cost,NULL,
2018: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2019: DECODE(ITEM.System_Linkage_Function,'BTC',
2020: 0,
2021: PA_CC_IDENT.AcctRawCostTab(loop_index)),
2022: ITEM.Acct_Raw_Cost),

Line 2021: PA_CC_IDENT.AcctRawCostTab(loop_index)),

2017: DECODE(ITEM.Acct_Raw_Cost,NULL,
2018: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2019: DECODE(ITEM.System_Linkage_Function,'BTC',
2020: 0,
2021: PA_CC_IDENT.AcctRawCostTab(loop_index)),
2022: ITEM.Acct_Raw_Cost),
2023: ITEM.Acct_Raw_Cost),
2024: ITEM.Acct_Exchange_Rate =
2025: DECODE(ITEM.Acct_Raw_Cost,NULL,

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

2022: ITEM.Acct_Raw_Cost),
2023: ITEM.Acct_Raw_Cost),
2024: ITEM.Acct_Exchange_Rate =
2025: DECODE(ITEM.Acct_Raw_Cost,NULL,
2026: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2027: PA_CC_IDENT.AcctRateTab(loop_index),
2028: ITEM.Acct_Exchange_Rate),
2029: ITEM.Acct_Exchange_Rate),
2030: ITEM.Acct_Rate_Date =

Line 2027: PA_CC_IDENT.AcctRateTab(loop_index),

2023: ITEM.Acct_Raw_Cost),
2024: ITEM.Acct_Exchange_Rate =
2025: DECODE(ITEM.Acct_Raw_Cost,NULL,
2026: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2027: PA_CC_IDENT.AcctRateTab(loop_index),
2028: ITEM.Acct_Exchange_Rate),
2029: ITEM.Acct_Exchange_Rate),
2030: ITEM.Acct_Rate_Date =
2031: DECODE(ITEM.Acct_Raw_Cost,NULL,

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

2028: ITEM.Acct_Exchange_Rate),
2029: ITEM.Acct_Exchange_Rate),
2030: ITEM.Acct_Rate_Date =
2031: DECODE(ITEM.Acct_Raw_Cost,NULL,
2032: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2033: to_date(PA_CC_IDENT.AcctRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2034: ITEM.Acct_Rate_Date),
2035: ITEM.Acct_Rate_Date),
2036: ITEM.Acct_Rate_Type =

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

2029: ITEM.Acct_Exchange_Rate),
2030: ITEM.Acct_Rate_Date =
2031: DECODE(ITEM.Acct_Raw_Cost,NULL,
2032: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2033: to_date(PA_CC_IDENT.AcctRateDateTab(loop_index),'dd-mm-yyyy hh:mi:ss'),
2034: ITEM.Acct_Rate_Date),
2035: ITEM.Acct_Rate_Date),
2036: ITEM.Acct_Rate_Type =
2037: DECODE(ITEM.Acct_Raw_Cost,NULL,

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

2034: ITEM.Acct_Rate_Date),
2035: ITEM.Acct_Rate_Date),
2036: ITEM.Acct_Rate_Type =
2037: DECODE(ITEM.Acct_Raw_Cost,NULL,
2038: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2039: PA_CC_IDENT.AcctRateTypeTab(loop_index),
2040: ITEM.Acct_Rate_Type),
2041: ITEM.Acct_Rate_Type),
2042: ITEM.Cc_Cross_Charge_Code =

Line 2039: PA_CC_IDENT.AcctRateTypeTab(loop_index),

2035: ITEM.Acct_Rate_Date),
2036: ITEM.Acct_Rate_Type =
2037: DECODE(ITEM.Acct_Raw_Cost,NULL,
2038: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2039: PA_CC_IDENT.AcctRateTypeTab(loop_index),
2040: ITEM.Acct_Rate_Type),
2041: ITEM.Acct_Rate_Type),
2042: ITEM.Cc_Cross_Charge_Code =
2043: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932

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

2040: ITEM.Acct_Rate_Type),
2041: ITEM.Acct_Rate_Type),
2042: ITEM.Cc_Cross_Charge_Code =
2043: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932
2044: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2045: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2046: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2047: ITEM.Cc_Cross_Charge_Type =
2048: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2045: PA_CC_IDENT.CrossChargeCodeTab(loop_index),

2041: ITEM.Acct_Rate_Type),
2042: ITEM.Cc_Cross_Charge_Code =
2043: Decode(ITEM.Cc_Cross_Charge_Code,'P', -- Added Decode wrapper to update only for P case 3173932
2044: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2045: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2046: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2047: ITEM.Cc_Cross_Charge_Type =
2048: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),

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

2044: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2045: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2046: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2047: ITEM.Cc_Cross_Charge_Type =
2048: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2050: ITEM.Cc_Cross_Charge_Type),
2051: ITEM.Cc_Bl_Distributed_Code =
2052: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,

Line 2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),

2045: PA_CC_IDENT.CrossChargeCodeTab(loop_index),
2046: ITEM.Cc_Cross_Charge_Code),ITEM.Cc_Cross_Charge_Code),
2047: ITEM.Cc_Cross_Charge_Type =
2048: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2050: ITEM.Cc_Cross_Charge_Type),
2051: ITEM.Cc_Bl_Distributed_Code =
2052: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2053: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',

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

2048: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2050: ITEM.Cc_Cross_Charge_Type),
2051: ITEM.Cc_Bl_Distributed_Code =
2052: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2053: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',
2054: 'N',
2055: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2056: ITEM.Cc_Bl_Distributed_Code),

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

2049: PA_CC_IDENT.CrossChargeTypeTab(loop_index),
2050: ITEM.Cc_Cross_Charge_Type),
2051: ITEM.Cc_Bl_Distributed_Code =
2052: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2053: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'B',
2054: 'N',
2055: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2056: ITEM.Cc_Bl_Distributed_Code),
2057: ITEM.Cc_IC_Processed_Code =

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

2054: 'N',
2055: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2056: ITEM.Cc_Bl_Distributed_Code),
2057: ITEM.Cc_IC_Processed_Code =
2058: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2059: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'I',
2060: 'N',
2061: 'X'),
2062: ITEM.Cc_IC_processed_Code),

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

2055: DECODE(l_cc_dist_count_tab(loop_index),0,'X','N')), /* bug#2919885 */
2056: ITEM.Cc_Bl_Distributed_Code),
2057: ITEM.Cc_IC_Processed_Code =
2058: DECODE(PA_CC_IDENT.StatusTab(loop_index), NULL,
2059: DECODE(PA_CC_IDENT.CrossChargeCodeTab(loop_index),'I',
2060: 'N',
2061: 'X'),
2062: ITEM.Cc_IC_processed_Code),
2063: ITEM.Cc_Prvdr_Organization_Id =

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

2060: 'N',
2061: 'X'),
2062: ITEM.Cc_IC_processed_Code),
2063: ITEM.Cc_Prvdr_Organization_Id =
2064: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2065: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2066: ITEM.Cc_Prvdr_Organization_Id),
2067: ITEM.Cc_Recvr_Organization_Id =
2068: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2065: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),

2061: 'X'),
2062: ITEM.Cc_IC_processed_Code),
2063: ITEM.Cc_Prvdr_Organization_Id =
2064: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2065: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2066: ITEM.Cc_Prvdr_Organization_Id),
2067: ITEM.Cc_Recvr_Organization_Id =
2068: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),

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

2064: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2065: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2066: ITEM.Cc_Prvdr_Organization_Id),
2067: ITEM.Cc_Recvr_Organization_Id =
2068: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2070: ITEM.Cc_Recvr_Organization_Id),
2071: ITEM.Recvr_Org_Id =
2072: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,

Line 2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),

2065: PA_CC_IDENT.PrvdrOrganizationIdTab(loop_index),
2066: ITEM.Cc_Prvdr_Organization_Id),
2067: ITEM.Cc_Recvr_Organization_Id =
2068: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2070: ITEM.Cc_Recvr_Organization_Id),
2071: ITEM.Recvr_Org_Id =
2072: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2073: PA_CC_IDENT.RecvrOrgIdTab(loop_index),

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

2068: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2070: ITEM.Cc_Recvr_Organization_Id),
2071: ITEM.Recvr_Org_Id =
2072: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2073: PA_CC_IDENT.RecvrOrgIdTab(loop_index),
2074: ITEM.Recvr_Org_Id)
2075:
2076: /** To be uncommented after decing upon rates-model.

Line 2073: PA_CC_IDENT.RecvrOrgIdTab(loop_index),

2069: PA_CC_IDENT.RecvrOrganizationIdTab(loop_index),
2070: ITEM.Cc_Recvr_Organization_Id),
2071: ITEM.Recvr_Org_Id =
2072: DECODE(PA_CC_IDENT.StatusTab(loop_index),NULL,
2073: PA_CC_IDENT.RecvrOrgIdTab(loop_index),
2074: ITEM.Recvr_Org_Id)
2075:
2076: /** To be uncommented after decing upon rates-model.
2077: ** CBGA Updating Cost_Job_Id in EI.

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

2079: ** DECODE(ErrorStageTab(loop_index),NULL,
2080: ** CostJobIdTab(loop_index),
2081: ** ITEM.cost_job_id)
2082: **/
2083: WHERE ITEM.Expenditure_Item_Id = PA_CC_IDENT.ExpItemIdTab(loop_index);
2084:
2085: /*Code Changes for Bug No.2984871 start */
2086: P_Update_Count := SQL%ROWCOUNT;
2087: /*Code Changes for Bug No.2984871 end */