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 642: FROM PA_EVENTS

638:
639: CURSOR EVENT_PROCESSED IS
640: SELECT REVENUE_DISTRIBUTED_FLAG,BILLED_FLAG
641: ,BILL_TRANS_BILL_AMOUNT,BILL_TRANS_REV_AMOUNT /*Added for bug#9370006 */
642: FROM PA_EVENTS
643: WHERE EVENT_ID=P_event_id;
644: /*Bug 16245626 replaced di.task_id with di.event_task_id */
645:
646: CURSOR EVENT_BILL_AMOUNT IS

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

644: /*Bug 16245626 replaced di.task_id with di.event_task_id */
645:
646: CURSOR EVENT_BILL_AMOUNT IS
647: SELECT SUM(NVL(AMOUNT,0))
648: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA
649: WHERE DI.PROJECT_ID=EV.PROJECT_ID
650: AND nvl(DI.EVENT_TASK_ID,-1) =nvl(EV.TASK_ID,-1)
651: AND DI.EVENT_NUM = EV.EVENT_NUM
652: AND DI.PROJECT_ID=DIA.PROJECT_ID

Line 661: l_bill_trans_bill_amount pa_events.bill_trans_bill_amount%type; /* Added for bug#9370006 */

657: l_rev_flag VARCHAR2(1);
658: l_billed_flag VARCHAR2(1);
659: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;
660: l_invoiced_flag VARCHAR2(1):= 'N';
661: l_bill_trans_bill_amount pa_events.bill_trans_bill_amount%type; /* Added for bug#9370006 */
662: l_bill_trans_rev_amount pa_events.bill_trans_rev_amount%type; /* Added for bug#9370006 */
663: BEGIN
664:
665: OPEN EVENT_PROCESSED;

Line 662: l_bill_trans_rev_amount pa_events.bill_trans_rev_amount%type; /* Added for bug#9370006 */

658: l_billed_flag VARCHAR2(1);
659: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;
660: l_invoiced_flag VARCHAR2(1):= 'N';
661: l_bill_trans_bill_amount pa_events.bill_trans_bill_amount%type; /* Added for bug#9370006 */
662: l_bill_trans_rev_amount pa_events.bill_trans_rev_amount%type; /* Added for bug#9370006 */
663: BEGIN
664:
665: OPEN EVENT_PROCESSED;
666: FETCH EVENT_PROCESSED INTO l_rev_flag,l_billed_flag,l_bill_trans_bill_amount,l_bill_trans_rev_amount; /*

Line 686: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV

682: SELECT 1
683: INTO dummy
684: FROM DUAL
685: WHERE EXISTS ( SELECT NULL
686: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV
687: WHERE DI.project_id=EV.project_id
688: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
689: AND DI.EVENT_NUM = EV.EVENT_NUM
690: AND EV.EVENT_ID = P_event_id);

Line 896: FROM PA_EVENTS_V

892: /* CURSOR PROJ_WRITE_OFF_AMOUNT
893: IS
894: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
895: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,event_date
896: FROM PA_EVENTS_V
897: WHERE event_type_classification='WRITE OFF'
898: AND NVL(revenue_distributed_flag,'N')='N'
899: AND event_date IS NOT NULL
900: AND NVL(event_id,-1)<>NVL(P_event_id,-2)

Line 907: FROM PA_EVENTS_V

903: /* CURSOR TASK_WRITE_OFF_AMOUNT
904: IS
905: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
906: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,event_date
907: FROM PA_EVENTS_V
908: WHERE event_type_classification='WRITE OFF'
909: AND NVL(REVENUE_DISTRIBUTED_FLAG,'N')='N'
910: AND event_date IS NOT NULL
911: AND project_id= P_project_id

Line 920: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT

916: CURSOR proj_write_off_amount
917: IS
918: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
919: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
920: FROM PA_EVENTS EV,PA_EVENT_TYPES EVT
921: WHERE EVT.event_type_classification='WRITE OFF'
922: AND EVT.event_type=EV.event_type
923: AND NVL(EV.revenue_distributed_flag,'N')='N'
924: AND EV.completion_date IS NOT NULL

Line 932: FROM PA_EVENTS EV

928: CURSOR proj_write_off_amount
929: IS
930: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
931: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
932: FROM PA_EVENTS EV
933: WHERE EV.revenue_distributed_flag ='N'
934: AND EV.completion_date IS NOT NULL
935: AND NVL(EV.event_id,-1)<>NVL(P_event_id,-2)
936: AND exists (select 1 from PA_EVENT_TYPES EVT

Line 945: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT

941: CURSOR task_write_off_amount
942: IS
943: SELECT NVL(bill_trans_rev_amount,0),bill_trans_currency_code,projfunc_currency_code,
944: projfunc_rate_type,projfunc_rate_date,projfunc_exchange_rate,completion_date
945: FROM PA_EVENTS EV ,PA_EVENT_TYPES EVT
946: WHERE EVT.event_type_classification='WRITE OFF'
947: AND EVT.event_type=EV.event_type
948: AND NVL(EV.revenue_distributed_flag,'N')='N'
949: AND EV.completion_date IS NOT NULL

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

953:
954: l_accrued_amount NUMBER;
955: l_billed_amount NUMBER;
956: l_bill_trans_amount NUMBER;
957: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
958: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
959: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
960: l_projfunc_rate_date DATE;
961: l_projfunc_exchange_rate NUMBER;

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

954: l_accrued_amount NUMBER;
955: l_billed_amount NUMBER;
956: l_bill_trans_amount NUMBER;
957: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
958: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
959: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
960: l_projfunc_rate_date DATE;
961: l_projfunc_exchange_rate NUMBER;
962: l_event_date DATE;

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

955: l_billed_amount NUMBER;
956: l_bill_trans_amount NUMBER;
957: l_bill_trans_currency_code PA_EVENTS.bill_trans_currency_code%TYPE; /*VARCHAR2(2000);*/
958: l_projfunc_currency_code PA_EVENTS.projfunc_currency_code%TYPE; /*VARCHAR2(2000);*/
959: l_projfunc_rate_type PA_EVENTS.projfunc_rate_type%TYPE; /*VARCHAR2(2000);*/
960: l_projfunc_rate_date DATE;
961: l_projfunc_exchange_rate NUMBER;
962: l_event_date DATE;
963: l_conv_date DATE;