1023: , X_user => X_user
1024: , X_login => X_login
1025: , X_status => temp_status );
1026:
1027: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1028:
1029: END IF;
1030:
1031: IF ( X_calling_process = 'TRX_IMPORT' ) THEN
1034: END IF;
1035:
1036: IF ( AdjEiTab(i) IS NOT NULL ) THEN ---{
1037:
1038: pa_adjustments.InsAuditRec( X_exp_item_id => AdjEiTab(i)
1039: , X_adj_activity => 'MANUAL BACK-OUT ORIGINATING'
1040: , X_module => X_module
1041: , X_user => X_user
1042: , X_login => X_login
1044: IF P_DEBUG_MODE THEN
1045: pa_cc_utils.log_message('InsItems: ' || 'After call to InsAuditRec');
1046: END IF;
1047:
1048: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1049:
1050: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1051: , X_adj_activity => 'MANUAL BACK-OUT'
1052: , X_module => X_module
1046: END IF;
1047:
1048: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1049:
1050: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1051: , X_adj_activity => 'MANUAL BACK-OUT'
1052: , X_module => X_module
1053: , X_user => X_user
1054: , X_login => X_login
1053: , X_user => X_user
1054: , X_login => X_login
1055: , X_status => temp_status
1056: /* R12 Changes Start */
1057: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1058: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1059: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1060: , X_who_prog_upd_date => sysdate);
1061: /* R12 Changes End */
1054: , X_login => X_login
1055: , X_status => temp_status
1056: /* R12 Changes Start */
1057: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1058: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1059: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1060: , X_who_prog_upd_date => sysdate);
1061: /* R12 Changes End */
1062:
1055: , X_status => temp_status
1056: /* R12 Changes Start */
1057: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1058: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1059: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1060: , X_who_prog_upd_date => sysdate);
1061: /* R12 Changes End */
1062:
1063: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1059: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1060: , X_who_prog_upd_date => sysdate);
1061: /* R12 Changes End */
1062:
1063: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1064:
1065: pa_adjustments.SetNetZero( X_exp_item_id => AdjEiTab(i)
1066: , X_user => X_user
1067: , X_login => X_login
1061: /* R12 Changes End */
1062:
1063: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1064:
1065: pa_adjustments.SetNetZero( X_exp_item_id => AdjEiTab(i)
1066: , X_user => X_user
1067: , X_login => X_login
1068: , X_status => temp_status );
1069: IF P_DEBUG_MODE THEN
1087: and cdl1.reversed_flag is NULL
1088: and cdl1.line_num_reversed is NULL ;
1089: END IF ; --}
1090:
1091: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1092:
1093: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => AdjEiTab(i)
1094: , X_expenditure_id => NULL
1095: , X_module => X_module
1089: END IF ; --}
1090:
1091: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1092:
1093: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => AdjEiTab(i)
1094: , X_expenditure_id => NULL
1095: , X_module => X_module
1096: , X_user => X_user
1097: , X_login => X_login
1099: IF P_DEBUG_MODE THEN
1100: pa_cc_utils.log_message('InsItems: ' || 'After call to ReverseRelatedItems');
1101: END IF;
1102:
1103: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1104:
1105: END IF; ---}
1106: END IF; ---}
1107:
1110: /* Bug 5501593 - Start */
1111: IF X_calling_process = 'TRANSFER' THEN
1112: FOR i IN 1..Rows LOOP
1113: /* Audit trail for the original expenditure item */
1114: pa_adjustments.InsAuditRec( X_exp_item_id => TfrEiTab(i)
1115: , X_adj_activity => 'TRANSFER ORIGINATING'
1116: , X_module => X_module
1117: , X_user => X_user
1118: , X_login => X_login
1116: , X_module => X_module
1117: , X_user => X_user
1118: , X_login => X_login
1119: , X_status => temp_status
1120: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1121: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1122: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1123: , X_who_prog_upd_date => sysdate);
1124: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1117: , X_user => X_user
1118: , X_login => X_login
1119: , X_status => temp_status
1120: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1121: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1122: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1123: , X_who_prog_upd_date => sysdate);
1124: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1125:
1118: , X_login => X_login
1119: , X_status => temp_status
1120: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1121: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1122: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1123: , X_who_prog_upd_date => sysdate);
1124: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1125:
1126: /* Audit trail for new expenditure item */
1120: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1121: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1122: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1123: , X_who_prog_upd_date => sysdate);
1124: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1125:
1126: /* Audit trail for new expenditure item */
1127: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1128: , X_adj_activity => 'TRANSFER DESTINATION'
1123: , X_who_prog_upd_date => sysdate);
1124: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1125:
1126: /* Audit trail for new expenditure item */
1127: pa_adjustments.InsAuditRec( X_exp_item_id => EiIdTab(i)
1128: , X_adj_activity => 'TRANSFER DESTINATION'
1129: , X_module => X_module
1130: , X_user => X_user
1131: , X_login => X_login
1129: , X_module => X_module
1130: , X_user => X_user
1131: , X_login => X_login
1132: , X_status => temp_status
1133: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1134: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1135: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1136: , X_who_prog_upd_date => sysdate);
1137: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1130: , X_user => X_user
1131: , X_login => X_login
1132: , X_status => temp_status
1133: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1134: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1135: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1136: , X_who_prog_upd_date => sysdate);
1137: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1138:
1131: , X_login => X_login
1132: , X_status => temp_status
1133: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1134: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1135: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1136: , X_who_prog_upd_date => sysdate);
1137: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1138:
1139: /* Get the expenditure Item IDs for all reversinf EIs */
1133: , X_who_req_id => pa_adjustments.G_REQUEST_ID
1134: , X_who_prog_id => pa_adjustments.G_PROGRAM_ID
1135: , X_who_prog_app_id => pa_adjustments.G_PROG_APPL_ID
1136: , X_who_prog_upd_date => sysdate);
1137: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1138:
1139: /* Get the expenditure Item IDs for all reversinf EIs */
1140: BackoutItemID(i) := pa_utils.GetNextEiId;
1141: END LOOP;
1395: , X_ei_comment => item_comment
1396: , X_user => X_user
1397: , X_login => X_login
1398: , X_status => temp_status );
1399: pa_adjustments.CheckStatus( status_indicator => temp_status );
1400: END IF;
1401:
1402: /* Set Net Zero Flag on the Original Expenditure Item */
1403: pa_adjustments.SetNetZero( TfrEiTab(i)
1399: pa_adjustments.CheckStatus( status_indicator => temp_status );
1400: END IF;
1401:
1402: /* Set Net Zero Flag on the Original Expenditure Item */
1403: pa_adjustments.SetNetZero( TfrEiTab(i)
1404: , X_user
1405: , X_login
1406: , temp_status );
1407: pa_adjustments.CheckStatus( temp_status );
1403: pa_adjustments.SetNetZero( TfrEiTab(i)
1404: , X_user
1405: , X_login
1406: , temp_status );
1407: pa_adjustments.CheckStatus( temp_status );
1408:
1409: /* Create an Audit trail */
1410: pa_adjustments.InsAuditRec( BackoutItemID(i)
1411: , 'TRANSFER BACK-OUT'
1406: , temp_status );
1407: pa_adjustments.CheckStatus( temp_status );
1408:
1409: /* Create an Audit trail */
1410: pa_adjustments.InsAuditRec( BackoutItemID(i)
1411: , 'TRANSFER BACK-OUT'
1412: , X_module
1413: , X_user
1414: , X_login
1412: , X_module
1413: , X_user
1414: , X_login
1415: , temp_status
1416: , pa_adjustments.G_REQUEST_ID
1417: , pa_adjustments.G_PROGRAM_ID
1418: , pa_adjustments.G_PROG_APPL_ID
1419: , sysdate );
1420: pa_adjustments.CheckStatus( temp_status );
1413: , X_user
1414: , X_login
1415: , temp_status
1416: , pa_adjustments.G_REQUEST_ID
1417: , pa_adjustments.G_PROGRAM_ID
1418: , pa_adjustments.G_PROG_APPL_ID
1419: , sysdate );
1420: pa_adjustments.CheckStatus( temp_status );
1421:
1414: , X_login
1415: , temp_status
1416: , pa_adjustments.G_REQUEST_ID
1417: , pa_adjustments.G_PROGRAM_ID
1418: , pa_adjustments.G_PROG_APPL_ID
1419: , sysdate );
1420: pa_adjustments.CheckStatus( temp_status );
1421:
1422: /* Create a reversing CDL */
1416: , pa_adjustments.G_REQUEST_ID
1417: , pa_adjustments.G_PROGRAM_ID
1418: , pa_adjustments.G_PROG_APPL_ID
1419: , sysdate );
1420: pa_adjustments.CheckStatus( temp_status );
1421:
1422: /* Create a reversing CDL */
1423: Pa_Costing.CreateReverseCdl( X_exp_item_id => TfrEiTab(i),
1424: X_backout_id => BackoutItemID(i),
1423: Pa_Costing.CreateReverseCdl( X_exp_item_id => TfrEiTab(i),
1424: X_backout_id => BackoutItemID(i),
1425: X_user => X_user,
1426: X_status => temp_status);
1427: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1428:
1429: /* Reverse Related Items */
1430: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => TfrEiTab(i)
1431: , X_expenditure_id => NULL
1426: X_status => temp_status);
1427: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1428:
1429: /* Reverse Related Items */
1430: pa_adjustments.ReverseRelatedItems( X_source_exp_item_id => TfrEiTab(i)
1431: , X_expenditure_id => NULL
1432: , X_module => X_module
1433: , X_user => X_user
1434: , X_login => X_login
1432: , X_module => X_module
1433: , X_user => X_user
1434: , X_login => X_login
1435: , X_status => temp_status );
1436: Pa_Adjustments.CheckStatus( status_indicator => temp_status );
1437: END LOOP;
1438: END IF;
1439: /* Bug 5501593 - End */
1440: