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_EVENTS

Line 81: UPDATE pa_events e

77: IS
78: BEGIN
79: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.UpdEvtFlg :');
80: PA_MCB_INVOICE_PKG.log_message('pa_billing.UpdEvtFlg Project Id :'||to_char(X_project_id));
81: UPDATE pa_events e
82: set billed_flag='Y'
83: WHERE project_id=x_project_id
84: AND billed_flag='N'
85: AND (select decode(et.event_type_classification,

Line 837: DELETE from pa_events v

833: IF g1_debug_mode = 'Y' THEN
834: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Delete_Automatic_Events :');
835: END IF;
836: IF (X_calling_Process = 'Revenue') THEN
837: DELETE from pa_events v
838: WHERE v.project_id = X_project_id
839: AND v.request_id+0 = X_request_id
840: AND (v.project_id, nvl(v.task_id, -1), v.event_num) IN
841: (SELECT l.project_id, nvl(l.task_id, -1), l.event_num

Line 858: DELETE FROM PA_EVENTS V

854: END IF;
855: ELSE
856: -- DBMS_OUTPUT.PUT_LINE('Deleting Invoice Events');
857:
858: DELETE FROM PA_EVENTS V
859: WHERE V.Project_ID = X_project_id
860: AND (nvl(V.Task_ID, -1), V.Event_Num) IN
861: (select nvl(dii.Event_Task_ID, -1), dii.Event_Num
862: from pa_draft_invoice_items dii, pa_draft_invoices di

Line 1425: PA_EVENTS E

1421: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1422: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1423: PA_DRAFT_REVENUES_ALL DR,
1424: PA_EVENT_TYPES ET,
1425: PA_EVENTS E
1426: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1427: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1428: AND E.EVENT_NUM = ERDL.EVENT_NUM
1429: AND E.TASK_ID = ERDL.TASK_ID

Line 1454: PA_EVENTS E

1450: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1451: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1452: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1453: PA_EVENT_TYPES ET,
1454: PA_EVENTS E
1455: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1456: AND E.EVENT_NUM = ERDL.EVENT_NUM
1457: AND E.TASK_ID = ERDL.TASK_ID
1458: AND ET.EVENT_TYPE = E.EVENT_TYPE

Line 1472: PA_EVENTS E

1468: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1469: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1470: x_projfunc_writeoff_amount,p_writeoff_amount
1471: FROM PA_EVENT_TYPES ET,
1472: PA_EVENTS E
1473: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1474: AND ET.EVENT_TYPE = E.EVENT_TYPE
1475: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1476: AND E.TASK_ID = p_task_id

Line 1499: PA_EVENTS E

1495: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1496: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1497: PA_DRAFT_REVENUES_ALL DR,
1498: PA_EVENT_TYPES ET,
1499: PA_EVENTS E
1500: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1501: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1502: AND E.EVENT_NUM = ERDL.EVENT_NUM
1503: AND ET.EVENT_TYPE = E.EVENT_TYPE

Line 1525: PA_EVENTS E

1521: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1522: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1523: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1524: PA_EVENT_TYPES ET,
1525: PA_EVENTS E
1526: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG ,'N') = 'Y'
1527: AND E.EVENT_NUM = ERDL.EVENT_NUM
1528: AND ET.EVENT_TYPE = E.EVENT_TYPE
1529: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'

Line 1542: PA_EVENTS E

1538: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1539: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1540: x_projfunc_writeoff_amount,p_writeoff_amount
1541: FROM PA_EVENT_TYPES ET,
1542: PA_EVENTS E
1543: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1544: AND ET.EVENT_TYPE = E.EVENT_TYPE
1545: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1546: AND E.PROJECT_ID = p_project_id; */

Line 1564: PA_EVENTS E

1560: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1561: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1562: PA_DRAFT_REVENUES_ALL DR,
1563: PA_EVENT_TYPES ET,
1564: PA_EVENTS E
1565: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1566: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1567: AND E.EVENT_NUM = ERDL.EVENT_NUM
1568: AND ET.EVENT_TYPE = E.EVENT_TYPE

Line 1590: PA_EVENTS E

1586: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1587: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1588: PA_DRAFT_REVENUES_ALL DR,
1589: PA_EVENT_TYPES ET,
1590: PA_EVENTS E
1591: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1592: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1593: AND E.EVENT_NUM = ERDL.EVENT_NUM
1594: AND ET.EVENT_TYPE = E.EVENT_TYPE