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 3616: --Procedure CREATE_PA_EVENTS

3612:
3613: End PROCESS_TEMP_EVENTS;
3614:
3615: ---------------------------------------------------------------------------------------
3616: --Procedure CREATE_PA_EVENTS
3617: -----------------------------------------------------------------------------------------
3618: -- Bug 3235390 : This newly introduced procedure does the following :
3619: -- a. Fetches consolidated records from the plsql table
3620: -- b. Inserts consolidated events into gms_event_attribute table

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

3617: -----------------------------------------------------------------------------------------
3618: -- Bug 3235390 : This newly introduced procedure does the following :
3619: -- a. Fetches consolidated records from the plsql table
3620: -- b. Inserts consolidated events into gms_event_attribute table
3621: -- b. If amount <> 0 then inserts events into Pa_events and
3622: -- updates GEI and GEA with newly generated event_num.
3623: -- c. If amount = 0 then updates -1 on GEA and GEI and sets the
3624: -- NULL events variables.
3625: ----------------------------------------------------------------------------------------------------

Line 3627: PROCEDURE CREATE_PA_EVENTS (p_project_id In NUMBER,

3623: -- c. If amount = 0 then updates -1 on GEA and GEI and sets the
3624: -- NULL events variables.
3625: ----------------------------------------------------------------------------------------------------
3626:
3627: PROCEDURE CREATE_PA_EVENTS (p_project_id In NUMBER,
3628: p_Calling_Process IN VARCHAR2,
3629: p_completion_date IN DATE,
3630: p_carrying_out_org_id IN NUMBER,
3631: p_Request_Id IN NUMBER,

Line 3644: CURSOR C_get_temp_pa_events IS

3640: X_count NUMBER;
3641: X_rev_amt NUMBER(22,5);
3642: X_bill_amt NUMBER(22,5);
3643:
3644: CURSOR C_get_temp_pa_events IS
3645: SELECT event_num,
3646: format,
3647: description,
3648: SUM(amount) amount

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

3664:
3665: BEGIN
3666:
3667: IF L_DEBUG = 'Y' THEN
3668: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - START','C');
3669: END IF;
3670:
3671: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3672:

Line 3671: FOR pa_events_rec IN C_get_temp_pa_events LOOP

3667: IF L_DEBUG = 'Y' THEN
3668: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - START','C');
3669: END IF;
3670:
3671: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3672:
3673: IF nvl(pa_events_rec.amount,0) = 0 THEN
3674: Evt_num := -1;
3675:

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

3669: END IF;
3670:
3671: FOR pa_events_rec IN C_get_temp_pa_events LOOP
3672:
3673: IF nvl(pa_events_rec.amount,0) = 0 THEN
3674: Evt_num := -1;
3675:
3676: IF p_Calling_Process = 'Revenue' THEN
3677: X_REVRAW_NULL_EVENT_PROCESSED := TRUE;

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

3679: X_INVRAW_NULL_EVENT_PROCESSED := TRUE;
3680: END IF;
3681:
3682: IF L_DEBUG = 'Y' THEN
3683: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - Encountered NULL event- After setting NULL event flags','C');
3684: END IF;
3685: END IF;
3686:
3687: 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 3687: FOR gms_events_rec IN C_get_temp_gms_events(pa_events_rec.event_num,pa_events_rec.format,pa_events_rec.description) LOOP

3683: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - Encountered NULL event- After setting NULL event flags','C');
3684: END IF;
3685: END IF;
3686:
3687: FOR gms_events_rec IN C_get_temp_gms_events(pa_events_rec.event_num,pa_events_rec.format,pa_events_rec.description) LOOP
3688:
3689: EVENT_WRAPPER(p_Project_Id,
3690: gms_events_rec.act_project_id,
3691: gms_events_rec.task_id,

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

3698: p_Err_Code,
3699: p_Err_Buff);
3700:
3701: IF L_DEBUG = 'Y' THEN
3702: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3703: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3704: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3705: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3706: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');

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

3699: p_Err_Buff);
3700:
3701: IF L_DEBUG = 'Y' THEN
3702: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3703: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3704: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3705: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3706: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3707: END IF;

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

3700:
3701: IF L_DEBUG = 'Y' THEN
3702: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3703: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3704: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3705: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3706: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3707: END IF;
3708:

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

3701: IF L_DEBUG = 'Y' THEN
3702: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3703: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3704: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3705: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3706: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3707: END IF;
3708:
3709: IF p_Err_Code <> 0 THEN

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

3702: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for event '||pa_events_rec.event_num,'C');
3703: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for project_id '||gms_events_rec.act_project_id,'C');
3704: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call for task_id '||gms_events_rec.task_id,'C');
3705: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Code '||p_Err_Code,'C');
3706: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_WRAPPER call value of p_Err_Buff '||p_Err_Buff,'C');
3707: END IF;
3708:
3709: IF p_Err_Code <> 0 THEN
3710: Raise NO_PROCESSING_OF_AWARD ;

Line 3715: IF pa_events_rec.amount <> 0 THEN

3711: END IF;
3712:
3713: END LOOP;
3714:
3715: IF pa_events_rec.amount <> 0 THEN
3716:
3717: IF p_Calling_Process = 'Revenue' then
3718: X_rev_amt := pa_events_rec.amount;
3719: X_bill_amt := 0;

Line 3718: X_rev_amt := pa_events_rec.amount;

3714:
3715: IF pa_events_rec.amount <> 0 THEN
3716:
3717: IF p_Calling_Process = 'Revenue' then
3718: X_rev_amt := pa_events_rec.amount;
3719: X_bill_amt := 0;
3720: ELSIF p_Calling_Process = 'Invoice' then
3721: X_bill_amt := pa_events_rec.amount;
3722: X_rev_amt := 0;

Line 3721: X_bill_amt := pa_events_rec.amount;

3717: IF p_Calling_Process = 'Revenue' then
3718: X_rev_amt := pa_events_rec.amount;
3719: X_bill_amt := 0;
3720: ELSIF p_Calling_Process = 'Invoice' then
3721: X_bill_amt := pa_events_rec.amount;
3722: X_rev_amt := 0;
3723: END IF;
3724:
3725: Evt_Num := pa_billing_seq.next_eventnum(p_Project_Id,NULL); -- Bug 3235390

Line 3735: X_event_description => pa_events_rec.description,

3731: X_event_type => 'AWARD_BILLING',
3732: X_top_task_id => NULL,
3733: X_organization_id => p_Carrying_Out_Org_Id,
3734: X_completion_date => p_completion_date,
3735: X_event_description => pa_events_rec.description,
3736: X_event_num_reversed => NULL,
3737: X_attribute_category => NULL,
3738: X_attribute1 => NULL,
3739: X_attribute2 => NULL,

Line 3753: 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');

3749: X_status => St_Status
3750: );
3751:
3752: IF L_DEBUG = 'Y' THEN
3753: 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');
3754: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3755: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3756: END IF;
3757:

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

3750: );
3751:
3752: IF L_DEBUG = 'Y' THEN
3753: 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');
3754: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3755: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3756: END IF;
3757:
3758: IF St_Status <> 0 THEN

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

3751:
3752: IF L_DEBUG = 'Y' THEN
3753: 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');
3754: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Error_Message '||St_Error_Message,'C');
3755: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After insert_event call value of St_Status '||St_Status,'C');
3756: END IF;
3757:
3758: IF St_Status <> 0 THEN
3759: RAISE NO_PROCESSING_OF_AWARD;

Line 3768: WHERE Event_num = pa_events_rec.event_num

3764: END IF;
3765:
3766: UPDATE gms_event_intersect
3767: SET Event_Num = Evt_num
3768: WHERE Event_num = pa_events_rec.event_num
3769: AND award_project_id = p_project_id; /* Added for bug 4172924*/
3770:
3771: IF L_DEBUG = 'Y' THEN
3772: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After updating GEI ','C');

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

3768: WHERE Event_num = pa_events_rec.event_num
3769: AND award_project_id = p_project_id; /* Added for bug 4172924*/
3770:
3771: IF L_DEBUG = 'Y' THEN
3772: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After updating GEI ','C');
3773: END IF;
3774:
3775: EVENT_ATTRIBUTE_UPDATION( Evt_Num,
3776: p_Project_Id,

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

3778: p_Err_Code,
3779: p_Err_Buff);
3780:
3781: IF L_DEBUG = 'Y' THEN
3782: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Code'||p_Err_Code,'C');
3783: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Buff'||p_Err_Buff,'C');
3784: END IF;
3785:
3786: IF p_Err_Code <> 0 THEN

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

3779: p_Err_Buff);
3780:
3781: IF L_DEBUG = 'Y' THEN
3782: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Code'||p_Err_Code,'C');
3783: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - After EVENT_ATTRIBUTE_UPDATION value of p_Err_Buff'||p_Err_Buff,'C');
3784: END IF;
3785:
3786: IF p_Err_Code <> 0 THEN
3787: Raise NO_PROCESSING_OF_AWARD ;

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

3789:
3790: END LOOP;
3791:
3792: IF L_DEBUG = 'Y' THEN
3793: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - END','C');
3794: END IF;
3795:
3796: EXCEPTION
3797:

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

3797:
3798: When Others then
3799:
3800: IF L_DEBUG = 'Y' THEN
3801: gms_error_pkg.gms_debug('IN CREATE_PA_EVENTS - WHEN OTHERS ','C');
3802: END IF;
3803:
3804: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
3805: 'SQLCODE',

Line 3815: END CREATE_PA_EVENTS;

3811: X_Err_Buff => p_Err_Buff);
3812:
3813: RAISE NO_PROCESSING_OF_AWARD;
3814:
3815: END CREATE_PA_EVENTS;
3816:
3817: -----------------------------------------------------------------------------------------
3818: -- Procedure DO_EVENT_PROCESSING: This procedure builds the Event description and creates the
3819: -- Billing or Revenue Event

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

3818: -- Procedure DO_EVENT_PROCESSING: This procedure builds the Event description and creates the
3819: -- Billing or Revenue Event
3820: -----------------------------------------------------------------------------------------
3821: -- Bug 3235390 : Modified the logic as mentioned below
3822: -- a. Code to create events in pa_events and gms_event_attribute table is
3823: -- shifted to CREATE_PA_EVENTS procedure.
3824: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3825: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3826: -- d. Distinct events and their format will be temporarly stored in plsql table

Line 3823: -- shifted to CREATE_PA_EVENTS procedure.

3819: -- Billing or Revenue Event
3820: -----------------------------------------------------------------------------------------
3821: -- Bug 3235390 : Modified the logic as mentioned below
3822: -- a. Code to create events in pa_events and gms_event_attribute table is
3823: -- shifted to CREATE_PA_EVENTS procedure.
3824: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3825: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3826: -- d. Distinct events and their format will be temporarly stored in plsql table
3827: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

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

3823: -- shifted to CREATE_PA_EVENTS procedure.
3824: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3825: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3826: -- d. Distinct events and their format will be temporarly stored in plsql table
3827: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3828: -- records from the plsql table and will insert events into Pa_events and
3829: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3830: -- Even the NULL events logic is shifted to create_pa_events procedure.
3831: ----------------------------------------------------------------------------------------------------

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

3824: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
3825: -- c. Events will be assigned a negative seqeunce number which starts from -1001
3826: -- d. Distinct events and their format will be temporarly stored in plsql table
3827: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3828: -- records from the plsql table and will insert events into Pa_events and
3829: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3830: -- Even the NULL events logic is shifted to create_pa_events procedure.
3831: ----------------------------------------------------------------------------------------------------
3832:

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

3826: -- d. Distinct events and their format will be temporarly stored in plsql table
3827: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
3828: -- records from the plsql table and will insert events into Pa_events and
3829: -- gms_event_attribute tables and updates GEI with newly generated event_num.
3830: -- Even the NULL events logic is shifted to create_pa_events procedure.
3831: ----------------------------------------------------------------------------------------------------
3832:
3833:
3834: PROCEDURE DO_EVENT_PROCESSING(X_Count_Of_Columns IN NUMBER DEFAULT 0,

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

4352: ----------------------------------------------------------------------------------------
4353: --Procedure DO_REV_EVENT_PROCESSING
4354: -----------------------------------------------------------------------------------------
4355: -- Bug 3235390 : Modified the logic as mentioned below
4356: -- a. Code to create events in pa_events and gms_event_attribute table is
4357: -- shifted to CREATE_PA_EVENTS procedure.
4358: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4359: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4360: -- d. Distinct events and their format will be temporarly stored in plsql table

Line 4357: -- shifted to CREATE_PA_EVENTS procedure.

4353: --Procedure DO_REV_EVENT_PROCESSING
4354: -----------------------------------------------------------------------------------------
4355: -- Bug 3235390 : Modified the logic as mentioned below
4356: -- a. Code to create events in pa_events and gms_event_attribute table is
4357: -- shifted to CREATE_PA_EVENTS procedure.
4358: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4359: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4360: -- d. Distinct events and their format will be temporarly stored in plsql table
4361: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated

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

4357: -- shifted to CREATE_PA_EVENTS procedure.
4358: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4359: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4360: -- d. Distinct events and their format will be temporarly stored in plsql table
4361: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4362: -- records from the plsql table and will insert events into Pa_events and
4363: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4364: -- Even the NULL events logic is shifted to create_pa_events procedure.
4365: ----------------------------------------------------------------------------------------------------

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

4358: -- b. Events will be inserted into GBC and GEI and will be marked as billed/accrued.
4359: -- c. Events will be assigned a negative seqeunce number which starts from -1001
4360: -- d. Distinct events and their format will be temporarly stored in plsql table
4361: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4362: -- records from the plsql table and will insert events into Pa_events and
4363: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4364: -- Even the NULL events logic is shifted to create_pa_events procedure.
4365: ----------------------------------------------------------------------------------------------------
4366:

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

4360: -- d. Distinct events and their format will be temporarly stored in plsql table
4361: -- e. Newly introduced procedure CREATE_PA_EVENTS will fetch the consolidated
4362: -- records from the plsql table and will insert events into Pa_events and
4363: -- gms_event_attribute tables and updates GEI with newly generated event_num.
4364: -- Even the NULL events logic is shifted to create_pa_events procedure.
4365: ----------------------------------------------------------------------------------------------------
4366:
4367: PROCEDURE DO_REV_EVENT_PROCESSING(X_Act_Project_Id IN NUMBER,
4368: X_Task_Id IN NUMBER,

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

7209: ( X_Invoice_Limit_Flag = 'Y' AND g_process_again = 'N' ) ) THEN
7210:
7211: f_dummy := f_dummy + 1;
7212:
7213: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7214: -- gms_event_attribute table from temporary table.
7215:
7216: CREATE_PA_EVENTS (X_project_id ,
7217: X_Calling_Process ,

Line 7216: CREATE_PA_EVENTS (X_project_id ,

7212:
7213: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7214: -- gms_event_attribute table from temporary table.
7215:
7216: CREATE_PA_EVENTS (X_project_id ,
7217: X_Calling_Process ,
7218: X_rev_or_bill_Date ,
7219: X_Carrying_Out_Org_Id,
7220: X_Request_Id ,

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

7356: f_non_labor_neg_exp_processed); /* Added for bug 5026657 */
7357:
7358: g_non_labor_neg_exp_processed := f_non_labor_neg_exp_processed ; /* Added for bug 5026657 */
7359:
7360: -- Bug 3235390 : Calling the CREATE_PA_EVENTS procedure to insert records in pa_events
7361: -- gms_event_attribute table from temporary table.
7362:
7363: /* Added for bug 5026657 */
7364: IF (g_labor_exp_to_process = 'Y' and g_non_labor_neg_exp_processed = 'Y') THEN

Line 7384: CREATE_PA_EVENTS (X_project_id ,

7380: ( X_Revenue_Limit_Flag = 'Y' AND g_process_again = 'N' ) ) THEN -- %%%%%%%
7381:
7382: f_dummy := f_dummy + 1;
7383:
7384: CREATE_PA_EVENTS (X_project_id ,
7385: X_Calling_Process ,
7386: X_rev_or_bill_Date ,
7387: X_Rev_Carrying_Out_Org_Id,
7388: X_Request_Id ,