1115: , X_user => X_user
1116: , X_login => X_login
1117: , X_status => temp_status );
1118:
1119: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1120:
1121: END IF;
1122:
1123: IF ( X_calling_process = 'TRX_IMPORT' ) THEN
1126: END IF;
1127:
1128: IF ( AdjEiTab(i) IS NOT NULL ) THEN ---{
1129:
1130: pa_adjustments.InsAuditRec( X_exp_item_id => AdjEiTab(i)
1131: , X_adj_activity => 'MANUAL BACK-OUT ORIGINATING'
1132: , X_module => X_module
1133: , X_user => X_user
1134: , X_login => X_login
1136: IF P_DEBUG_MODE THEN
1137: pa_cc_utils.log_message('InsItems: ' || 'After call to InsAuditRec');
1138: END IF;
1139:
1140: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1141:
1142: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1143: , X_adj_activity => 'MANUAL BACK-OUT'
1144: , X_module => X_module
1138: END IF;
1139:
1140: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1141:
1142: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1143: , X_adj_activity => 'MANUAL BACK-OUT'
1144: , X_module => X_module
1145: , X_user => X_user
1146: , X_login => X_login
1145: , X_user => X_user
1146: , X_login => X_login
1147: , X_status => temp_status
1148: /* R12 Changes Start */
1149: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1150: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1151: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1152: , X_who_prog_upd_date => sysdate);
1153: /* R12 Changes End */
1146: , X_login => X_login
1147: , X_status => temp_status
1148: /* R12 Changes Start */
1149: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1150: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1151: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1152: , X_who_prog_upd_date => sysdate);
1153: /* R12 Changes End */
1154:
1147: , X_status => temp_status
1148: /* R12 Changes Start */
1149: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1150: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1151: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1152: , X_who_prog_upd_date => sysdate);
1153: /* R12 Changes End */
1154:
1155: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1151: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1152: , X_who_prog_upd_date => sysdate);
1153: /* R12 Changes End */
1154:
1155: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1156:
1157: pa_adjustments.SetNetZero( X_exp_item_id => AdjEiTab(i)
1158: , X_user => X_user
1159: , X_login => X_login
1153: /* R12 Changes End */
1154:
1155: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1156:
1157: pa_adjustments.SetNetZero( X_exp_item_id => AdjEiTab(i)
1158: , X_user => X_user
1159: , X_login => X_login
1160: , X_status => temp_status );
1161: IF P_DEBUG_MODE THEN
1179: and cdl1.reversed_flag is NULL
1180: and cdl1.line_num_reversed is NULL ;
1181: END IF ; --}
1182:
1183: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1184:
1185: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => AdjEiTab(i)
1186: , X_expenditure_id => NULL
1187: , X_module => X_module
1181: END IF ; --}
1182:
1183: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1184:
1185: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => AdjEiTab(i)
1186: , X_expenditure_id => NULL
1187: , X_module => X_module
1188: , X_user => X_user
1189: , X_login => X_login
1191: IF P_DEBUG_MODE THEN
1192: pa_cc_utils.log_message('InsItems: ' || 'After call to ReverseRelatedItems');
1193: END IF;
1194:
1195: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1196:
1197: END IF; ---}
1198: END IF; ---}
1199:
1202: /* Bug 5501593 - Start */
1203: IF X_calling_process = 'TRANSFER' THEN
1204: FOR i IN 1..Rows LOOP
1205: /* Audit trail for the original expenditure item */
1206: pa_adjustments.InsAuditRec( X_exp_item_id => TfrEiTab(i)
1207: , X_adj_activity => 'TRANSFER ORIGINATING'
1208: , X_module => X_module
1209: , X_user => X_user
1210: , X_login => X_login
1208: , X_module => X_module
1209: , X_user => X_user
1210: , X_login => X_login
1211: , X_status => temp_status
1212: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1213: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1214: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1215: , X_who_prog_upd_date => sysdate);
1216: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1209: , X_user => X_user
1210: , X_login => X_login
1211: , X_status => temp_status
1212: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1213: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1214: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1215: , X_who_prog_upd_date => sysdate);
1216: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1217:
1210: , X_login => X_login
1211: , X_status => temp_status
1212: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1213: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1214: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1215: , X_who_prog_upd_date => sysdate);
1216: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1217:
1218: /* Audit trail for new expenditure item */
1212: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1213: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1214: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1215: , X_who_prog_upd_date => sysdate);
1216: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1217:
1218: /* Audit trail for new expenditure item */
1219: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1220: , X_adj_activity => 'TRANSFER DESTINATION'
1215: , X_who_prog_upd_date => sysdate);
1216: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1217:
1218: /* Audit trail for new expenditure item */
1219: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1220: , X_adj_activity => 'TRANSFER DESTINATION'
1221: , X_module => X_module
1222: , X_user => X_user
1223: , X_login => X_login
1221: , X_module => X_module
1222: , X_user => X_user
1223: , X_login => X_login
1224: , X_status => temp_status
1225: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1226: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1227: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1228: , X_who_prog_upd_date => sysdate);
1229: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1222: , X_user => X_user
1223: , X_login => X_login
1224: , X_status => temp_status
1225: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1226: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1227: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1228: , X_who_prog_upd_date => sysdate);
1229: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1230:
1223: , X_login => X_login
1224: , X_status => temp_status
1225: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1226: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1227: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1228: , X_who_prog_upd_date => sysdate);
1229: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1230:
1231: /* Get the expenditure Item IDs for all reversinf EIs */
1225: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1226: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1227: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1228: , X_who_prog_upd_date => sysdate);
1229: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1230:
1231: /* Get the expenditure Item IDs for all reversinf EIs */
1232: BackoutItemID(i) := pa_utils.GetNextEiId;
1233: END LOOP;
1512: , X_ei_comment => item_comment
1513: , X_user => X_user
1514: , X_login => X_login
1515: , X_status => temp_status );
1516: pa_adjustments.CheckStatus( status_indicator => temp_status );
1517: END IF;
1518:
1519: /* Set Net Zero Flag on the Original Expenditure Item */
1520: pa_adjustments.SetNetZero( TfrEiTab(i)
1516: pa_adjustments.CheckStatus( status_indicator => temp_status );
1517: END IF;
1518:
1519: /* Set Net Zero Flag on the Original Expenditure Item */
1520: pa_adjustments.SetNetZero( TfrEiTab(i)
1521: , X_user
1522: , X_login
1523: , temp_status );
1524: pa_adjustments.CheckStatus( temp_status );
1520: pa_adjustments.SetNetZero( TfrEiTab(i)
1521: , X_user
1522: , X_login
1523: , temp_status );
1524: pa_adjustments.CheckStatus( temp_status );
1525:
1526: /* Create an Audit trail */
1527: pa_adjustments.InsAuditRec( BackoutItemID(i)
1528: , 'TRANSFER BACK-OUT'
1523: , temp_status );
1524: pa_adjustments.CheckStatus( temp_status );
1525:
1526: /* Create an Audit trail */
1527: pa_adjustments.InsAuditRec( BackoutItemID(i)
1528: , 'TRANSFER BACK-OUT'
1529: , X_module
1530: , X_user
1531: , X_login
1529: , X_module
1530: , X_user
1531: , X_login
1532: , temp_status
1533: , pa_adjustments.G_REQUEST_ID
1534: , pa_adjustments.G_PROGRAM_ID
1535: , pa_adjustments.G_PROG_APPL_ID
1536: , sysdate );
1537: pa_adjustments.CheckStatus( temp_status );
1530: , X_user
1531: , X_login
1532: , temp_status
1533: , pa_adjustments.G_REQUEST_ID
1534: , pa_adjustments.G_PROGRAM_ID
1535: , pa_adjustments.G_PROG_APPL_ID
1536: , sysdate );
1537: pa_adjustments.CheckStatus( temp_status );
1538:
1531: , X_login
1532: , temp_status
1533: , pa_adjustments.G_REQUEST_ID
1534: , pa_adjustments.G_PROGRAM_ID
1535: , pa_adjustments.G_PROG_APPL_ID
1536: , sysdate );
1537: pa_adjustments.CheckStatus( temp_status );
1538:
1539: /* Create a reversing CDL */
1533: , pa_adjustments.G_REQUEST_ID
1534: , pa_adjustments.G_PROGRAM_ID
1535: , pa_adjustments.G_PROG_APPL_ID
1536: , sysdate );
1537: pa_adjustments.CheckStatus( temp_status );
1538:
1539: /* Create a reversing CDL */
1540: Pa_Costing.CreateReverseCdl( X_exp_item_id => TfrEiTab(i),
1541: X_backout_id => BackoutItemID(i),
1540: Pa_Costing.CreateReverseCdl( X_exp_item_id => TfrEiTab(i),
1541: X_backout_id => BackoutItemID(i),
1542: X_user => X_user,
1543: X_status => temp_status);
1544: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1545:
1546: /* Reverse Related Items */
1547: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => TfrEiTab(i)
1548: , X_expenditure_id => NULL
1543: X_status => temp_status);
1544: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1545:
1546: /* Reverse Related Items */
1547: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => TfrEiTab(i)
1548: , X_expenditure_id => NULL
1549: , X_module => X_module
1550: , X_user => X_user
1551: , X_login => X_login
1549: , X_module => X_module
1550: , X_user => X_user
1551: , X_login => X_login
1552: , X_status => temp_status );
1553: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1554: END LOOP;
1555: END IF;
1556: /* Bug 5501593 - End */
1557: