DBA Data[Home] [Help]

APPS.FUN_PERIOD_STATUS_PKG dependencies on FND_GLOBAL

Line 945: fnd_global.user_id,

941: l_batch_number,
942: p_sweep_GL_date,
943: 'NEW',
944: 'Original Batch: ' || l_partial_batch.BATCH_NUMBER,
945: fnd_global.user_id,
946: sysdate,
947: fnd_global.user_id,
948: sysdate,
949: fnd_global.login_id,

Line 947: fnd_global.user_id,

943: 'NEW',
944: 'Original Batch: ' || l_partial_batch.BATCH_NUMBER,
945: fnd_global.user_id,
946: sysdate,
947: fnd_global.user_id,
948: sysdate,
949: fnd_global.login_id,
950: INITIATOR_ID,
951: FROM_LE_ID,

Line 949: fnd_global.login_id,

945: fnd_global.user_id,
946: sysdate,
947: fnd_global.user_id,
948: sysdate,
949: fnd_global.login_id,
950: INITIATOR_ID,
951: FROM_LE_ID,
952: FROM_LEDGER_ID,
953: CONTROL_TOTAL,

Line 1046: fnd_global.user_id,

1042: l_batch_id,
1043: 'NEW',
1044: NULL,
1045: NULL,
1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.user_id,
1049: sysdate,
1050: fnd_global.login_id,

Line 1048: fnd_global.user_id,

1044: NULL,
1045: NULL,
1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.user_id,
1049: sysdate,
1050: fnd_global.login_id,
1051: TRX_NUMBER,
1052: INITIATOR_ID,

Line 1050: fnd_global.login_id,

1046: fnd_global.user_id,
1047: sysdate,
1048: fnd_global.user_id,
1049: sysdate,
1050: fnd_global.login_id,
1051: TRX_NUMBER,
1052: INITIATOR_ID,
1053: RECIPIENT_ID,
1054: TO_LE_ID,

Line 1185: X_last_updated_by => FND_GLOBAL.USER_ID,

1181: X_Rowid => l_attchmt_rec_type.ROWID,
1182: X_attached_document_id => l_attchmt_rec_type.ATTACHED_DOCUMENT_ID,
1183: X_document_id => l_attchmt_rec_type.DOCUMENT_ID,
1184: X_last_update_date => sysdate,
1185: X_last_updated_by => FND_GLOBAL.USER_ID,
1186: X_last_update_login => FND_GLOBAL.USER_ID,
1187: X_seq_num => l_attchmt_rec_type.SEQ_NUM,
1188: X_entity_name => l_attchmt_rec_type.ENTITY_NAME,
1189: X_column1 => l_attchmt_rec_type.COLUMN1,

Line 1186: X_last_update_login => FND_GLOBAL.USER_ID,

1182: X_attached_document_id => l_attchmt_rec_type.ATTACHED_DOCUMENT_ID,
1183: X_document_id => l_attchmt_rec_type.DOCUMENT_ID,
1184: X_last_update_date => sysdate,
1185: X_last_updated_by => FND_GLOBAL.USER_ID,
1186: X_last_update_login => FND_GLOBAL.USER_ID,
1187: X_seq_num => l_attchmt_rec_type.SEQ_NUM,
1188: X_entity_name => l_attchmt_rec_type.ENTITY_NAME,
1189: X_column1 => l_attchmt_rec_type.COLUMN1,
1190: X_pk1_value => l_header_trx_id,

Line 1274: fnd_global.user_id,

1270: RECI_AMOUNT_DR,
1271: DESCRIPTION)
1272: SELECT l_line_id,
1273: l_header_trx_id,
1274: fnd_global.user_id,
1275: sysdate,
1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.login_id,

Line 1276: fnd_global.user_id,

1272: SELECT l_line_id,
1273: l_header_trx_id,
1274: fnd_global.user_id,
1275: sysdate,
1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.login_id,
1279: LINE_NUMBER,
1280: LINE_TYPE_FLAG,

Line 1278: fnd_global.login_id,

1274: fnd_global.user_id,
1275: sysdate,
1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.login_id,
1279: LINE_NUMBER,
1280: LINE_TYPE_FLAG,
1281: INIT_AMOUNT_CR,
1282: INIT_AMOUNT_DR,

Line 1327: fnd_global.user_id,

1323: ATTRIBUTE_CATEGORY)
1324: SELECT l_header_trx_id,
1325: FUN_DIST_LINES_S.nextval,
1326: l_line_id,
1327: fnd_global.user_id,
1328: sysdate,
1329: fnd_global.user_id,
1330: sysdate,
1331: fnd_global.login_id,

Line 1329: fnd_global.user_id,

1325: FUN_DIST_LINES_S.nextval,
1326: l_line_id,
1327: fnd_global.user_id,
1328: sysdate,
1329: fnd_global.user_id,
1330: sysdate,
1331: fnd_global.login_id,
1332: DIST_NUMBER,
1333: PARTY_ID,

Line 1331: fnd_global.login_id,

1327: fnd_global.user_id,
1328: sysdate,
1329: fnd_global.user_id,
1330: sysdate,
1331: fnd_global.login_id,
1332: DIST_NUMBER,
1333: PARTY_ID,
1334: PARTY_TYPE_FLAG,
1335: DIST_TYPE_FLAG,

Line 1463: X_last_updated_by => FND_GLOBAL.USER_ID,

1459: X_creation_date => l_batch_attchmt_rec_type.creation_date,
1460: X_created_by => l_batch_attchmt_rec_type.created_by,
1461:
1462: X_last_update_date => sysdate,
1463: X_last_updated_by => FND_GLOBAL.USER_ID,
1464: X_last_update_login => FND_GLOBAL.USER_ID,
1465: X_seq_num => l_batch_attchmt_rec_type.SEQ_NUM,
1466: X_entity_name => l_batch_attchmt_rec_type.ENTITY_NAME,
1467: X_column1 => l_batch_attchmt_rec_type.COLUMN1,

Line 1464: X_last_update_login => FND_GLOBAL.USER_ID,

1460: X_created_by => l_batch_attchmt_rec_type.created_by,
1461:
1462: X_last_update_date => sysdate,
1463: X_last_updated_by => FND_GLOBAL.USER_ID,
1464: X_last_update_login => FND_GLOBAL.USER_ID,
1465: X_seq_num => l_batch_attchmt_rec_type.SEQ_NUM,
1466: X_entity_name => l_batch_attchmt_rec_type.ENTITY_NAME,
1467: X_column1 => l_batch_attchmt_rec_type.COLUMN1,
1468: X_pk1_value => l_batch_id,

Line 1548: LAST_UPDATED_BY = fnd_global.user_id,

1544: -- Update status of old transactions
1545: UPDATE FUN_TRX_HEADERS
1546: SET STATUS = 'REJECTED',
1547: REJECT_REASON = 'Swept to New Batch ' || l_batch_number,
1548: LAST_UPDATED_BY = fnd_global.user_id,
1549: LAST_UPDATE_DATE = sysdate,
1550: LAST_UPDATE_LOGIN = fnd_global.login_id
1551: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1552: AND STATUS IN ('SENT','ERROR','RECEIVED');

Line 1550: LAST_UPDATE_LOGIN = fnd_global.login_id

1546: SET STATUS = 'REJECTED',
1547: REJECT_REASON = 'Swept to New Batch ' || l_batch_number,
1548: LAST_UPDATED_BY = fnd_global.user_id,
1549: LAST_UPDATE_DATE = sysdate,
1550: LAST_UPDATE_LOGIN = fnd_global.login_id
1551: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1552: AND STATUS IN ('SENT','ERROR','RECEIVED');
1553:
1554: -- Update status of old batch to complete

Line 1561: LAST_UPDATED_BY = fnd_global.user_id,

1557: FROM DUAL
1558: WHERE EXISTS (SELECT 'X' FROM FUN_TRX_HEADERS
1559: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1560: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1561: LAST_UPDATED_BY = fnd_global.user_id,
1562: LAST_UPDATE_DATE = sysdate,
1563: LAST_UPDATE_LOGIN = fnd_global.login_id
1564: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
1565:

Line 1563: LAST_UPDATE_LOGIN = fnd_global.login_id

1559: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1560: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1561: LAST_UPDATED_BY = fnd_global.user_id,
1562: LAST_UPDATE_DATE = sysdate,
1563: LAST_UPDATE_LOGIN = fnd_global.login_id
1564: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
1565:
1566: END LOOP;
1567:

Line 1846: ,FND_GLOBAL.LOGIN_ID

1842: ,QUARTER_START_DATE
1843: ,'N'
1844: ,p_trx_type_id
1845: ,PERIOD_NUM
1846: ,FND_GLOBAL.LOGIN_ID
1847: ,FND_GLOBAL.LOGIN_ID
1848: ,SYSDATE
1849: ,FND_GLOBAL.LOGIN_ID
1850: ,sysdate

Line 1847: ,FND_GLOBAL.LOGIN_ID

1843: ,'N'
1844: ,p_trx_type_id
1845: ,PERIOD_NUM
1846: ,FND_GLOBAL.LOGIN_ID
1847: ,FND_GLOBAL.LOGIN_ID
1848: ,SYSDATE
1849: ,FND_GLOBAL.LOGIN_ID
1850: ,sysdate
1851: ,inteco_calendar

Line 1849: ,FND_GLOBAL.LOGIN_ID

1845: ,PERIOD_NUM
1846: ,FND_GLOBAL.LOGIN_ID
1847: ,FND_GLOBAL.LOGIN_ID
1848: ,SYSDATE
1849: ,FND_GLOBAL.LOGIN_ID
1850: ,sysdate
1851: ,inteco_calendar
1852: ,inteco_period_type
1853: from gl_periods,fun_system_options

Line 1884: ,FND_GLOBAL.LOGIN_ID

1880: ,QUARTER_START_DATE
1881: ,'N'
1882: ,p_trx_type_id
1883: ,PERIOD_NUM
1884: ,FND_GLOBAL.LOGIN_ID
1885: ,FND_GLOBAL.LOGIN_ID
1886: ,SYSDATE
1887: ,FND_GLOBAL.LOGIN_ID
1888: ,sysdate

Line 1885: ,FND_GLOBAL.LOGIN_ID

1881: ,'N'
1882: ,p_trx_type_id
1883: ,PERIOD_NUM
1884: ,FND_GLOBAL.LOGIN_ID
1885: ,FND_GLOBAL.LOGIN_ID
1886: ,SYSDATE
1887: ,FND_GLOBAL.LOGIN_ID
1888: ,sysdate
1889: ,INTECO_CALENDAR

Line 1887: ,FND_GLOBAL.LOGIN_ID

1883: ,PERIOD_NUM
1884: ,FND_GLOBAL.LOGIN_ID
1885: ,FND_GLOBAL.LOGIN_ID
1886: ,SYSDATE
1887: ,FND_GLOBAL.LOGIN_ID
1888: ,sysdate
1889: ,INTECO_CALENDAR
1890: ,INTECO_PERIOD_TYPE
1891: from gl_periods,