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

Line 511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;

507:
508: l_projfunc_rate_date pa_projects_all.projfunc_bil_rate_date%type;
509: l_project_rate_date pa_projects_all.project_bil_rate_date%type;
510: p_api_name VARCHAR2(100):='CHECK_CREATE_EVENT_OK';
511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
513: l_return_status VARCHAR2(1):='Y';
514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
515: l_ret_status VARCHAR2(2000):=NULL;

Line 512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;

508: l_projfunc_rate_date pa_projects_all.projfunc_bil_rate_date%type;
509: l_project_rate_date pa_projects_all.project_bil_rate_date%type;
510: p_api_name VARCHAR2(100):='CHECK_CREATE_EVENT_OK';
511: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
513: l_return_status VARCHAR2(1):='Y';
514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
515: l_ret_status VARCHAR2(2000):=NULL;
516: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added for bug 3013137 and 3009307

Line 516: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added for bug 3013137 and 3009307

512: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
513: l_return_status VARCHAR2(1):='Y';
514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
515: l_ret_status VARCHAR2(2000):=NULL;
516: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added for bug 3013137 and 3009307
517: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added for bug 3013137 and 3009307
518:
519: BEGIN
520: --Log Message

Line 517: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added for bug 3013137 and 3009307

513: l_return_status VARCHAR2(1):='Y';
514: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
515: l_ret_status VARCHAR2(2000):=NULL;
516: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added for bug 3013137 and 3009307
517: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added for bug 3013137 and 3009307
518:
519: BEGIN
520: --Log Message
521: IF l_debug_mode = 'Y' THEN

Line 1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;

1620: ,P_event_processed OUT NOCOPY VARCHAR2) /* Added for bug 7110782 */
1621: RETURN VARCHAR2
1622: AS
1623:
1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137
1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;

Line 1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137

1621: RETURN VARCHAR2
1622: AS
1623:
1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137
1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
1629: l_return_status VARCHAR2(1):='Y';

Line 1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;

1624: l_proj_func_currency_code PA_EVENTS.projfunc_currency_code%TYPE;
1625: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; -- Added bug 3013137
1626: l_projfunc_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
1627: l_project_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
1628: l_funding_rate_type PA_EVENTS.funding_rate_type%TYPE;
1629: l_return_status VARCHAR2(1):='Y';
1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1631: l_ret_status VARCHAR2(2000):=NULL;
1632:

Line 1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307

1629: l_return_status VARCHAR2(1):='Y';
1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1631: l_ret_status VARCHAR2(2000):=NULL;
1632:
1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669

Line 1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307

1630: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
1631: l_ret_status VARCHAR2(2000):=NULL;
1632:
1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669

Line 1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669

1631: l_ret_status VARCHAR2(2000):=NULL;
1632:
1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation

Line 1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500

1632:
1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */

Line 1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669

1633: l_project_rate_type PA_EVENTS.project_rate_type%TYPE; -- Added bug 3013137 and 3009307
1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */
1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;

Line 1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669

1634: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; -- Added bug 3013137 and 3009307
1635: l_completion_date PA_EVENTS.completion_date%TYPE; --Added for bug 3053669
1636: l_revenue_amount PA_EVENTS.bill_trans_rev_amount%TYPE; --Added for bug 3053669;Chgd the type for 4027500
1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */
1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;
1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;

Line 1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;

1637: l_adjusting_revenue_flag PA_EVENTS.adjusting_revenue_flag%TYPE; --Added for bug 3053669
1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */
1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;
1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;
1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;
1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables

Line 1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;

1638: l_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE; --Added for bug 3053669
1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */
1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;
1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;
1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;
1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables
1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;

Line 1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;

1639: /*The following variable are added for bug 3053190.The varables are to used only for the validation
1640: of dates and should not be used for any other puprpose. */
1641: l_check_projfunc_rate_date PA_EVENTS.PROJFUNC_RATE_DATE %TYPE;
1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;
1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;
1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables
1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;
1647: l_old_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE;

Line 1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;

1642: l_check_project_rate_date PA_EVENTS.PROJECT_RATE_DATE % TYPE;
1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;
1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables
1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;
1647: l_old_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE;
1648: l_event_date PA_EVENTS.completion_date%TYPE;
1649:
1650: BEGIN

Line 1647: l_old_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE;

1643: l_check_funding_rate_date PA_EVENTS.FUNDING_RATE_DATE % TYPE;
1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables
1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;
1647: l_old_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE;
1648: l_event_date PA_EVENTS.completion_date%TYPE;
1649:
1650: BEGIN
1651:

Line 1648: l_event_date PA_EVENTS.completion_date%TYPE;

1644: l_event_processed VARCHAR2(1);
1645: --For Bug 3619483 :Added following 2 variables
1646: l_old_rev_amount PA_EVENTS.bill_trans_rev_amount%TYPE;
1647: l_old_bill_amount PA_EVENTS.bill_trans_bill_amount%TYPE;
1648: l_event_date PA_EVENTS.completion_date%TYPE;
1649:
1650: BEGIN
1651:
1652: --Log Message

Line 1683: FROM PA_EVENTS

1679: BEGIN
1680:
1681: SELECT deliverable_id
1682: INTO l_deliverable_id
1683: FROM PA_EVENTS
1684: WHERE EVENT_ID=P_event_in_rec.P_event_id
1685: AND deliverable_id IS NULL;
1686:
1687: EXCEPTION

Line 1852: from pa_events

1848: Else
1849: /* x_task_id:=NULL; */
1850: select task_id
1851: into x_task_id
1852: from pa_events
1853: where event_id = P_event_in_rec.P_event_id;
1854: End If;
1855: --Log Message
1856: IF l_debug_mode = 'Y' THEN

Line 1900: from pa_events

1896: P_event_in_rec.P_customer_number IS NULL )
1897: Then
1898: select agreement_id
1899: into x_agreement_id
1900: from pa_events
1901: where event_id = P_event_in_rec.P_event_id;
1902: else
1903: if
1904: (P_event_in_rec.P_agreement_number = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) AND

Line 1950: from pa_events

1946: IF ( P_event_in_rec.P_completion_date is NULL )
1947: Then
1948: select completion_date
1949: into l_event_date
1950: from pa_events
1951: where event_id = P_event_in_rec.P_event_id;
1952: ELSE
1953: l_event_date := P_event_in_rec.P_completion_date;
1954: END IF;

Line 2017: FROM pa_event_types t,pa_events v

2013: Else
2014: --Defaulting event_type_classification for other validations
2015: SELECT t.event_type_classification
2016: INTO p_event_type_classification
2017: FROM pa_event_types t,pa_events v
2018: WHERE v.event_id=P_event_in_rec.P_event_id
2019: AND t.event_type=v.event_type ;
2020: End If;
2021: --For Bug 3619483

Line 2056: FROM pa_events

2052: SELECT bill_trans_rev_amount,
2053: bill_trans_bill_amount
2054: INTO l_old_rev_amount,
2055: l_old_bill_amount
2056: FROM pa_events
2057: WHERE event_id = p_event_in_rec.P_event_id;
2058:
2059: IF (p_event_type_classification = 'MANUAL') THEN
2060: IF ( (g_inv_evt_fun_allowed = 'Y' ) AND

Line 2169: from pa_events ev

2165: PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE,ev.funding_rate_date,
2166: p_event_in_rec.P_funding_rate_date)
2167: into l_revenue_amount,l_bill_amount,l_completion_date,l_adjusting_revenue_flag,
2168: l_check_projfunc_rate_date,l_check_project_rate_date,l_check_funding_rate_date
2169: from pa_events ev
2170: where ev.event_id = p_event_in_rec.P_event_id;
2171:
2172:
2173: --validating the currency fields if mcb is enabled

Line 2201: FROM pa_events

2197: /* l_proj_func_currency_code:=P_proj_func_currency_code; commented for bug 3049100 */
2198:
2199: SELECT bill_trans_currency_code
2200: INTO l_proj_func_currency_code
2201: FROM pa_events
2202: WHERE event_id = P_event_in_rec.P_event_id;
2203:
2204: ElsIf PA_EVENT_UTILS.CHECK_VALID_CURR
2205: (P_bill_trans_curr =>p_event_in_rec.P_bill_trans_currency_code)='N'

Line 2575: from pa_events ev

2571: decode(p_event_in_rec.p_completion_date,NULL,ev.completion_date,P_event_in_rec.p_completion_date),
2572: decode(p_event_in_rec.P_adjusting_revenue_flag,NULL,ev.adjusting_revenue_flag,
2573: p_event_in_rec.P_adjusting_revenue_flag)
2574: into l_revenue_amount,l_bill_amount,l_completion_date,l_adjusting_revenue_flag
2575: from pa_events ev
2576: where ev.event_id = p_event_in_rec.P_event_id; */
2577:
2578: If(l_adjusting_revenue_flag Is NOT NULL
2579: AND l_adjusting_revenue_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 3025: From pa_events

3021:
3022: Cursor check_event_id
3023: Is
3024: Select 'x'
3025: From pa_events
3026: Where event_id=P_event_id;
3027: -- And pm_product_code =P_pm_product_code; /* Commented for bug 5056969 */
3028:
3029: event_id_found VARCHAR2(1);

Line 3031: l_event_id pa_events.event_id%type;

3027: -- And pm_product_code =P_pm_product_code; /* Commented for bug 5056969 */
3028:
3029: event_id_found VARCHAR2(1);
3030: l_return_status VARCHAR2(1) := 'Y';
3031: l_event_id pa_events.event_id%type;
3032:
3033: l_pm_event_reference varchar2(30) := p_pm_event_reference;
3034: l1_event_id pa_events.event_id%type := p_event_id;
3035:

Line 3034: l1_event_id pa_events.event_id%type := p_event_id;

3030: l_return_status VARCHAR2(1) := 'Y';
3031: l_event_id pa_events.event_id%type;
3032:
3033: l_pm_event_reference varchar2(30) := p_pm_event_reference;
3034: l1_event_id pa_events.event_id%type := p_event_id;
3035:
3036: BEGIN
3037: --validating that either the event reference or the event id is passed.
3038: If ( ( P_pm_event_reference IS NULL

Line 3163: FROM PA_EVENTS

3159: BEGIN
3160:
3161: SELECT pm_event_reference
3162: INTO P_pm_event_reference
3163: FROM PA_EVENTS
3164: WHERE event_id=p_event_id;
3165: Exception
3166:
3167: When others

Line 3246: FROM PA_EVENTS

3242: BEGIN
3243:
3244: SELECT deliverable_id
3245: INTO l_deliverable_id
3246: FROM PA_EVENTS
3247: WHERE EVENT_ID=P_event_id
3248: AND deliverable_id IS NULL;
3249:
3250: EXCEPTION

Line 3327: FROM pa_event_types t,pa_events v

3323: End If;
3324: --For Bug 3619483
3325: SELECT t.event_type_classification
3326: INTO p_event_type_classification
3327: FROM pa_event_types t,pa_events v
3328: WHERE v.event_id=P_event_id
3329: AND t.event_type=v.event_type ;
3330:
3331: IF ( (g_rev_evt_fun_allowed = 'N' ) AND

Line 3364: FROM pa_events

3360: SELECT bill_trans_rev_amount,
3361: bill_trans_bill_amount
3362: INTO l_rev_amount,
3363: l_bill_amount
3364: FROM pa_events
3365: WHERE event_id = P_event_id;
3366:
3367: IF (p_event_type_classification = 'MANUAL') THEN
3368: IF ( (g_inv_evt_fun_allowed = 'Y' ) AND

Line 3447: From pa_events

3443: Cursor unique_evnt_ref_curs(P_pm_product_code VARCHAR2
3444: ,P_pm_event_reference VARCHAR2)
3445: Is
3446: Select 1
3447: From pa_events
3448: Where pm_product_code=P_pm_product_code
3449: And pm_event_reference =P_pm_event_reference;
3450:
3451: l_product_code NUMBER:=NULL;

Line 3551: From pa_events

3547:
3548: cursor fetch_event_id_curs
3549: Is
3550: Select event_id
3551: From pa_events
3552: Where pm_event_reference = p_pm_event_reference
3553: And pm_product_code = p_pm_product_code;
3554:
3555: P_event_out_id NUMBER:=NULL;