DBA Data[Home] [Help]

APPS.JTF_FM_UTL_V dependencies on FND_GLOBAL

Line 908: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,SYSDATE,

904: 0,
905: 0,
906: 0,
907: 0,
908: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,SYSDATE,
909: 0,
910: 0);
911:
912: JTF_FM_UTL_V.PRINT_MESSAGE('END ' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.UPDATE_REQUESTS_AQ');

Line 1425: FND_GLOBAL.USER_ID,

1421: fm_pvt_rec.request_id,
1422: l_submit_dt,
1423: empty_clob(),
1424: l_submit_dt,
1425: FND_GLOBAL.USER_ID,
1426: FND_GLOBAL.LOGIN_ID,
1427: l_submit_dt,
1428: FND_GLOBAL.USER_ID,
1429: fm_pvt_rec.queue,

Line 1426: FND_GLOBAL.LOGIN_ID,

1422: l_submit_dt,
1423: empty_clob(),
1424: l_submit_dt,
1425: FND_GLOBAL.USER_ID,
1426: FND_GLOBAL.LOGIN_ID,
1427: l_submit_dt,
1428: FND_GLOBAL.USER_ID,
1429: fm_pvt_rec.queue,
1430: l_media_type

Line 1428: FND_GLOBAL.USER_ID,

1424: l_submit_dt,
1425: FND_GLOBAL.USER_ID,
1426: FND_GLOBAL.LOGIN_ID,
1427: l_submit_dt,
1428: FND_GLOBAL.USER_ID,
1429: fm_pvt_rec.queue,
1430: l_media_type
1431: );
1432:

Line 1450: FND_GLOBAL.USER_ID,

1446: (
1447: fm_pvt_rec.request_id,
1448: l_submit_dt,
1449: l_submit_dt,
1450: FND_GLOBAL.USER_ID,
1451: FND_GLOBAL.CONC_LOGIN_ID,
1452: l_submit_dt,
1453: FND_GLOBAL.USER_ID
1454: );

Line 1451: FND_GLOBAL.CONC_LOGIN_ID,

1447: fm_pvt_rec.request_id,
1448: l_submit_dt,
1449: l_submit_dt,
1450: FND_GLOBAL.USER_ID,
1451: FND_GLOBAL.CONC_LOGIN_ID,
1452: l_submit_dt,
1453: FND_GLOBAL.USER_ID
1454: );
1455:

Line 1453: FND_GLOBAL.USER_ID

1449: l_submit_dt,
1450: FND_GLOBAL.USER_ID,
1451: FND_GLOBAL.CONC_LOGIN_ID,
1452: l_submit_dt,
1453: FND_GLOBAL.USER_ID
1454: );
1455:
1456: JTF_FM_UTL_V.PRINT_MESSAGE('Updated record in status******',JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);
1457: INSERT INTO JTF_FM_EMAIL_STATS

Line 1467: 0,0,0,FND_GLOBAL.USER_ID,l_submit_dt,

1463: BOUNCED,
1464: OPENED,UNSUBSCRIBED,DO_NOT_CONTACT,CREATED_BY,
1465: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
1466: VALUES (fm_pvt_rec.request_id,0,0,0,0,
1467: 0,0,0,FND_GLOBAL.USER_ID,l_submit_dt,
1468: FND_GLOBAL.USER_ID,l_submit_dt);
1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN

Line 1468: FND_GLOBAL.USER_ID,l_submit_dt);

1464: OPENED,UNSUBSCRIBED,DO_NOT_CONTACT,CREATED_BY,
1465: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE)
1466: VALUES (fm_pvt_rec.request_id,0,0,0,0,
1467: 0,0,0,FND_GLOBAL.USER_ID,l_submit_dt,
1468: FND_GLOBAL.USER_ID,l_submit_dt);
1469:
1470: EXCEPTION
1471: WHEN NO_DATA_FOUND THEN
1472: l_Error_Msg := 'Data not found for the request_id passed';

Line 1563: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;

1559: l_message := l_message || 'doc_ref="'||'JFUF'||'" '||a;
1560: END IF; -- IF (p_doc_id
1561:
1562: l_message := l_message || 'app_id="'||'690'||'" '||a;
1563: l_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1564: -- This IF clause is not required in production.
1565:
1566: IF l_login_id <= 0
1567: THEN

Line 1572: l_resp_id := FND_GLOBAL.RESP_ID;

1568: l_login_id := -1;
1569: END IF; -- IF l_login_id
1570:
1571: l_message := l_message || 'login_id="'||to_char(l_login_id)||'" '||a;
1572: l_resp_id := FND_GLOBAL.RESP_ID;
1573:
1574: IF l_resp_id <= 0 OR l_resp_id IS NULL
1575: THEN
1576: l_resp_id := -1;

Line 1720: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1716: NULL,p_fulfill_electronic_rec.template_id),
1717: USER_ID = p_fulfill_electronic_rec.requestor_id,
1718: PRIORITY = fm_pvt_rec.priority,
1719: LAST_UPDATE_DATE = sysdate,
1720: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
1722: SOURCE_CODE_ID = decode(p_fulfill_electronic_rec.source_code_id, FND_API.G_MISS_NUM,
1723: NULL,p_fulfill_electronic_rec.source_code_id),
1724: SOURCE_CODE = decode(p_fulfill_electronic_rec.source_code, FND_API.G_MISS_CHAR,

Line 1721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

1717: USER_ID = p_fulfill_electronic_rec.requestor_id,
1718: PRIORITY = fm_pvt_rec.priority,
1719: LAST_UPDATE_DATE = sysdate,
1720: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1721: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
1722: SOURCE_CODE_ID = decode(p_fulfill_electronic_rec.source_code_id, FND_API.G_MISS_NUM,
1723: NULL,p_fulfill_electronic_rec.source_code_id),
1724: SOURCE_CODE = decode(p_fulfill_electronic_rec.source_code, FND_API.G_MISS_CHAR,
1725: NULL,p_fulfill_electronic_rec.source_code),

Line 1767: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1763: NULL,p_fulfill_electronic_rec.template_id),
1764: USER_ID = p_fulfill_electronic_rec.requestor_id,
1765: PRIORITY = fm_pvt_rec.priority,
1766: LAST_UPDATE_DATE = sysdate,
1767: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1768: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
1769: SOURCE_CODE_ID = decode(p_fulfill_electronic_rec.source_code_id, FND_API.G_MISS_NUM,
1770: NULL,p_fulfill_electronic_rec.source_code_id),
1771: SOURCE_CODE = decode(p_fulfill_electronic_rec.source_code, FND_API.G_MISS_CHAR,

Line 1768: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

1764: USER_ID = p_fulfill_electronic_rec.requestor_id,
1765: PRIORITY = fm_pvt_rec.priority,
1766: LAST_UPDATE_DATE = sysdate,
1767: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1768: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,
1769: SOURCE_CODE_ID = decode(p_fulfill_electronic_rec.source_code_id, FND_API.G_MISS_NUM,
1770: NULL,p_fulfill_electronic_rec.source_code_id),
1771: SOURCE_CODE = decode(p_fulfill_electronic_rec.source_code, FND_API.G_MISS_CHAR,
1772: NULL,p_fulfill_electronic_rec.source_code),