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_FIN_PLAN_VIEW_GLOBAL dependencies on PA_PROJ_PERIODS_DENORM

Line 7721: /Begin of update pa_proj_periods_denorm/

7717:
7718:
7719:
7720: /****************************************************************************************/
7721: /*Begin of update pa_proj_periods_denorm*/
7722: /***************************************************************************************/
7723:
7724: BEGIN
7725:

Line 7773: from pa_proj_periods_denorm

7769: begin
7770:
7771: select object_id
7772: into l_element_id_pl
7773: from pa_proj_periods_denorm
7774: where object_type_code = 'ADJ_ELEMENTS'
7775: and amount_type_code = l_amount_type_code
7776: and amount_subtype_code = l_amount_subtype_code
7777: and budget_version_id = l_budget_version_id

Line 7783: l_stmt := 'update pa_proj_periods_denorm

7779: and currency_code = l_currency_code
7780: and currency_type = l_currency_type
7781: and object_id = l_adj_element_id_pl;
7782:
7783: l_stmt := 'update pa_proj_periods_denorm
7784: set '|| colname1|| '= :n1,'||
7785: colname2|| '= :n2,'||
7786: colname3|| '= :n3,'||
7787: colname4|| '= :n4,'||

Line 7826: l_stmt := 'insert into pa_proj_periods_denorm

7822:
7823: exception
7824: WHEN NO_DATA_FOUND THEN
7825:
7826: l_stmt := 'insert into pa_proj_periods_denorm
7827: ( CREATION_DATE,
7828: CREATED_BY,
7829: LAST_UPDATE_LOGIN,
7830: LAST_UPDATED_BY,

Line 7918: from pa_proj_periods_denorm

7914: begin
7915:
7916: select object_id
7917: into l_element_id_tl
7918: from pa_proj_periods_denorm
7919: where object_type_code = 'ADJ_ELEMENTS'
7920: and amount_type_code = l_amount_type_code
7921: and amount_subtype_code = l_amount_subtype_code
7922: and budget_version_id = l_budget_version_id

Line 7928: l_stmt := 'update pa_proj_periods_denorm

7924: and currency_code = l_currency_code
7925: and currency_type = l_currency_type
7926: and object_id = l_adj_element_id_tl;
7927:
7928: l_stmt := 'update pa_proj_periods_denorm
7929: set '|| colname1|| '= :n1,'||
7930: colname2|| '= :n2,'||
7931: colname3|| '= :n3,'||
7932: colname4|| '= :n4,'||

Line 7971: l_stmt := 'insert into pa_proj_periods_denorm

7967:
7968: exception
7969: WHEN NO_DATA_FOUND THEN
7970:
7971: l_stmt := 'insert into pa_proj_periods_denorm
7972: ( CREATION_DATE,
7973: CREATED_BY,
7974: LAST_UPDATE_LOGIN,
7975: LAST_UPDATED_BY,

Line 8065: from pa_proj_periods_denorm

8061: begin
8062:
8063: select object_id
8064: into ll_ra_id_pl
8065: from pa_proj_periods_denorm
8066: where object_type_code = 'RES_ASSIGNMENT'
8067: and amount_type_code = l_amount_type_code
8068: and amount_subtype_code = l_amount_subtype_code
8069: and budget_version_id = l_budget_version_id

Line 8075: l_stmt := 'update pa_proj_periods_denorm

8071: and currency_code = l_currency_code
8072: and currency_type = l_currency_type
8073: and object_id = l_ra_id_pl;
8074:
8075: l_stmt := 'update pa_proj_periods_denorm
8076: set '|| colname1|| '= :n1,'||
8077: colname2|| '= :n2,'||
8078: colname3|| '= :n3,'||
8079: colname4|| '= :n4,'||

Line 8119: l_stmt := 'insert into pa_proj_periods_denorm

8115:
8116: exception
8117: WHEN NO_DATA_FOUND THEN
8118:
8119: l_stmt := 'insert into pa_proj_periods_denorm
8120: ( CREATION_DATE,
8121: CREATED_BY,
8122: LAST_UPDATE_LOGIN,
8123: LAST_UPDATED_BY,

Line 8214: from pa_proj_periods_denorm

8210: begin
8211:
8212: select object_id
8213: into ll_ra_id_tl
8214: from pa_proj_periods_denorm
8215: where object_type_code = 'RES_ASSIGNMENT'
8216: and amount_type_code = l_amount_type_code
8217: and amount_subtype_code = l_amount_subtype_code
8218: and budget_version_id = l_budget_version_id

Line 8224: l_stmt := 'update pa_proj_periods_denorm

8220: and currency_code = l_currency_code
8221: and currency_type = l_currency_type
8222: and object_id = l_ra_id_tl;
8223:
8224: l_stmt := 'update pa_proj_periods_denorm
8225: set '|| colname1|| '= :n1,'||
8226: colname2|| '= :n2,'||
8227: colname3|| '= :n3,'||
8228: colname4|| '= :n4,'||

Line 8268: l_stmt := 'insert into pa_proj_periods_denorm

8264:
8265: exception
8266: WHEN NO_DATA_FOUND THEN
8267:
8268: l_stmt := 'insert into pa_proj_periods_denorm
8269: ( CREATION_DATE,
8270: CREATED_BY,
8271: LAST_UPDATE_LOGIN,
8272: LAST_UPDATED_BY,

Line 8379: from pa_proj_periods_denorm

8375: 'sum(nvl('||colname3||',0)),'||
8376: 'sum(nvl('||colname4||',0)),'||
8377: 'sum(nvl('||colname5||',0)),'||
8378: 'sum(nvl('||colname6||',0))'||'
8379: from pa_proj_periods_denorm
8380: where budget_version_id = :versionId
8381: and resource_assignment_id = :resId
8382: and object_id = :elementId
8383: and object_type_code = :elementCode

Line 8449: from pa_proj_periods_denorm

8445: 'sum(nvl('||colname3||',0)),'||
8446: 'sum(nvl('||colname4||',0)),'||
8447: 'sum(nvl('||colname5||',0)),'||
8448: 'sum(nvl('||colname6||',0))'||'
8449: from pa_proj_periods_denorm
8450: where budget_version_id = :versionId
8451: and resource_assignment_id = :resId
8452: and object_id = :elementId
8453: and object_type_code = :elementCode

Line 8507: l_stmt := 'update pa_proj_periods_denorm

8503: /* Now populate MARGIN */
8504:
8505: begin
8506:
8507: l_stmt := 'update pa_proj_periods_denorm
8508: set '|| colname1|| '= :n1,'||
8509: colname2|| '= :n2,'||
8510: colname3|| '= :n3,'||
8511: colname4|| '= :n4,'||

Line 8553: l_stmt := 'update pa_proj_periods_denorm

8549: /* Now populate the MARGIN% */
8550:
8551: begin
8552:
8553: l_stmt := 'update pa_proj_periods_denorm
8554: set '|| colname1|| '= :n1,'||
8555: colname2|| '= :n2,'||
8556: colname3|| '= :n3,'||
8557: colname4|| '= :n4,'||

Line 8650: from pa_proj_periods_denorm

8646: 'sum('||colname3||'),'||
8647: 'sum('||colname4||'),'||
8648: 'sum('||colname5||'),'||
8649: 'sum('||colname6||')'||'
8650: from pa_proj_periods_denorm
8651: where budget_version_id = :versionId
8652: and resource_assignment_id = :resId
8653: and object_id = :elementId
8654: and object_type_code = :elementCode

Line 8722: from pa_proj_periods_denorm

8718: 'sum('||colname3||'),'||
8719: 'sum('||colname4||'),'||
8720: 'sum('||colname5||'),'||
8721: 'sum('||colname6||')'||'
8722: from pa_proj_periods_denorm
8723: where budget_version_id = :versionId
8724: and resource_assignment_id = :resId
8725: and object_id = :elementId
8726: and object_type_code = :elementCode

Line 8778: l_stmt := 'update pa_proj_periods_denorm

8774: /* Now populate MARGIN */
8775:
8776: begin
8777:
8778: l_stmt := 'update pa_proj_periods_denorm
8779: set '|| colname1|| '= :n1,'||
8780: colname2|| '= :n2,'||
8781: colname3|| '= :n3,'||
8782: colname4|| '= :n4,'||

Line 8824: l_stmt := 'update pa_proj_periods_denorm

8820: /* Now populate the MARGIN% */
8821:
8822: begin
8823:
8824: l_stmt := 'update pa_proj_periods_denorm
8825: set '|| colname1|| '= :n1,'||
8826: colname2|| '= :n2,'||
8827: colname3|| '= :n3,'||
8828: colname4|| '= :n4,'||

Line 8916: from pa_proj_periods_denorm

8912: begin
8913:
8914: select object_id
8915: into l_element_id_pl
8916: from pa_proj_periods_denorm
8917: where object_type_code = 'ADJ_ELEMENTS'
8918: and amount_type_code = l_amount_type_code
8919: and amount_subtype_code = l_amount_subtype_code
8920: and budget_version_id = l_budget_version_id

Line 8926: l_stmt := 'update pa_proj_periods_denorm

8922: and currency_code = l_currency_code
8923: and currency_type = l_currency_type
8924: and object_id = l_adj_element_id_pl;
8925:
8926: l_stmt := 'update pa_proj_periods_denorm
8927: set '|| colname1|| '= :n1,'||
8928: colname2|| '= :n2,'||
8929: colname3|| '= :n3,'||
8930: colname4|| '= :n4,'||

Line 8983: l_stmt := 'insert into pa_proj_periods_denorm

8979:
8980: exception
8981: WHEN NO_DATA_FOUND THEN
8982:
8983: l_stmt := 'insert into pa_proj_periods_denorm
8984: ( CREATION_DATE,
8985: CREATED_BY,
8986: LAST_UPDATE_LOGIN,
8987: LAST_UPDATED_BY,

Line 9096: from pa_proj_periods_denorm

9092: begin
9093:
9094: select object_id
9095: into l_element_id_tl
9096: from pa_proj_periods_denorm
9097: where object_type_code = 'ADJ_ELEMENTS'
9098: and amount_type_code = l_amount_type_code
9099: and amount_subtype_code = l_amount_subtype_code
9100: and budget_version_id = l_budget_version_id

Line 9106: l_stmt := 'update pa_proj_periods_denorm

9102: and currency_code = l_currency_code
9103: and currency_type = l_currency_type
9104: and object_id = l_adj_element_id_tl;
9105:
9106: l_stmt := 'update pa_proj_periods_denorm
9107: set '|| colname1|| '= :n1,'||
9108: colname2|| '= :n2,'||
9109: colname3|| '= :n3,'||
9110: colname4|| '= :n4,'||

Line 9163: l_stmt := 'insert into pa_proj_periods_denorm

9159:
9160: exception
9161: WHEN NO_DATA_FOUND THEN
9162:
9163: l_stmt := 'insert into pa_proj_periods_denorm
9164: ( CREATION_DATE,
9165: CREATED_BY,
9166: LAST_UPDATE_LOGIN,
9167: LAST_UPDATED_BY,

Line 9278: from pa_proj_periods_denorm

9274: begin
9275:
9276: select object_id
9277: into ll_ra_id_pl
9278: from pa_proj_periods_denorm
9279: where object_type_code = 'RES_ASSIGNMENT'
9280: and amount_type_code = l_amount_type_code
9281: and amount_subtype_code = l_amount_subtype_code
9282: and budget_version_id = l_budget_version_id

Line 9288: l_stmt := 'update pa_proj_periods_denorm

9284: and currency_code = l_currency_code
9285: and currency_type = l_currency_type
9286: and object_id = l_ra_id_pl;
9287:
9288: l_stmt := 'update pa_proj_periods_denorm
9289: set '|| colname1|| '= :n1,'||
9290: colname2|| '= :n2,'||
9291: colname3|| '= :n3,'||
9292: colname4|| '= :n4,'||

Line 9346: l_stmt := 'insert into pa_proj_periods_denorm

9342:
9343: exception
9344: WHEN NO_DATA_FOUND THEN
9345:
9346: l_stmt := 'insert into pa_proj_periods_denorm
9347: ( CREATION_DATE,
9348: CREATED_BY,
9349: LAST_UPDATE_LOGIN,
9350: LAST_UPDATED_BY,

Line 9462: from pa_proj_periods_denorm

9458: begin
9459:
9460: select object_id
9461: into ll_ra_id_tl
9462: from pa_proj_periods_denorm
9463: where object_type_code = 'RES_ASSIGNMENT'
9464: and amount_type_code = l_amount_type_code
9465: and amount_subtype_code = l_amount_subtype_code
9466: and budget_version_id = l_budget_version_id

Line 9472: l_stmt := 'update pa_proj_periods_denorm

9468: and currency_code = l_currency_code
9469: and currency_type = l_currency_type
9470: and object_id = l_ra_id_tl;
9471:
9472: l_stmt := 'update pa_proj_periods_denorm
9473: set '|| colname1|| '= :n1,'||
9474: colname2|| '= :n2,'||
9475: colname3|| '= :n3,'||
9476: colname4|| '= :n4,'||

Line 9530: l_stmt := 'insert into pa_proj_periods_denorm

9526:
9527: exception
9528: WHEN NO_DATA_FOUND THEN
9529:
9530: l_stmt := 'insert into pa_proj_periods_denorm
9531: ( CREATION_DATE,
9532: CREATED_BY,
9533: LAST_UPDATE_LOGIN,
9534: LAST_UPDATED_BY,

Line 9670: from pa_proj_periods_denorm

9666: 'sum(nvl('||colname10||',0)),'||
9667: 'sum(nvl('||colname11||',0)),'||
9668: 'sum(nvl('||colname12||',0)),'||
9669: 'sum(nvl('||colname13||',0))'||'
9670: from pa_proj_periods_denorm
9671: where budget_version_id = :versionId
9672: and resource_assignment_id = :resId
9673: and object_id = :elementId
9674: and object_type_code = :elementCode

Line 9765: from pa_proj_periods_denorm

9761: 'sum(nvl('||colname10||',0)),'||
9762: 'sum(nvl('||colname11||',0)),'||
9763: 'sum(nvl('||colname12||',0)),'||
9764: 'sum(nvl('||colname13||',0))'||'
9765: from pa_proj_periods_denorm
9766: where budget_version_id = :versionId
9767: and resource_assignment_id = :resId
9768: and object_id = :elementId
9769: and object_type_code = :elementCode

Line 9841: l_stmt := 'update pa_proj_periods_denorm

9837: /* Now populate MARGIN */
9838:
9839: begin
9840:
9841: l_stmt := 'update pa_proj_periods_denorm
9842: set '|| colname1|| '= :n1,'||
9843: colname2|| '= :n2,'||
9844: colname3|| '= :n3,'||
9845: colname4|| '= :n4,'||

Line 9901: l_stmt := 'update pa_proj_periods_denorm

9897: /* Now populate the MARGIN% */
9898:
9899: begin
9900:
9901: l_stmt := 'update pa_proj_periods_denorm
9902: set '|| colname1|| '= :n1,'||
9903: colname2|| '= :n2,'||
9904: colname3|| '= :n3,'||
9905: colname4|| '= :n4,'||

Line 10065: from pa_proj_periods_denorm

10061: 'sum(nvl('||colname10||',0)),'||
10062: 'sum(nvl('||colname11||',0)),'||
10063: 'sum(nvl('||colname12||',0)),'||
10064: 'sum(nvl('||colname13||',0))'||'
10065: from pa_proj_periods_denorm
10066: where budget_version_id = :versionId
10067: and resource_assignment_id = :resId
10068: and object_id = :elementId
10069: and object_type_code = :elementCode

Line 10162: from pa_proj_periods_denorm

10158: 'sum(nvl('||colname10||',0)),'||
10159: 'sum(nvl('||colname11||',0)),'||
10160: 'sum(nvl('||colname12||',0)),'||
10161: 'sum(nvl('||colname13||',0))'||'
10162: from pa_proj_periods_denorm
10163: where budget_version_id = :versionId
10164: and resource_assignment_id = :resId
10165: and object_id = :elementId
10166: and object_type_code = :elementCode

Line 10234: l_stmt := 'update pa_proj_periods_denorm

10230: /* Now populate MARGIN */
10231:
10232: begin
10233:
10234: l_stmt := 'update pa_proj_periods_denorm
10235: set '|| colname1|| '= :n1,'||
10236: colname2|| '= :n2,'||
10237: colname3|| '= :n3,'||
10238: colname4|| '= :n4,'||

Line 10294: l_stmt := 'update pa_proj_periods_denorm

10290: /* Now populate the MARGIN% */
10291:
10292: begin
10293:
10294: l_stmt := 'update pa_proj_periods_denorm
10295: set '|| colname1|| '= :n1,'||
10296: colname2|| '= :n2,'||
10297: colname3|| '= :n3,'||
10298: colname4|| '= :n4,'||

Line 10441: /End of update pa_proj_periods_denorm/

10437:
10438: /*End update denorm table*/
10439:
10440: /****************************************************************************************/
10441: /*End of update pa_proj_periods_denorm*/
10442: /***************************************************************************************/
10443:
10444:
10445: