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_REV_CA dependencies on PA_EVENTS

Line 35: -- If closing entries have been created then attribute10 for pa_events

31: l_count INTEGER;
32: BEGIN
33:
34: --
35: -- If closing entries have been created then attribute10 for pa_events
36: -- will be prefixed with CLOSE and they should not be reversed
37: --
38: -- If top task id is NULL then its project level check
39: --

Line 42: from pa_events e

38: -- If top task id is NULL then its project level check
39: --
40: SELECT count(*)
41: INTO l_count
42: from pa_events e
43: WHERE e.project_id = X_project_id
44: and nvl(e.task_id,0) =
45: decode(X_task_id,
46: NULL, nvl(e.task_id,0), X_task_id )

Line 50: from pa_events pe

46: NULL, nvl(e.task_id,0), X_task_id )
47: and e.attribute10 LIKE 'CLOSE%'
48: and NOT EXISTS
49: ( SELECT 'x'
50: from pa_events pe
51: WHERE pe.project_id = X_project_id
52: and nvl(pe.task_id,0) =
53: decode(X_task_id,
54: NULL, nvl(pe.task_id,0), X_task_id )

Line 123: FROM pa_events e

119: hence results in additional events getting created.
120: */
121: SELECT sum(nvl(e.bill_trans_rev_amount,0))
122: INTO cost_accrued
123: FROM pa_events e
124: where e.project_id = X_project_id
125: and nvl(e.task_id,0) =
126: decode(X_task_id,
127: NULL, nvl(e.task_id,0), X_task_id )

Line 159: FROM pa_events e

155: hence results in additional events getting created.
156: */
157: SELECT sum(nvl(e.bill_trans_rev_amount,0))
158: INTO cost_accrued
159: FROM pa_events e
160: where e.project_id = X_project_id
161: and nvl(e.task_id,0) =
162: decode(X_task_id,
163: NULL, nvl(e.task_id,0), X_task_id )

Line 193: FROM pa_events e

189: hence results in additional events getting created.
190: */
191: SELECT sum(nvl(e.bill_trans_rev_amount,0))
192: INTO cost_accrued
193: FROM pa_events e
194: where e.project_id = X_project_id
195: and nvl(e.task_id,0) =
196: decode(X_task_id,
197: NULL, nvl(e.task_id,0), X_task_id )

Line 532: -- Select the events from pa_events which have been created for closing

528: l_event_set_id VARCHAR2(150);
529: l_error_message VARCHAR2(240);
530: l_status NUMBER;
531: BEGIN
532: -- Select the events from pa_events which have been created for closing
533: -- entries.The attribute10 column will be prefixed with CLOSE
534: -- Also check if there are no reversing events already created , the
535: -- reversing events can be identified from column attribute10 prefixed
536: -- with REV and column event_num_reversed will have the number of the

Line 542: from pa_events e

538: -- For each row do the following
539: FOR r_rec IN
540: (
541: SELECT *
542: from pa_events e
543: WHERE e.project_id = X_project_id
544: and nvl(e.task_id,0) =
545: decode(X_task_id,
546: NULL, nvl(e.task_id,0), X_task_id )

Line 550: from pa_events pe

546: NULL, nvl(e.task_id,0), X_task_id )
547: and e.attribute10 LIKE 'CLOSE%'
548: and NOT EXISTS
549: ( SELECT 'x'
550: from pa_events pe
551: WHERE pe.project_id = X_project_id
552: and nvl(pe.task_id,0) =
553: decode(X_task_id,
554: NULL, nvl(pe.task_id,0), X_task_id )

Line 566: -- event_set_id is stored in attribute10 column of pa_events table

562: --
563: Event_Description := 'reversing event num = ' || r_rec.event_num;
564:
565: --
566: -- event_set_id is stored in attribute10 column of pa_events table
567: -- this helps in identifying why the event was created i.e. reversing 'REV'
568: -- closing 'CLOSE' .
569: -- event_set_id also helps in identifying the events which were created
570: -- at the same time , i.e. events for Cost Accrual , Cost WIP and Cost Accrual

Line 639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

635: /* Declaring varible for MCB2 */
636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

636: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

637: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

638: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
639: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

640: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

641: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

642: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
643: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
644: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
645: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
646: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
647: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
648: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
649: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
650: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;

817: /* Declaring varible for MCB2 */
818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;

818: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

Line 823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;

819: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

Line 824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;

820: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
821: l_revproc_rate_type pa_events.revproc_rate_type%TYPE;
822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

Line 826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;

822: l_revproc_rate_date pa_events.revproc_rate_date%TYPE;
823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;

823: l_revproc_exchange_rate pa_events.revproc_exchange_rate%TYPE;
824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

Line 828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;

824: l_invproc_currency_code pa_events.invproc_currency_code%TYPE;
825: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
826: l_invproc_rate_type pa_events.invproc_rate_type%TYPE;
827: l_invproc_rate_date pa_events.invproc_rate_date%TYPE;
828: l_invproc_exchange_rate pa_events.invproc_exchange_rate%TYPE;
829: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
830: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
831: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
832: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 852: -- of pa_events then use raw cost.

848: --
849: -- Gets the total cost WIP amount from the cost distribution lines
850: -- line_type = R , indicates raw cost lines only
851: -- If budge type = 'R' is set in the attribute15 column
852: -- of pa_events then use raw cost.
853: -- If budge type = 'B' is set in the attribute15 column
854: -- of pa_events then use burdened cost.
855: --
856: /* This is commented because now PFC and Project currency can be diffrent for MCB2 */

Line 854: -- of pa_events then use burdened cost.

850: -- line_type = R , indicates raw cost lines only
851: -- If budge type = 'R' is set in the attribute15 column
852: -- of pa_events then use raw cost.
853: -- If budge type = 'B' is set in the attribute15 column
854: -- of pa_events then use burdened cost.
855: --
856: /* This is commented because now PFC and Project currency can be diffrent for MCB2 */
857: /* l_currency_code := pa_multi_currency_txn.get_proj_curr_code_sql(X_project_id); */
858:

Line 1037: -- of pa_events then use raw cost.

1033: --
1034: -- Gets the total cost WIP amount from the cost distribution lines
1035: -- line_type = R , indicates raw cost lines only
1036: -- If budge type = 'R' is set in the attribute15 column
1037: -- of pa_events then use raw cost.
1038: -- If budge type = 'B' is set in the attribute15 column
1039: -- of pa_events then use burdened cost.
1040: --
1041: /* According to MCB2 changes this columns will be in PFC */

Line 1039: -- of pa_events then use burdened cost.

1035: -- line_type = R , indicates raw cost lines only
1036: -- If budge type = 'R' is set in the attribute15 column
1037: -- of pa_events then use raw cost.
1038: -- If budge type = 'B' is set in the attribute15 column
1039: -- of pa_events then use burdened cost.
1040: --
1041: /* According to MCB2 changes this columns will be in PFC */
1042: SELECT sum(decode(g_ca_budget_type,'R',nvl(cdl.amount,0),
1043: (nvl(cdl.burdened_cost,0)+nvl(cdl.project_burdened_change,0))))

Line 1415: -- of pa_events then use raw cost.

1411: --
1412: -- Gets the inception to-date cost incurred from the cost distribution lines
1413: -- line_type = R , indicates raw cost lines only
1414: -- If budge type = 'R' is set in the attribute15 column
1415: -- of pa_events then use raw cost.
1416: -- If budge type = 'B' is set in the attribute15 column
1417: -- of pa_events then use burdened cost.
1418: --
1419: /* According to MCB2 changes this columns will be in PFC */

Line 1417: -- of pa_events then use burdened cost.

1413: -- line_type = R , indicates raw cost lines only
1414: -- If budge type = 'R' is set in the attribute15 column
1415: -- of pa_events then use raw cost.
1416: -- If budge type = 'B' is set in the attribute15 column
1417: -- of pa_events then use burdened cost.
1418: --
1419: /* According to MCB2 changes this columns will be in PFC */
1420: SELECT sum(decode(l_ca_budget_type,'R',nvl(cdl.amount,0),
1421: (nvl(burdened_cost,0)+nvl(cdl.project_burdened_change,0))))

Line 1440: -- of pa_events then use raw cost.

1436: --
1437: -- Gets the current reporting period to-date cost incurred from the
1438: -- cost distribution lines line_type = R , indicates raw cost lines only
1439: -- If budge type = 'R' is set in the attribute15 column
1440: -- of pa_events then use raw cost.
1441: -- If budge type = 'B' is set in the attribute15 column
1442: -- of pa_events then use burdened cost.
1443: --
1444: /* According to MCB2 changes this columns will be in PFC */

Line 1442: -- of pa_events then use burdened cost.

1438: -- cost distribution lines line_type = R , indicates raw cost lines only
1439: -- If budge type = 'R' is set in the attribute15 column
1440: -- of pa_events then use raw cost.
1441: -- If budge type = 'B' is set in the attribute15 column
1442: -- of pa_events then use burdened cost.
1443: --
1444: /* According to MCB2 changes this columns will be in PFC */
1445: SELECT sum(decode(l_ca_budget_type,'R',nvl(cdl.amount,0),
1446: (nvl(burdened_cost,0)+nvl(cdl.project_burdened_change,0))))

Line 1477: FROM pa_events pe, pa_cust_event_rdl_all erdl,

1473: sum(decode(pe.event_type,l_ca_event_type,
1474: nvl(erdl.projfunc_revenue_amount,0),0))
1475: INTO l_accounted_cost_WIP_itd,
1476: l_cost_accrual_itd
1477: FROM pa_events pe, pa_cust_event_rdl_all erdl,
1478: pa_draft_revenues_all dr
1479: WHERE pe.event_num = erdl.event_num
1480: AND pe.project_id = erdl.project_id
1481: AND nvl(pe.task_id,0) = nvl(erdl.task_id,0)

Line 1503: FROM pa_events pe, pa_cust_event_rdl_all erdl,

1499: sum(decode(pe.event_type,l_ca_event_type,
1500: nvl(erdl.projfunc_revenue_amount,0),0))
1501: INTO l_accounted_cost_WIP_ptd,
1502: l_cost_accrual_ptd
1503: FROM pa_events pe, pa_cust_event_rdl_all erdl,
1504: pa_draft_revenues_all dr , pa_periods pp /* Bug# 2197991 */
1505: WHERE pp.current_pa_period_flag = 'Y'
1506: -- AND TRUNC(dr.pa_date) = pp.end_date
1507: AND TRUNC(dr.pa_date) BETWEEN pp.start_date AND pp.end_date -- Modified for PA/GL period enhancements