DBA Data[Home] [Help]

APPS.FUN_PERIOD_STATUS_PKG dependencies on FND_GLOBAL

Line 776: fnd_global.user_id,

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,

Line 778: fnd_global.user_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,

Line 780: fnd_global.login_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,

Line 877: fnd_global.user_id,

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,

Line 879: fnd_global.user_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,

Line 881: fnd_global.login_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,

Line 938: fnd_global.user_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,

Line 940: fnd_global.user_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,

Line 942: fnd_global.login_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,
945: INIT_AMOUNT_CR,
946: INIT_AMOUNT_DR,

Line 991: fnd_global.user_id,

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,

Line 993: fnd_global.user_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,

Line 995: fnd_global.login_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,

Line 1043: LAST_UPDATED_BY = fnd_global.user_id,

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');

Line 1045: LAST_UPDATE_LOGIN = fnd_global.login_id

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

Line 1056: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 1058: LAST_UPDATE_LOGIN = fnd_global.login_id

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:

Line 1338: ,FND_GLOBAL.LOGIN_ID

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

Line 1339: ,FND_GLOBAL.LOGIN_ID

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

Line 1341: ,FND_GLOBAL.LOGIN_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
1344: ,inteco_period_type
1345: from gl_periods,fun_system_options

Line 1376: ,FND_GLOBAL.LOGIN_ID

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

Line 1377: ,FND_GLOBAL.LOGIN_ID

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

Line 1379: ,FND_GLOBAL.LOGIN_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
1382: ,INTECO_PERIOD_TYPE
1383: from gl_periods,