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 1051: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 1053: LAST_UPDATE_LOGIN = fnd_global.login_id,

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

Line 1767: LAST_UPDATED_BY = fnd_global.user_id,

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

Line 1769: LAST_UPDATE_LOGIN = fnd_global.login_id,

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

Line 2094: last_updated_by = fnd_global.user_id,

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

Line 2095: last_update_login = fnd_global.login_id

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