772: l_batch_number,
773: p_sweep_GL_date,
774: 'NEW',
775: 'Original Batch: ' || l_partial_batch.BATCH_NUMBER,
776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.login_id,
774: 'NEW',
775: 'Original Batch: ' || l_partial_batch.BATCH_NUMBER,
776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.login_id,
781: INITIATOR_ID,
782: FROM_LE_ID,
776: fnd_global.user_id,
777: sysdate,
778: fnd_global.user_id,
779: sysdate,
780: fnd_global.login_id,
781: INITIATOR_ID,
782: FROM_LE_ID,
783: FROM_LEDGER_ID,
784: CONTROL_TOTAL,
873: l_batch_id,
874: 'NEW',
875: NULL,
876: NULL,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: sysdate,
881: fnd_global.login_id,
875: NULL,
876: NULL,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: sysdate,
881: fnd_global.login_id,
882: TRX_NUMBER,
883: INITIATOR_ID,
877: fnd_global.user_id,
878: sysdate,
879: fnd_global.user_id,
880: sysdate,
881: fnd_global.login_id,
882: TRX_NUMBER,
883: INITIATOR_ID,
884: RECIPIENT_ID,
885: TO_LE_ID,
934: RECI_AMOUNT_DR,
935: DESCRIPTION)
936: SELECT l_line_id,
937: l_header_trx_id,
938: fnd_global.user_id,
939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.login_id,
936: SELECT l_line_id,
937: l_header_trx_id,
938: fnd_global.user_id,
939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.login_id,
943: LINE_NUMBER,
944: LINE_TYPE_FLAG,
938: fnd_global.user_id,
939: sysdate,
940: fnd_global.user_id,
941: sysdate,
942: fnd_global.login_id,
943: LINE_NUMBER,
944: LINE_TYPE_FLAG,
945: INIT_AMOUNT_CR,
946: INIT_AMOUNT_DR,
987: ATTRIBUTE_CATEGORY)
988: SELECT l_header_trx_id,
989: FUN_DIST_LINES_S.nextval,
990: l_line_id,
991: fnd_global.user_id,
992: sysdate,
993: fnd_global.user_id,
994: sysdate,
995: fnd_global.login_id,
989: FUN_DIST_LINES_S.nextval,
990: l_line_id,
991: fnd_global.user_id,
992: sysdate,
993: fnd_global.user_id,
994: sysdate,
995: fnd_global.login_id,
996: DIST_NUMBER,
997: PARTY_ID,
991: fnd_global.user_id,
992: sysdate,
993: fnd_global.user_id,
994: sysdate,
995: fnd_global.login_id,
996: DIST_NUMBER,
997: PARTY_ID,
998: PARTY_TYPE_FLAG,
999: DIST_TYPE_FLAG,
1039: -- Update status of old transactions
1040: UPDATE FUN_TRX_HEADERS
1041: SET STATUS = 'REJECTED',
1042: REJECT_REASON = 'Swept to New Batch ' || l_batch_number,
1043: LAST_UPDATED_BY = fnd_global.user_id,
1044: LAST_UPDATE_DATE = sysdate,
1045: LAST_UPDATE_LOGIN = fnd_global.login_id
1046: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1047: AND STATUS IN ('SENT','ERROR','RECEIVED');
1041: SET STATUS = 'REJECTED',
1042: REJECT_REASON = 'Swept to New Batch ' || l_batch_number,
1043: LAST_UPDATED_BY = fnd_global.user_id,
1044: LAST_UPDATE_DATE = sysdate,
1045: LAST_UPDATE_LOGIN = fnd_global.login_id
1046: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1047: AND STATUS IN ('SENT','ERROR','RECEIVED');
1048:
1049: -- Update status of old batch to complete
1052: FROM DUAL
1053: WHERE EXISTS (SELECT 'X' FROM FUN_TRX_HEADERS
1054: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1055: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1056: LAST_UPDATED_BY = fnd_global.user_id,
1057: LAST_UPDATE_DATE = sysdate,
1058: LAST_UPDATE_LOGIN = fnd_global.login_id
1059: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
1060:
1054: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1055: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1056: LAST_UPDATED_BY = fnd_global.user_id,
1057: LAST_UPDATE_DATE = sysdate,
1058: LAST_UPDATE_LOGIN = fnd_global.login_id
1059: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
1060:
1061: END LOOP;
1062:
1334: ,QUARTER_START_DATE
1335: ,'N'
1336: ,p_trx_type_id
1337: ,PERIOD_NUM
1338: ,FND_GLOBAL.LOGIN_ID
1339: ,FND_GLOBAL.LOGIN_ID
1340: ,SYSDATE
1341: ,FND_GLOBAL.LOGIN_ID
1342: ,sysdate
1335: ,'N'
1336: ,p_trx_type_id
1337: ,PERIOD_NUM
1338: ,FND_GLOBAL.LOGIN_ID
1339: ,FND_GLOBAL.LOGIN_ID
1340: ,SYSDATE
1341: ,FND_GLOBAL.LOGIN_ID
1342: ,sysdate
1343: ,inteco_calendar
1337: ,PERIOD_NUM
1338: ,FND_GLOBAL.LOGIN_ID
1339: ,FND_GLOBAL.LOGIN_ID
1340: ,SYSDATE
1341: ,FND_GLOBAL.LOGIN_ID
1342: ,sysdate
1343: ,inteco_calendar
1344: ,inteco_period_type
1345: from gl_periods,fun_system_options
1372: ,QUARTER_START_DATE
1373: ,'N'
1374: ,p_trx_type_id
1375: ,PERIOD_NUM
1376: ,FND_GLOBAL.LOGIN_ID
1377: ,FND_GLOBAL.LOGIN_ID
1378: ,SYSDATE
1379: ,FND_GLOBAL.LOGIN_ID
1380: ,sysdate
1373: ,'N'
1374: ,p_trx_type_id
1375: ,PERIOD_NUM
1376: ,FND_GLOBAL.LOGIN_ID
1377: ,FND_GLOBAL.LOGIN_ID
1378: ,SYSDATE
1379: ,FND_GLOBAL.LOGIN_ID
1380: ,sysdate
1381: ,INTECO_CALENDAR
1375: ,PERIOD_NUM
1376: ,FND_GLOBAL.LOGIN_ID
1377: ,FND_GLOBAL.LOGIN_ID
1378: ,SYSDATE
1379: ,FND_GLOBAL.LOGIN_ID
1380: ,sysdate
1381: ,INTECO_CALENDAR
1382: ,INTECO_PERIOD_TYPE
1383: from gl_periods,