[Home] [Help]
772: IF g1_debug_mode = 'Y' THEN
773: PA_MCB_INVOICE_PKG.log_message('Entering pa_billing.Delete_Automatic_Events :');
774: END IF;
775: IF (X_calling_Process = 'Revenue') THEN
776: DELETE from pa_events v
777: WHERE v.project_id = X_project_id
778: AND v.request_id+0 = X_request_id
779: AND (v.project_id, nvl(v.task_id, -1), v.event_num) IN
780: (SELECT l.project_id, nvl(l.task_id, -1), l.event_num
793: END IF;
794: ELSE
795: -- DBMS_OUTPUT.PUT_LINE('Deleting Invoice Events');
796:
797: DELETE FROM PA_EVENTS V
798: WHERE V.Project_ID = X_project_id
799: AND (nvl(V.Task_ID, -1), V.Event_Num) IN
800: (select nvl(dii.Event_Task_ID, -1), dii.Event_Num
801: from pa_draft_invoice_items dii, pa_draft_invoices di
1350: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1351: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1352: PA_DRAFT_REVENUES_ALL DR,
1353: PA_EVENT_TYPES ET,
1354: PA_EVENTS E
1355: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1356: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1357: AND E.EVENT_NUM = ERDL.EVENT_NUM
1358: AND E.TASK_ID = ERDL.TASK_ID
1379: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1380: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1381: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1382: PA_EVENT_TYPES ET,
1383: PA_EVENTS E
1384: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1385: AND E.EVENT_NUM = ERDL.EVENT_NUM
1386: AND E.TASK_ID = ERDL.TASK_ID
1387: AND ET.EVENT_TYPE = E.EVENT_TYPE
1397: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1398: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1399: x_projfunc_writeoff_amount,p_writeoff_amount
1400: FROM PA_EVENT_TYPES ET,
1401: PA_EVENTS E
1402: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1403: AND ET.EVENT_TYPE = E.EVENT_TYPE
1404: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1405: AND E.TASK_ID = p_task_id
1424: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1425: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1426: PA_DRAFT_REVENUES_ALL DR,
1427: PA_EVENT_TYPES ET,
1428: PA_EVENTS E
1429: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1430: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1431: AND E.EVENT_NUM = ERDL.EVENT_NUM
1432: AND ET.EVENT_TYPE = E.EVENT_TYPE
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 ET.EVENT_TYPE = E.EVENT_TYPE
1458: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1467: SUM(NVL(E.projfunc_revenue_amount,0)),SUM(NVL(E.funding_revenue_amount,0))
1468: INTO x_revproc_writeoff_amount,x_project_writeoff_amount,
1469: x_projfunc_writeoff_amount,p_writeoff_amount
1470: FROM PA_EVENT_TYPES ET,
1471: PA_EVENTS E
1472: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1473: AND ET.EVENT_TYPE = E.EVENT_TYPE
1474: AND ET.EVENT_TYPE_CLASSIFICATION ||''='WRITE OFF'
1475: AND E.PROJECT_ID = p_project_id; */
1489: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1490: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1491: PA_DRAFT_REVENUES_ALL DR,
1492: PA_EVENT_TYPES ET,
1493: PA_EVENTS E
1494: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1495: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1496: AND E.EVENT_NUM = ERDL.EVENT_NUM
1497: AND ET.EVENT_TYPE = E.EVENT_TYPE
1515: x_projfunc_writeoff_amount,p_writeoff_amount /* MCB related changes */
1516: FROM PA_CUST_EVENT_RDL_ALL ERDL,
1517: PA_DRAFT_REVENUES_ALL DR,
1518: PA_EVENT_TYPES ET,
1519: PA_EVENTS E
1520: WHERE NVL(E.REVENUE_DISTRIBUTED_FLAG , 'N') = 'Y'
1521: AND ERDL.PROJECT_ID=DR.PROJECT_ID
1522: AND E.EVENT_NUM = ERDL.EVENT_NUM
1523: AND ET.EVENT_TYPE = E.EVENT_TYPE