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_BILLING dependencies on PA_PROJECTS

Line 175: l_project_type pa_projects_all.project_type%type;

171: x_error_message IN OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
172: c INTEGER;
173: row_processed INTEGER;
174: proc_stmt VARCHAR2(1000);
175: l_project_type pa_projects_all.project_type%type;
176: l_distribution_rule pa_projects_all.distribution_rule%type;
177: cursor get_procedure is
178: select be.procedure_name proc_name, bea.billing_assignment_id bea_id,
179: bea.billing_extension_id be_id, bea.top_task_id task_id,

Line 176: l_distribution_rule pa_projects_all.distribution_rule%type;

172: c INTEGER;
173: row_processed INTEGER;
174: proc_stmt VARCHAR2(1000);
175: l_project_type pa_projects_all.project_type%type;
176: l_distribution_rule pa_projects_all.distribution_rule%type;
177: cursor get_procedure is
178: select be.procedure_name proc_name, bea.billing_assignment_id bea_id,
179: bea.billing_extension_id be_id, bea.top_task_id task_id,
180: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,

Line 184: -- pa_projects p Commented for bug 3643409

180: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,
181: decode(be.percentage_reqd_flag, 'Y', nvl(bea.percentage, 0), 0)
182: percent
183: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409
184: -- pa_projects p Commented for bug 3643409
185: where -- p.project_id = x_project_id Commented for bug 3643409
186: -- and Commented for bug 3643409
187: to_date(x_rev_or_bill_date,'YYYY/MM/DD') between be.start_date_active and nvl(be.end_date_active,to_date(x_rev_or_bill_date,'YYYY/MM/DD')) --Added the condition for bug 8206153, added nvl for bug 8228460
188: and bea.active_flag = 'Y'

Line 293: FROM pa_projects_all

289:
290: /* Added below select statement for bug 3643409 */
291: SELECT project_type,distribution_rule
292: INTO l_project_type,l_distribution_rule
293: FROM pa_projects_all
294: WHERE project_id = x_project_id;
295:
296: FOR get_rec IN get_procedure LOOP
297: -- Loop for each assigned Billing Extension

Line 465: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;

461:
462: ccrev_error EXCEPTION;
463:
464: /* MCB related changes */
465: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

Line 466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;

462: ccrev_error EXCEPTION;
463:
464: /* MCB related changes */
465: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;

463:
464: /* MCB related changes */
465: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

Line 469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;

465: l_multi_currency_billing_flag pa_projects_all.MULTI_CURRENCY_BILLING_FLAG%TYPE;
466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

Line 470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

466: l_baseline_funding_flag pa_projects_all.BASELINE_FUNDING_FLAG%TYPE;
467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

Line 471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;

467: l_revproc_currency_code pa_projects_all.revproc_currency_code%TYPE;
468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;

468: l_invproc_currency_code VARCHAR2(30);
469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

Line 473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;

469: l_invproc_currency_type pa_projects_all.invproc_currency_type%TYPE;
470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

Line 474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;

470: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

Line 475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

471: l_project_bil_rate_date_code pa_projects_all.project_bil_rate_date_code%TYPE;
472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

Line 476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;

472: l_project_bil_rate_type pa_projects_all.project_bil_rate_type%TYPE;
473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

Line 477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;

473: l_project_bil_rate_date pa_projects_all.project_bil_rate_date%TYPE;
474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

Line 478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;

474: l_project_bil_exchange_rate pa_projects_all.project_bil_exchange_rate%TYPE;
475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

Line 479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;

475: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

Line 480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;

476: l_projfunc_bil_rate_date_code pa_projects_all.projfunc_bil_rate_date_code%TYPE;
477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
484: l_return_status VARCHAR2(30);

Line 481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;

477: l_projfunc_bil_rate_type pa_projects_all.projfunc_bil_rate_type%TYPE;
478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
484: l_return_status VARCHAR2(30);
485: l_msg_count NUMBER;

Line 482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;

478: l_projfunc_bil_rate_date pa_projects_all.projfunc_bil_rate_date%TYPE;
479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
484: l_return_status VARCHAR2(30);
485: l_msg_count NUMBER;
486: l_msg_data VARCHAR2(30);

Line 483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;

479: l_projfunc_bil_exchange_rate pa_projects_all.projfunc_bil_exchange_rate%TYPE;
480: l_funding_rate_date_code pa_projects_all.funding_rate_date_code%TYPE;
481: l_funding_rate_type pa_projects_all.funding_rate_type%TYPE;
482: l_funding_rate_date pa_projects_all.funding_rate_date%TYPE;
483: l_funding_exchange_rate pa_projects_all.funding_exchange_rate%TYPE;
484: l_return_status VARCHAR2(30);
485: l_msg_count NUMBER;
486: l_msg_data VARCHAR2(30);
487: /* Till Here */

Line 953: | X_proj_id : pa_projects.project_id |

949: | X_Option : I - Update Only Invoice Amounts |
950: | R - Update Only Revenue Amounts |
951: | B - Update Both Revenue/Invoice Amounts |
952: | |
953: | X_proj_id : pa_projects.project_id |
954: | X_start_proj_num : Start project Number (pa_projects.segment1) |
955: | X_end_proj_num : End project Number (pa_projects.segment1) |
956: | |
957: | |

Line 954: | X_start_proj_num : Start project Number (pa_projects.segment1) |

950: | R - Update Only Revenue Amounts |
951: | B - Update Both Revenue/Invoice Amounts |
952: | |
953: | X_proj_id : pa_projects.project_id |
954: | X_start_proj_num : Start project Number (pa_projects.segment1) |
955: | X_end_proj_num : End project Number (pa_projects.segment1) |
956: | |
957: | |
958: | Called from : PARGDR - Generate Draft Revenue |

Line 955: | X_end_proj_num : End project Number (pa_projects.segment1) |

951: | B - Update Both Revenue/Invoice Amounts |
952: | |
953: | X_proj_id : pa_projects.project_id |
954: | X_start_proj_num : Start project Number (pa_projects.segment1) |
955: | X_end_proj_num : End project Number (pa_projects.segment1) |
956: | |
957: | |
958: | Called from : PARGDR - Generate Draft Revenue |
959: | PAIGEN - Generate Draft Invoice |

Line 980: | Cursor For Selecting AND Locking PA_PROJECTS TABLE |

976:
977: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
978:
979: /*--------------------------------------------------------------------------
980: | Cursor For Selecting AND Locking PA_PROJECTS TABLE |
981: --------------------------------------------------------------------------*/
982:
983: /* CURSOR sel_proj is
984: SELECT project_id

Line 985: FROM pa_projects

981: --------------------------------------------------------------------------*/
982:
983: /* CURSOR sel_proj is
984: SELECT project_id
985: FROM pa_projects
986: WHERE ( ( nvl(X_proj_id,0) <> 0
987: AND project_id = X_proj_id )
988: OR ( nvl(X_proj_id,0) = 0
989: AND segment1 between X_start_proj_num

Line 997: FROM pa_projects

993: /* Fix for bug 3372249 Starts here */
994:
995: CURSOR sel_proj is
996: SELECT project_id,project_level_funding_flag /* added for bug 9649164 */
997: FROM pa_projects
998: WHERE project_id = X_proj_id
999: FOR UPDATE OF project_id;
1000:
1001: CURSOR sel_proj_seg is

Line 1003: FROM pa_projects

999: FOR UPDATE OF project_id;
1000:
1001: CURSOR sel_proj_seg is
1002: SELECT project_id,project_level_funding_flag /* added for bug 9649164 */
1003: FROM pa_projects
1004: WHERE segment1 between X_start_proj_num
1005: and X_end_proj_num
1006: FOR UPDATE OF project_id;
1007:

Line 1049: pa_projects p /* Added pa_projects for bug 3647592 */

1045: sum(dri.funding_revenue_amount) dri_funding_amount,dri.funding_currency_code
1046: FROM pa_draft_revenue_items dri,
1047: pa_draft_revenues dr,
1048: pa_summary_project_fundings pf,
1049: pa_projects p /* Added pa_projects for bug 3647592 */
1050: WHERE dri.project_id = dr.project_id
1051: AND dri.draft_revenue_num = dr.draft_revenue_num
1052: AND ( (nvl(pf.task_id,0) = 0 AND nvl(p.project_level_funding_flag,'N')='Y')
1053: OR dri.task_id = decode(p.project_level_funding_flag,'Y',0,pf.task_id) ) /* Added decode condition for bug 3647592 */

Line 1875: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

1871: /* Commenting the following line for bug 2638840
1872: rev_amount( j ) := to_char(l_ind_cost_denm); */
1873:
1874: /* Changes for bug 2638840 */
1875: /* Bug 2638840 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
1876: BEGIN
1877:
1878: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2724185 */
1879:

Line 1882: from pa_projects_all

1878: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2724185 */
1879:
1880: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
1881: into l_mcb_cost_flag
1882: from pa_projects_all
1883: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
1884:
1885: EXCEPTION
1886: WHEN NO_DATA_FOUND THEN

Line 2194: FROM pa_projects_all

2190: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2191:
2192: CURSOR c_sel_proj is
2193: SELECT project_id, project_level_funding_flag
2194: FROM pa_projects_all
2195: WHERE project_id = p_proj_id
2196: FOR UPDATE OF project_id;
2197:
2198: CURSOR c_sel_proj_list is

Line 2200: FROM pa_projects_all

2196: FOR UPDATE OF project_id;
2197:
2198: CURSOR c_sel_proj_list is
2199: SELECT project_id,project_level_funding_flag
2200: FROM pa_projects_all
2201: WHERE segment1 between p_start_proj_num And p_end_proj_num
2202: FOR UPDATE OF project_id;
2203:
2204: Cursor c_proj_level is