DBA Data[Home] [Help]

APPS.CN_COMM_LINES_API_PKG dependencies on FND_GLOBAL

Line 451: fnd_global.user_id,

447: DECODE(p_comm_lines_api_rec.SOURCE_DOC_ID, FND_API.G_MISS_NUM, NULL,
448: p_comm_lines_api_rec.SOURCE_DOC_ID),
449: DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE, FND_API.G_MISS_CHAR, NULL,
450: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
451: fnd_global.user_id,
452: Sysdate,
453: fnd_global.user_id,
454: Sysdate,
455: fnd_global.login_id,

Line 453: fnd_global.user_id,

449: DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE, FND_API.G_MISS_CHAR, NULL,
450: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
451: fnd_global.user_id,
452: Sysdate,
453: fnd_global.user_id,
454: Sysdate,
455: fnd_global.login_id,
456: DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL,
457: p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),

Line 455: fnd_global.login_id,

451: fnd_global.user_id,
452: Sysdate,
453: fnd_global.user_id,
454: Sysdate,
455: fnd_global.login_id,
456: DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL,
457: p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),
458: DECODE(p_comm_lines_api_rec.EXCHANGE_RATE, FND_API.G_MISS_NUM, NULL,
459: p_comm_lines_api_rec.EXCHANGE_RATE),

Line 1050: LAST_UPDATED_BY = fnd_global.user_id,

1046: SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
1047: FND_API.G_MISS_CHAR,
1048: oldrec.SOURCE_DOC_TYPE,
1049: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1050: LAST_UPDATED_BY = fnd_global.user_id,
1051: LAST_UPDATE_DATE = Sysdate,
1052: LAST_UPDATE_LOGIN = fnd_global.login_id,
1053: TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1054: FND_API.G_MISS_CHAR,

Line 1052: LAST_UPDATE_LOGIN = fnd_global.login_id,

1048: oldrec.SOURCE_DOC_TYPE,
1049: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1050: LAST_UPDATED_BY = fnd_global.user_id,
1051: LAST_UPDATE_DATE = Sysdate,
1052: LAST_UPDATE_LOGIN = fnd_global.login_id,
1053: TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1054: FND_API.G_MISS_CHAR,
1055: oldrec.TRANSACTION_CURRENCY_CODE,
1056: p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),

Line 1766: LAST_UPDATED_BY = fnd_global.user_id,

1762: SOURCE_DOC_TYPE = DECODE(p_comm_lines_api_rec.SOURCE_DOC_TYPE,
1763: FND_API.G_MISS_CHAR,
1764: oldrec.SOURCE_DOC_TYPE,
1765: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1766: LAST_UPDATED_BY = fnd_global.user_id,
1767: LAST_UPDATE_DATE = Sysdate,
1768: LAST_UPDATE_LOGIN = fnd_global.login_id,
1769: TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1770: FND_API.G_MISS_CHAR,

Line 1768: LAST_UPDATE_LOGIN = fnd_global.login_id,

1764: oldrec.SOURCE_DOC_TYPE,
1765: p_comm_lines_api_rec.SOURCE_DOC_TYPE),
1766: LAST_UPDATED_BY = fnd_global.user_id,
1767: LAST_UPDATE_DATE = Sysdate,
1768: LAST_UPDATE_LOGIN = fnd_global.login_id,
1769: TRANSACTION_CURRENCY_CODE = DECODE(p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE,
1770: FND_API.G_MISS_CHAR,
1771: oldrec.TRANSACTION_CURRENCY_CODE,
1772: p_comm_lines_api_rec.TRANSACTION_CURRENCY_CODE),

Line 2093: last_updated_by = fnd_global.user_id,

2089: reversal_flag = l_reversal_flag,
2090: adjust_date = l_adjust_date,
2091: -- clku, update the last updated info
2092: last_update_date = sysdate,
2093: last_updated_by = fnd_global.user_id,
2094: last_update_login = fnd_global.login_id
2095: WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2096: AND org_id = x_org_id;
2097:

Line 2094: last_update_login = fnd_global.login_id

2090: adjust_date = l_adjust_date,
2091: -- clku, update the last updated info
2092: last_update_date = sysdate,
2093: last_updated_by = fnd_global.user_id,
2094: last_update_login = fnd_global.login_id
2095: WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2096: AND org_id = x_org_id;
2097:
2098: FOR api_curs_rec IN header_cur(l_reversal_header_id)