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.GMS_BILLING dependencies on PA_EVENTS

Line 410: FROM pa_events

406: AND event_calling_process IS NOT NULL
407: -- null for manual events
408: and not exists ( /* Modified MINUS operation to Not exists clause */
409: SELECT 1 --project_id, event_num, calling_process event_type /* Modifed for 6969435 */
410: FROM pa_events
411: WHERE --project_id = x_award_project_id /* commented for 6969435 */
412: --AND calling_process = x_calling_process /* commented for 6969435 */
413: --AND ( (x_event_num IS NULL) OR /* commented for 6969435 */
414: -- (x_event_num IS NOT NULL AND event_num = x_event_num) /* commented for 6969435 */

Line 3591: --Procedure CREATE_PA_EVENTS

3587:
3588: End PROCESS_TEMP_EVENTS;
3589:
3590: ---------------------------------------------------------------------------------------
3591: --Procedure CREATE_PA_EVENTS
3592: -----------------------------------------------------------------------------------------
3593: -- Bug 3235390 : This newly introduced procedure does the following :
3594: -- a. Fetches consolidated records from the plsql table
3595: -- b. Inserts consolidated events into gms_event_attribute table

Line 3596: -- b. If amount <> 0 then inserts events into Pa_events and

3592: -----------------------------------------------------------------------------------------
3593: -- Bug 3235390 : This newly introduced procedure does the following :
3594: -- a. Fetches consolidated records from the plsql table
3595: -- b. Inserts consolidated events into gms_event_attribute table
3596: -- b. If amount <> 0 then inserts events into Pa_events and
3597: -- updates GEI and GEA with newly generated event_num.
3598: -- c. If amount = 0 then updates -1 on GEA and GEI and sets the
3599: -- NULL events variables.
3600: ----------------------------------------------------------------------------------------------------

Line 3602: PROCEDURE CREATE_PA_EVENTS (p_project_id In NUMBER,

3598: -- c. If amount = 0 then updates -1 on GEA and GEI and sets the
3599: -- NULL events variables.
3600: ----------------------------------------------------------------------------------------------------
3601:
3602: PROCEDURE CREATE_PA_EVENTS (p_project_id In NUMBER,
3603: p_Calling_Process IN VARCHAR2,
3604: p_completion_date IN DATE,
3605: p_carrying_out_org_id IN NUMBER,
3606: p_Request_Id IN NUMBER,

Line 3619: CURSOR C_get_temp_pa_events IS

3615: X_count NUMBER;
3616: X_rev_amt NUMBER(22,5);
3617: X_bill_amt NUMBER(22,5);
3618:
3619: CURSOR C_get_temp_pa_events IS
3620: SELECT event_num,
3621: format,
3622: description,
3623: SUM(amount) amount

Line 3643: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - START','C');

3639:
3640: BEGIN
3641:
3642: IF L_DEBUG = 'Y' THEN
3643: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - START','C');
3644: END IF;
3645:
3646: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3647:

Line 3646: FOR pa_events_rec IN C_get_temp_pa_events LOOP

3642: IF L_DEBUG = 'Y' THEN
3643: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - START','C');
3644: END IF;
3645:
3646: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3647:
3648: IF nvl(pa_events_rec.amount,0) = 0 THEN
3649: Evt_num := -1;
3650:

Line 3648: IF nvl(pa_events_rec.amount,0) = 0 THEN

3644: END IF;
3645:
3646: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3647:
3648: IF nvl(pa_events_rec.amount,0) = 0 THEN
3649: Evt_num := -1;
3650:
3651: IF p_Calling_Process = 'Revenue' THEN
3652: X_REVRAW_NULL_EVENT_PROCESSED := TRUE;

Line 3658: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - Encountered NULL event- After setting NULL event flags','C');

3654: X_INVRAW_NULL_EVENT_PROCESSED := TRUE;
3655: END IF;
3656:
3657: IF L_DEBUG = 'Y' THEN
3658: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - Encountered NULL event- After setting NULL event flags','C');
3659: END IF;
3660: END IF;
3661:
3662: FOR gms_events_rec IN C_get_temp_gms_events(pa_events_rec.event_num,pa_events_rec.format,pa_events_rec.description) LOOP

Line 3662: FOR gms_events_rec IN C_get_temp_gms_events(pa_events_rec.event_num,pa_events_rec.format,pa_events_rec.description) LOOP

3658: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - Encountered NULL event- After setting NULL event flags','C');
3659: END IF;
3660: END IF;
3661:
3662: FOR gms_events_rec IN C_get_temp_gms_events(pa_events_rec.event_num,pa_events_rec.format,pa_events_rec.description) LOOP
3663:
3664: EVENT_WRAPPER(p_Project_Id,
3665: gms_events_rec.act_project_id,
3666: gms_events_rec.task_id,

Line 3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');

3673: p_Err_Code,
3674: p_Err_Buff);
3675:
3676: IF L_DEBUG = 'Y' THEN
3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');

Line 3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');

3674: p_Err_Buff);
3675:
3676: IF L_DEBUG = 'Y' THEN
3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3682: END IF;

Line 3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');

3675:
3676: IF L_DEBUG = 'Y' THEN
3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3682: END IF;
3683:

Line 3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');

3676: IF L_DEBUG = 'Y' THEN
3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3682: END IF;
3683:
3684: IF p_Err_Code <> 0 THEN

Line 3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');

3677: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3678: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3679: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3680: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3681: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3682: END IF;
3683:
3684: IF p_Err_Code <> 0 THEN
3685: Raise NO_PROCESSING_OF_AWARD ;

Line 3690: IF pa_events_rec.amount <> 0 THEN

3686: END IF;
3687:
3688: END LOOP;
3689:
3690: IF pa_events_rec.amount <> 0 THEN
3691:
3692: IF p_Calling_Process = 'Revenue' then
3693: X_rev_amt := pa_events_rec.amount;
3694: X_bill_amt := 0;

Line 3693: X_rev_amt := pa_events_rec.amount;

3689:
3690: IF pa_events_rec.amount <> 0 THEN
3691:
3692: IF p_Calling_Process = 'Revenue' then
3693: X_rev_amt := pa_events_rec.amount;
3694: X_bill_amt := 0;
3695: ELSIF p_Calling_Process = 'Invoice' then
3696: X_bill_amt := pa_events_rec.amount;
3697: X_rev_amt := 0;

Line 3696: X_bill_amt := pa_events_rec.amount;

3692: IF p_Calling_Process = 'Revenue' then
3693: X_rev_amt := pa_events_rec.amount;
3694: X_bill_amt := 0;
3695: ELSIF p_Calling_Process = 'Invoice' then
3696: X_bill_amt := pa_events_rec.amount;
3697: X_rev_amt := 0;
3698: END IF;
3699:
3700: Evt_Num := pa_billing_seq.next_eventnum(p_Project_Id,NULL); -- Bug 3235390

Line 3710: X_event_description => pa_events_rec.description,

3706: X_event_type => 'AWARD_BILLING',
3707: X_top_task_id => NULL,
3708: X_organization_id => p_Carrying_Out_Org_Id,
3709: X_completion_date => p_completion_date,
3710: X_event_description => pa_events_rec.description,
3711: X_event_num_reversed => NULL,
3712: X_attribute_category => NULL,
3713: X_attribute1 => NULL,
3714: X_attribute2 => NULL,

Line 3728: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call for event number '||Evt_Num||' with amount '||pa_events_rec.amount,'C');

3724: X_status => St_Status
3725: );
3726:
3727: IF L_DEBUG = 'Y' THEN
3728: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call for event number '||Evt_Num||' with amount '||pa_events_rec.amount,'C');
3729: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3730: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3731: END IF;
3732:

Line 3729: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');

3725: );
3726:
3727: IF L_DEBUG = 'Y' THEN
3728: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call for event number '||Evt_Num||' with amount '||pa_events_rec.amount,'C');
3729: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3730: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3731: END IF;
3732:
3733: IF St_Status <> 0 THEN

Line 3730: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');

3726:
3727: IF L_DEBUG = 'Y' THEN
3728: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call for event number '||Evt_Num||' with amount '||pa_events_rec.amount,'C');
3729: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3730: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3731: END IF;
3732:
3733: IF St_Status <> 0 THEN
3734: RAISE NO_PROCESSING_OF_AWARD;

Line 3743: WHERE Event_num = pa_events_rec.event_num

3739: END IF;
3740:
3741: UPDATE gms_event_intersect
3742: SET Event_Num = Evt_num
3743: WHERE Event_num = pa_events_rec.event_num
3744: AND award_project_id = p_project_id; /* Added for bug 4172924*/
3745:
3746: IF L_DEBUG = 'Y' THEN
3747: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After updating GEI ','C');

Line 3747: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After updating GEI ','C');

3743: WHERE Event_num = pa_events_rec.event_num
3744: AND award_project_id = p_project_id; /* Added for bug 4172924*/
3745:
3746: IF L_DEBUG = 'Y' THEN
3747: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After updating GEI ','C');
3748: END IF;
3749:
3750: EVENT_ATTRIBUTE_UPDATION( Evt_Num,
3751: p_Project_Id,

Line 3757: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Code'||p_Err_Code,'C');

3753: p_Err_Code,
3754: p_Err_Buff);
3755:
3756: IF L_DEBUG = 'Y' THEN
3757: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Code'||p_Err_Code,'C');
3758: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Buff'||p_Err_Buff,'C');
3759: END IF;
3760:
3761: IF p_Err_Code <> 0 THEN

Line 3758: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Buff'||p_Err_Buff,'C');

3754: p_Err_Buff);
3755:
3756: IF L_DEBUG = 'Y' THEN
3757: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Code'||p_Err_Code,'C');
3758: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Buff'||p_Err_Buff,'C');
3759: END IF;
3760:
3761: IF p_Err_Code <> 0 THEN
3762: Raise NO_PROCESSING_OF_AWARD ;

Line 3768: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - END','C');

3764:
3765: END LOOP;
3766:
3767: IF L_DEBUG = 'Y' THEN
3768: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - END','C');
3769: END IF;
3770:
3771: EXCEPTION
3772:

Line 3776: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - WHEN OTHERS ','C');

3772:
3773: When Others then
3774:
3775: IF L_DEBUG = 'Y' THEN
3776: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - WHEN OTHERS ','C');
3777: END IF;
3778:
3779: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
3780: 'SQLCODE',

Line 3790: END CREATE_PA_EVENTS;

3786: X_Err_Buff => p_Err_Buff);
3787:
3788: RAISE NO_PROCESSING_OF_AWARD;
3789:
3790: END CREATE_PA_EVENTS;
3791:
3792: -----------------------------------------------------------------------------------------
3793: -- Procedure DO_EVENT_PROCESSING: This procedure builds the Event description and creates the
3794: -- Billing or Revenue Event

Line 3797: -- a. Code to create events in pa_events and gms_event_attribute table is

3793: -- Procedure DO_EVENT_PROCESSING: This procedure builds the Event description and creates the
3794: -- Billing or Revenue Event
3795: -----------------------------------------------------------------------------------------
3796: -- Bug 3235390 : Modified the logic as mentioned below
3797: -- a. Code to create events in pa_events and gms_event_attribute table is
3798: -- shifted to CREATE_PA_EVENTS procedure.
3799: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3800: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3801: -- d. Distinct events and their format will be temporarly stored in plsql table

Line 3798: -- shifted to CREATE_PA_EVENTS procedure.

3794: -- Billing or Revenue Event
3795: -----------------------------------------------------------------------------------------
3796: -- Bug 3235390 : Modified the logic as mentioned below
3797: -- a. Code to create events in pa_events and gms_event_attribute table is
3798: -- shifted to CREATE_PA_EVENTS procedure.
3799: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3800: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3801: -- d. Distinct events and their format will be temporarly stored in plsql table
3802: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

Line 3802: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

3798: -- shifted to CREATE_PA_EVENTS procedure.
3799: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3800: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3801: -- d. Distinct events and their format will be temporarly stored in plsql table
3802: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3803: -- records from the plsql table and will insert events into Pa_events and
3804: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3805: -- Even the NULL events logic is shifted to create_pa_events procedure.
3806: ----------------------------------------------------------------------------------------------------

Line 3803: -- records from the plsql table and will insert events into Pa_events and

3799: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3800: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3801: -- d. Distinct events and their format will be temporarly stored in plsql table
3802: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3803: -- records from the plsql table and will insert events into Pa_events and
3804: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3805: -- Even the NULL events logic is shifted to create_pa_events procedure.
3806: ----------------------------------------------------------------------------------------------------
3807:

Line 3805: -- Even the NULL events logic is shifted to create_pa_events procedure.

3801: -- d. Distinct events and their format will be temporarly stored in plsql table
3802: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3803: -- records from the plsql table and will insert events into Pa_events and
3804: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3805: -- Even the NULL events logic is shifted to create_pa_events procedure.
3806: ----------------------------------------------------------------------------------------------------
3807:
3808:
3809: PROCEDURE DO_EVENT_PROCESSING(X_Count_Of_Columns IN NUMBER DEFAULT 0,

Line 4331: -- a. Code to create events in pa_events and gms_event_attribute table is

4327: ----------------------------------------------------------------------------------------
4328: --Procedure DO_REV_EVENT_PROCESSING
4329: -----------------------------------------------------------------------------------------
4330: -- Bug 3235390 : Modified the logic as mentioned below
4331: -- a. Code to create events in pa_events and gms_event_attribute table is
4332: -- shifted to CREATE_PA_EVENTS procedure.
4333: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4334: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4335: -- d. Distinct events and their format will be temporarly stored in plsql table

Line 4332: -- shifted to CREATE_PA_EVENTS procedure.

4328: --Procedure DO_REV_EVENT_PROCESSING
4329: -----------------------------------------------------------------------------------------
4330: -- Bug 3235390 : Modified the logic as mentioned below
4331: -- a. Code to create events in pa_events and gms_event_attribute table is
4332: -- shifted to CREATE_PA_EVENTS procedure.
4333: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4334: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4335: -- d. Distinct events and their format will be temporarly stored in plsql table
4336: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

Line 4336: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

4332: -- shifted to CREATE_PA_EVENTS procedure.
4333: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4334: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4335: -- d. Distinct events and their format will be temporarly stored in plsql table
4336: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4337: -- records from the plsql table and will insert events into Pa_events and
4338: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4339: -- Even the NULL events logic is shifted to create_pa_events procedure.
4340: ----------------------------------------------------------------------------------------------------

Line 4337: -- records from the plsql table and will insert events into Pa_events and

4333: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4334: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4335: -- d. Distinct events and their format will be temporarly stored in plsql table
4336: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4337: -- records from the plsql table and will insert events into Pa_events and
4338: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4339: -- Even the NULL events logic is shifted to create_pa_events procedure.
4340: ----------------------------------------------------------------------------------------------------
4341:

Line 4339: -- Even the NULL events logic is shifted to create_pa_events procedure.

4335: -- d. Distinct events and their format will be temporarly stored in plsql table
4336: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4337: -- records from the plsql table and will insert events into Pa_events and
4338: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4339: -- Even the NULL events logic is shifted to create_pa_events procedure.
4340: ----------------------------------------------------------------------------------------------------
4341:
4342: PROCEDURE DO_REV_EVENT_PROCESSING(X_Act_Project_Id IN NUMBER,
4343: X_Task_Id IN NUMBER,

Line 7182: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events

7178: ( X_Invoice_Limit_Flag = 'Y' AND g_process_again = 'N' ) ) THEN
7179:
7180: f_dummy := f_dummy + 1;
7181:
7182: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7183: -- gms_event_attribute table from temporary table.
7184:
7185: CREATE_PA_EVENTS (X_project_id ,
7186: X_Calling_Process ,

Line 7185: CREATE_PA_EVENTS (X_project_id ,

7181:
7182: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7183: -- gms_event_attribute table from temporary table.
7184:
7185: CREATE_PA_EVENTS (X_project_id ,
7186: X_Calling_Process ,
7187: X_rev_or_bill_Date ,
7188: X_Carrying_Out_Org_Id,
7189: X_Request_Id ,

Line 7329: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events

7325: f_non_labor_neg_exp_processed); /* Added for bug 5026657 */
7326:
7327: g_non_labor_neg_exp_processed := f_non_labor_neg_exp_processed ; /* Added for bug 5026657 */
7328:
7329: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7330: -- gms_event_attribute table from temporary table.
7331:
7332: /* Added for bug 5026657 */
7333: IF (g_labor_exp_to_process = 'Y' and g_non_labor_neg_exp_processed = 'Y') THEN

Line 7353: CREATE_PA_EVENTS (X_project_id ,

7349: ( X_Revenue_Limit_Flag = 'Y' AND g_process_again = 'N' ) ) THEN -- %%%%%%%
7350:
7351: f_dummy := f_dummy + 1;
7352:
7353: CREATE_PA_EVENTS (X_project_id ,
7354: X_Calling_Process ,
7355: X_rev_or_bill_Date ,
7356: X_Rev_Carrying_Out_Org_Id,
7357: X_Request_Id ,