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_ACCUM_UTILS dependencies on PA_PROJ_ACCUM_MAIN

Line 105: pa_proj_accum_main.x_last_updated_by,

101: 0,
102: 0,
103: 0,
104: trunc(sysdate),
105: pa_proj_accum_main.x_last_updated_by,
106: pa_proj_accum_main.x_request_id,
107: trunc(sysdate),
108: pa_proj_accum_main.x_created_by,
109: pa_proj_accum_main.x_last_update_login );

Line 106: pa_proj_accum_main.x_request_id,

102: 0,
103: 0,
104: trunc(sysdate),
105: pa_proj_accum_main.x_last_updated_by,
106: pa_proj_accum_main.x_request_id,
107: trunc(sysdate),
108: pa_proj_accum_main.x_created_by,
109: pa_proj_accum_main.x_last_update_login );
110: -- Create Actuals record for the Project level record

Line 108: pa_proj_accum_main.x_created_by,

104: trunc(sysdate),
105: pa_proj_accum_main.x_last_updated_by,
106: pa_proj_accum_main.x_request_id,
107: trunc(sysdate),
108: pa_proj_accum_main.x_created_by,
109: pa_proj_accum_main.x_last_update_login );
110: -- Create Actuals record for the Project level record
111:
112: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 109: pa_proj_accum_main.x_last_update_login );

105: pa_proj_accum_main.x_last_updated_by,
106: pa_proj_accum_main.x_request_id,
107: trunc(sysdate),
108: pa_proj_accum_main.x_created_by,
109: pa_proj_accum_main.x_last_update_login );
110: -- Create Actuals record for the Project level record
111:
112: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
113: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Actuals');

Line 132: 0,0,0,0,0,0,0,0,0,0,0,0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

128: REVENUE_YTD,REVENUE_PP,REVENUE_PTD,TXN_UNIT_OF_MEASURE,
129: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
130: LAST_UPDATE_LOGIN) VALUES
131: (V_Accum_id,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
132: 0,0,0,0,0,0,0,0,0,0,0,0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
133: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
134:
135: -- Create commitments record for the Project level record
136:

Line 133: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

129: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
130: LAST_UPDATE_LOGIN) VALUES
131: (V_Accum_id,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
132: 0,0,0,0,0,0,0,0,0,0,0,0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
133: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
134:
135: -- Create commitments record for the Project level record
136:
137: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 148: (V_Accum_Id,0,0,0,0,0,0,0,0,0,0,0,0,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),

144: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,
145: CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,CMT_QUANTITY_PTD,
146: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
147: LAST_UPDATE_LOGIN ) VALUES
148: (V_Accum_Id,0,0,0,0,0,0,0,0,0,0,0,0,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),
149: Trunc(Sysdate), pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
150: x_Accum_id := V_Accum_id;
151: x_prev_accum_period := Null;
152: -- Restore the old x_err_stack;

Line 149: Trunc(Sysdate), pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

145: CMT_QUANTITY_ITD,CMT_QUANTITY_YTD,CMT_QUANTITY_PP,CMT_QUANTITY_PTD,
146: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
147: LAST_UPDATE_LOGIN ) VALUES
148: (V_Accum_Id,0,0,0,0,0,0,0,0,0,0,0,0,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),
149: Trunc(Sysdate), pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
150: x_Accum_id := V_Accum_id;
151: x_prev_accum_period := Null;
152: -- Restore the old x_err_stack;
153: x_err_stack := V_Old_Stack;

Line 578: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

574: 0,0,0,
575: 0,0,0,0,0,0,0,0,
576: 0,0,0,0,0,0,0,
577: 0,0,0,0,
578: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
579: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
580: V_recs_processed := 1;
581: End If;
582: Close Get_Accum_Id_Cur;

Line 579: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

575: 0,0,0,0,0,0,0,0,
576: 0,0,0,0,0,0,0,
577: 0,0,0,0,
578: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
579: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
580: V_recs_processed := 1;
581: End If;
582: Close Get_Accum_Id_Cur;
583: V_noof_Tasks := 0;

Line 622: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

618: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
619: LAST_UPDATE_LOGIN)
620: Select PAH.PROJECT_ACCUM_ID,0,0,0,0,0,0,0,0,0,0,0,0,0,
621: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
622: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
623: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
624: from
625: PA_PROJECT_ACCUM_HEADERS PAH
626: Where Project_Id = x_project_id

Line 623: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login

619: LAST_UPDATE_LOGIN)
620: Select PAH.PROJECT_ACCUM_ID,0,0,0,0,0,0,0,0,0,0,0,0,0,
621: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
622: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
623: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
624: from
625: PA_PROJECT_ACCUM_HEADERS PAH
626: Where Project_Id = x_project_id
627: and Task_id = v_task_array(i)

Line 719: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

715: LAST_UPDATE_LOGIN) Values
716: (v_Accum_id,0,0,0,0,
717: 0,0,0,0,
718: 0,0,0,0,
719: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
720: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
721: v_recs_processed := 1;
722: End If;
723: Close Get_Accum_Id_Cur;

Line 720: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

716: (v_Accum_id,0,0,0,0,
717: 0,0,0,0,
718: 0,0,0,0,
719: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
720: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
721: v_recs_processed := 1;
722: End If;
723: Close Get_Accum_Id_Cur;
724: V_noof_Tasks := 0;

Line 758: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),

754: CMT_UNIT_OF_MEASURE,
755: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
756: LAST_UPDATE_LOGIN)
757: Select PROJECT_ACCUM_ID,0,0,0,0,0,0,0,0,0,0,0,0,
758: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
759: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
760: from PA_PROJECT_ACCUM_HEADERS PAH
761: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
762: Resource_list_member_id = x_Resource_list_member_id and

Line 759: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login

755: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
756: LAST_UPDATE_LOGIN)
757: Select PROJECT_ACCUM_ID,0,0,0,0,0,0,0,0,0,0,0,0,
758: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
759: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
760: from PA_PROJECT_ACCUM_HEADERS PAH
761: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
762: Resource_list_member_id = x_Resource_list_member_id and
763: Not Exists (Select 'x' from PA_PROJECT_ACCUM_COMMITMENTS PAC Where

Line 865: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);

861: REQUEST_ID,LAST_UPDATED_BY,LAST_UPDATE_DATE,CREATION_DATE,CREATED_BY,
862: LAST_UPDATE_LOGIN) Values
863: (V_Accum_id,x_budget_type_code,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
864: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,
865: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login);
866: v_recs_processed := 1;
867: End If;
868: Close Get_Accum_Id_Cur;
869: V_noof_Tasks := 0;

Line 921: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login

917: LAST_UPDATE_LOGIN)
918: Select PROJECT_ACCUM_ID,x_budget_type_code,0,0,0,0,0,0,0,0,0,0,
919: 0,0,0,0,0,0,0,0,0,0,
920: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,
921: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
922: from PA_PROJECT_ACCUM_HEADERS PAH
923: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
924: Resource_list_member_id = x_Resource_list_member_id and
925: Not Exists (Select 'x' from PA_PROJECT_ACCUM_BUDGETS PAB Where

Line 1111: request_id = pa_proj_accum_main.x_request_id,

1107:
1108: UPDATE pa_project_accum_headers
1109: SET
1110: accum_period = x_accum_period,
1111: request_id = pa_proj_accum_main.x_request_id,
1112: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1113: last_update_date = TRUNC(SYSDATE),
1114: last_update_login = pa_proj_accum_main.x_last_update_login
1115: WHERE project_accum_id = x_project_accum_id;

Line 1112: last_updated_by = pa_proj_accum_main.x_last_updated_by,

1108: UPDATE pa_project_accum_headers
1109: SET
1110: accum_period = x_accum_period,
1111: request_id = pa_proj_accum_main.x_request_id,
1112: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1113: last_update_date = TRUNC(SYSDATE),
1114: last_update_login = pa_proj_accum_main.x_last_update_login
1115: WHERE project_accum_id = x_project_accum_id;
1116:

Line 1114: last_update_login = pa_proj_accum_main.x_last_update_login

1110: accum_period = x_accum_period,
1111: request_id = pa_proj_accum_main.x_request_id,
1112: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1113: last_update_date = TRUNC(SYSDATE),
1114: last_update_login = pa_proj_accum_main.x_last_update_login
1115: WHERE project_accum_id = x_project_accum_id;
1116:
1117: -- Restore the old x_err_stack;
1118:

Line 1152: request_id = pa_proj_accum_main.x_request_id,

1148:
1149: UPDATE pa_project_accum_headers
1150: SET
1151: tasks_restructured_flag = x_tasks_restructured_flag,
1152: request_id = pa_proj_accum_main.x_request_id,
1153: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1154: last_update_date = TRUNC(SYSDATE),
1155: last_update_login = pa_proj_accum_main.x_last_update_login
1156: WHERE project_accum_id = x_project_accum_id;

Line 1153: last_updated_by = pa_proj_accum_main.x_last_updated_by,

1149: UPDATE pa_project_accum_headers
1150: SET
1151: tasks_restructured_flag = x_tasks_restructured_flag,
1152: request_id = pa_proj_accum_main.x_request_id,
1153: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1154: last_update_date = TRUNC(SYSDATE),
1155: last_update_login = pa_proj_accum_main.x_last_update_login
1156: WHERE project_accum_id = x_project_accum_id;
1157:

Line 1155: last_update_login = pa_proj_accum_main.x_last_update_login

1151: tasks_restructured_flag = x_tasks_restructured_flag,
1152: request_id = pa_proj_accum_main.x_request_id,
1153: last_updated_by = pa_proj_accum_main.x_last_updated_by,
1154: last_update_date = TRUNC(SYSDATE),
1155: last_update_login = pa_proj_accum_main.x_last_update_login
1156: WHERE project_accum_id = x_project_accum_id;
1157:
1158: -- Restore the old x_err_stack;
1159:

Line 1612: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND

1608: -- PTD
1609: -- Budget End Date >= Period Start date and Budget Start Date
1610: -- <= Period End Date
1611:
1612: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND
1613: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1614:
1615: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1616: PA_PROJ_ACCUM_MAIN.x_current_start_date,

Line 1613: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN

1609: -- Budget End Date >= Period Start date and Budget Start Date
1610: -- <= Period End Date
1611:
1612: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND
1613: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1614:
1615: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1616: PA_PROJ_ACCUM_MAIN.x_current_start_date,
1617: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);

Line 1616: PA_PROJ_ACCUM_MAIN.x_current_start_date,

1612: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND
1613: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1614:
1615: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1616: PA_PROJ_ACCUM_MAIN.x_current_start_date,
1617: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1618:
1619: END IF;
1620:

Line 1617: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);

1613: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1614:
1615: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1616: PA_PROJ_ACCUM_MAIN.x_current_start_date,
1617: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1618:
1619: END IF;
1620:
1621: ELSIF x_which_date_flag = 'P' THEN

Line 1627: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND

1623: -- PP
1624: -- Budget End Date >= Period Start date and Budget Start Date
1625: -- <= Period End Date
1626:
1627: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND
1628: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1629:
1630: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1631: PA_PROJ_ACCUM_MAIN.x_prev_start_date,

Line 1628: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN

1624: -- Budget End Date >= Period Start date and Budget Start Date
1625: -- <= Period End Date
1626:
1627: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND
1628: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1629:
1630: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1631: PA_PROJ_ACCUM_MAIN.x_prev_start_date,
1632: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);

Line 1631: PA_PROJ_ACCUM_MAIN.x_prev_start_date,

1627: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND
1628: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1629:
1630: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1631: PA_PROJ_ACCUM_MAIN.x_prev_start_date,
1632: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);
1633:
1634: END IF;
1635:

Line 1632: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);

1628: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1629:
1630: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1631: PA_PROJ_ACCUM_MAIN.x_prev_start_date,
1632: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);
1633:
1634: END IF;
1635:
1636: ELSIF x_which_date_flag = 'Y' THEN

Line 1641: IF NOT (x_to_date < PA_PROJ_ACCUM_MAIN.x_period_yr_start_date OR

1637:
1638: -- YTD
1639: -- NOT (Budget End Date < Year Start Date OR Budget Start Date > Year End Date)
1640:
1641: IF NOT (x_to_date < PA_PROJ_ACCUM_MAIN.x_period_yr_start_date OR
1642: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1643:
1644: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1645: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,

Line 1642: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN

1638: -- YTD
1639: -- NOT (Budget End Date < Year Start Date OR Budget Start Date > Year End Date)
1640:
1641: IF NOT (x_to_date < PA_PROJ_ACCUM_MAIN.x_period_yr_start_date OR
1642: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1643:
1644: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1645: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,
1646: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);

Line 1645: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,

1641: IF NOT (x_to_date < PA_PROJ_ACCUM_MAIN.x_period_yr_start_date OR
1642: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1643:
1644: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1645: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,
1646: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);
1647:
1648: END IF;
1649:

Line 1646: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);

1642: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1643:
1644: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1645: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,
1646: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);
1647:
1648: END IF;
1649:
1650: ELSIF x_which_date_flag = 'I' THEN

Line 1656: IF NOT (x_from_date > PA_PROJ_ACCUM_MAIN.x_current_end_date) THEN

1652: -- ITD
1653: -- NOT (Budget Start Date > Period End Date AND Budget End Date >
1654: -- Period Start Date)
1655:
1656: IF NOT (x_from_date > PA_PROJ_ACCUM_MAIN.x_current_end_date) THEN
1657:
1658: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1659: x_from_date, PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1660:

Line 1659: x_from_date, PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);

1655:
1656: IF NOT (x_from_date > PA_PROJ_ACCUM_MAIN.x_current_end_date) THEN
1657:
1658: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1659: x_from_date, PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1660:
1661: END IF;
1662:
1663: END IF;