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

Line 162: FROM pa_events

158: l_event_num number;
159:
160: CURSOR get_proj_event_num IS
161: SELECT event_num
162: FROM pa_events
163: WHERE project_id=P_project_id
164: AND task_id IS NULL
165: AND event_num=P_event_num;
166:

Line 169: FROM pa_events

165: AND event_num=P_event_num;
166:
167: CURSOR get_task_event_num IS
168: SELECT event_num
169: FROM pa_events
170: WHERE project_id=P_project_id
171: AND task_id =P_task_id
172: AND event_num=P_event_num;
173:

Line 339: l_valid_bill_trans_code Pa_events.bill_trans_currency_code%TYPE;

335:
336: FUNCTION CHECK_VALID_CURR(
337: P_bill_trans_curr IN VARCHAR2) RETURN VARCHAR2 IS
338:
339: l_valid_bill_trans_code Pa_events.bill_trans_currency_code%TYPE;
340:
341: CURSOR VALID_CURR
342: IS
343: SELECT 1

Line 641: FROM PA_EVENTS

637: P_event_id IN NUMBER) RETURN VARCHAR2 IS
638:
639: CURSOR EVENT_PROCESSED IS
640: SELECT REVENUE_DISTRIBUTED_FLAG,BILLED_FLAG
641: FROM PA_EVENTS
642: WHERE EVENT_ID=P_event_id;
643:
644: CURSOR EVENT_BILL_AMOUNT IS
645: SELECT SUM(NVL(AMOUNT,0))

Line 646: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA

642: WHERE EVENT_ID=P_event_id;
643:
644: CURSOR EVENT_BILL_AMOUNT IS
645: SELECT SUM(NVL(AMOUNT,0))
646: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA
647: WHERE DI.PROJECT_ID=EV.PROJECT_ID
648: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
649: AND DI.EVENT_NUM = EV.EVENT_NUM
650: AND DI.PROJECT_ID=DIA.PROJECT_ID

Line 681: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV

677: SELECT 1
678: INTO dummy
679: FROM DUAL
680: WHERE EXISTS ( SELECT NULL
681: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV
682: WHERE DI.project_id=EV.project_id
683: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
684: AND DI.EVENT_NUM = EV.EVENT_NUM
685: AND EV.EVENT_ID = P_event_id);

Line 876: FROM PA_EVENTS_V

872: /* CURSOR PROJ_WRITE_OFF_AMOUNT
873: IS
874: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
875: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,event_date
876: FROM PA_EVENTS_V
877: WHERE event_type_classification='WRITE OFF'
878: AND NVL(revenue_distributed_flag,'N')='N'
879: AND event_date IS NOT NULL
880: AND NVL(event_id,-1)<>NVL(P_event_id,-2)

Line 887: FROM PA_EVENTS_V

883: /* CURSOR TASK_WRITE_OFF_AMOUNT
884: IS
885: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
886: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,event_date
887: FROM PA_EVENTS_V
888: WHERE event_type_classification='WRITE OFF'
889: AND NVL(REVENUE_DISTRIBUTED_FLAG,'N')='N'
890: AND event_date IS NOT NULL
891: AND project_id= P_project_id

Line 900: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT

896: CURSOR proj_write_off_amount
897: IS
898: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
899: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
900: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT
901: WHERE EVT.event_type_classification='WRITE OFF'
902: AND EVT.event_type=EV.event_type
903: AND NVL(EV.revenue_distributed_flag,'N')='N'
904: AND EV.completion_date IS NOT NULL

Line 912: FROM PA_EVENTS EV

908: CURSOR proj_write_off_amount
909: IS
910: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
911: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
912: FROM PA_EVENTS EV
913: WHERE EV.revenue_distributed_flag ='N'
914: AND EV.completion_date IS NOT NULL
915: AND NVL(EV.event_id,-1)<>NVL(P_event_id,-2)
916: AND exists (select 1 from PA_EVENT_TYPES EVT

Line 925: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT

921: CURSOR task_write_off_amount
922: IS
923: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
924: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
925: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT
926: WHERE EVT.event_type_classification='WRITE OFF'
927: AND EVT.event_type=EV.event_type
928: AND NVL(EV.revenue_distributed_flag,'N')='N'
929: AND EV.completion_date IS NOT NULL

Line 937: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /VARCHAR2(2000);/

933:
934: l_accrued_amount NUMBER;
935: l_billed_amount NUMBER;
936: l_bill_trans_amount NUMBER;
937: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
938: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
939: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
940: l_projfunc_rate_date DATE;
941: l_projfunc_exchange_rate NUMBER;

Line 938: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /VARCHAR2(2000);/

934: l_accrued_amount NUMBER;
935: l_billed_amount NUMBER;
936: l_bill_trans_amount NUMBER;
937: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
938: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
939: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
940: l_projfunc_rate_date DATE;
941: l_projfunc_exchange_rate NUMBER;
942: l_event_date DATE;

Line 939: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /VARCHAR2(2000);/

935: l_billed_amount NUMBER;
936: l_bill_trans_amount NUMBER;
937: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
938: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
939: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
940: l_projfunc_rate_date DATE;
941: l_projfunc_exchange_rate NUMBER;
942: l_event_date DATE;
943: l_conv_date DATE;