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 1616: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND

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

Line 1617: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN

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

Line 1620: PA_PROJ_ACCUM_MAIN.x_current_start_date,

1616: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_current_start_date AND
1617: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1618:
1619: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1620: PA_PROJ_ACCUM_MAIN.x_current_start_date,
1621: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1622:
1623: END IF;
1624:

Line 1621: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);

1617: x_from_date <= PA_PROJ_ACCUM_MAIN.x_current_end_date THEN
1618:
1619: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1620: PA_PROJ_ACCUM_MAIN.x_current_start_date,
1621: PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1622:
1623: END IF;
1624:
1625: ELSIF x_which_date_flag = 'P' THEN

Line 1631: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND

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

Line 1632: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN

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

Line 1635: PA_PROJ_ACCUM_MAIN.x_prev_start_date,

1631: IF x_to_date >= PA_PROJ_ACCUM_MAIN.x_prev_start_date AND
1632: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1633:
1634: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1635: PA_PROJ_ACCUM_MAIN.x_prev_start_date,
1636: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);
1637:
1638: END IF;
1639:

Line 1636: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);

1632: x_from_date <= PA_PROJ_ACCUM_MAIN.x_prev_end_date THEN
1633:
1634: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1635: PA_PROJ_ACCUM_MAIN.x_prev_start_date,
1636: PA_PROJ_ACCUM_MAIN.x_prev_end_date, x_amt_to_be_spread);
1637:
1638: END IF;
1639:
1640: ELSIF x_which_date_flag = 'Y' THEN

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

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

Line 1646: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN

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

Line 1649: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,

1645: IF NOT (x_to_date < PA_PROJ_ACCUM_MAIN.x_period_yr_start_date OR
1646: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1647:
1648: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1649: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,
1650: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);
1651:
1652: END IF;
1653:

Line 1650: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);

1646: x_from_date > PA_PROJ_ACCUM_MAIN.x_period_yr_end_date) THEN
1647:
1648: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1649: PA_PROJ_ACCUM_MAIN.x_period_yr_start_date,
1650: PA_PROJ_ACCUM_MAIN.x_period_yr_end_date, x_amt_to_be_spread);
1651:
1652: END IF;
1653:
1654: ELSIF x_which_date_flag = 'I' THEN

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

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

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

1659:
1660: IF NOT (x_from_date > PA_PROJ_ACCUM_MAIN.x_current_end_date) THEN
1661:
1662: tmp_amt_returned := PA_MISC.spread_amount('L', x_from_date, x_to_date,
1663: x_from_date, PA_PROJ_ACCUM_MAIN.x_current_end_date, x_amt_to_be_spread);
1664:
1665: END IF;
1666:
1667: END IF;