DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_GLOBAL

Line 76: last_updated_by = FND_GLOBAL.USER_ID,

72: set RMNDR_SUPPRESS_FLAG = p_suppress_yn,
73: object_version_number = object_version_number+1,
74: /* Added Bug# 7717268 */
75: last_update_date = SYSDATE,
76: last_updated_by = FND_GLOBAL.USER_ID,
77: last_update_login = FND_GLOBAL.LOGIN_ID
78: where chr_id = p_chr_id;
79: /*added for bug 7717268*/
80: UPDATE okc_k_headers_all_b okcb

Line 77: last_update_login = FND_GLOBAL.LOGIN_ID

73: object_version_number = object_version_number+1,
74: /* Added Bug# 7717268 */
75: last_update_date = SYSDATE,
76: last_updated_by = FND_GLOBAL.USER_ID,
77: last_update_login = FND_GLOBAL.LOGIN_ID
78: where chr_id = p_chr_id;
79: /*added for bug 7717268*/
80: UPDATE okc_k_headers_all_b okcb
81: SET last_update_date = SYSDATE,

Line 82: last_updated_by = FND_GLOBAL.USER_ID,

78: where chr_id = p_chr_id;
79: /*added for bug 7717268*/
80: UPDATE okc_k_headers_all_b okcb
81: SET last_update_date = SYSDATE,
82: last_updated_by = FND_GLOBAL.USER_ID,
83: last_update_login = FND_GLOBAL.LOGIN_ID
84: WHERE okcb.id = p_chr_id;
85:
86: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);

Line 83: last_update_login = FND_GLOBAL.LOGIN_ID

79: /*added for bug 7717268*/
80: UPDATE okc_k_headers_all_b okcb
81: SET last_update_date = SYSDATE,
82: last_updated_by = FND_GLOBAL.USER_ID,
83: last_update_login = FND_GLOBAL.LOGIN_ID
84: WHERE okcb.id = p_chr_id;
85:
86: x_return_status := OKC_CVM_PVT.update_minor_version(p_chr_id => p_chr_id);
87:

Line 857: FND_GLOBAL.USER_ID, -- CREATED_BY

853: p_attachment_template_id,
854: p_email_subject,
855: TO_CLOB(p_email_body),
856: p_email_contract_status,
857: FND_GLOBAL.USER_ID, -- CREATED_BY
858: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
859: SYSDATE, -- CREATION_DATE
860: SYSDATE, -- LAST_UPDATE_DATE
861: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN

Line 858: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

854: p_email_subject,
855: TO_CLOB(p_email_body),
856: p_email_contract_status,
857: FND_GLOBAL.USER_ID, -- CREATED_BY
858: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
859: SYSDATE, -- CREATION_DATE
860: SYSDATE, -- LAST_UPDATE_DATE
861: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN
862: )

Line 861: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN

857: FND_GLOBAL.USER_ID, -- CREATED_BY
858: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
859: SYSDATE, -- CREATION_DATE
860: SYSDATE, -- LAST_UPDATE_DATE
861: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN
862: )
863: RETURNING email_id
864: INTO l_email_id;
865:

Line 1496: p_entered_by => FND_GLOBAL.USER_ID,

1492: p_source_object_id => p_chr_id,
1493: p_source_object_code => 'OKS_HDR_NOTE',
1494: p_notes => p_contract_notes,
1495: p_note_status => 'I', --public status
1496: p_entered_by => FND_GLOBAL.USER_ID,
1497: p_entered_date => SYSDATE ,
1498: x_jtf_note_id => l_jtf_note_id,
1499: p_last_update_date => sysdate,
1500: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1500: p_last_updated_by => FND_GLOBAL.USER_ID,

1496: p_entered_by => FND_GLOBAL.USER_ID,
1497: p_entered_date => SYSDATE ,
1498: x_jtf_note_id => l_jtf_note_id,
1499: p_last_update_date => sysdate,
1500: p_last_updated_by => FND_GLOBAL.USER_ID,
1501: p_creation_date => SYSDATE,
1502: p_created_by => FND_GLOBAL.USER_ID,
1503: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1504: p_note_type => 'OKS_ADMIN');

Line 1502: p_created_by => FND_GLOBAL.USER_ID,

1498: x_jtf_note_id => l_jtf_note_id,
1499: p_last_update_date => sysdate,
1500: p_last_updated_by => FND_GLOBAL.USER_ID,
1501: p_creation_date => SYSDATE,
1502: p_created_by => FND_GLOBAL.USER_ID,
1503: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1504: p_note_type => 'OKS_ADMIN');
1505:
1506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1503: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1499: p_last_update_date => sysdate,
1500: p_last_updated_by => FND_GLOBAL.USER_ID,
1501: p_creation_date => SYSDATE,
1502: p_created_by => FND_GLOBAL.USER_ID,
1503: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1504: p_note_type => 'OKS_ADMIN');
1505:
1506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1507: THEN

Line 1575: last_updated_by = FND_GLOBAL.USER_ID,

1571: follow_up_action = p_action,
1572: est_rev_percent = p_est_percent,
1573: est_rev_date = p_est_date,
1574: last_update_date = SYSDATE,
1575: last_updated_by = FND_GLOBAL.USER_ID,
1576: last_update_login = FND_GLOBAL.LOGIN_ID
1577: where chr_id = p_chr_id;
1578: /*added for bug7034006*/
1579: Update okc_k_headers_all_b okcb

Line 1576: last_update_login = FND_GLOBAL.LOGIN_ID

1572: est_rev_percent = p_est_percent,
1573: est_rev_date = p_est_date,
1574: last_update_date = SYSDATE,
1575: last_updated_by = FND_GLOBAL.USER_ID,
1576: last_update_login = FND_GLOBAL.LOGIN_ID
1577: where chr_id = p_chr_id;
1578: /*added for bug7034006*/
1579: Update okc_k_headers_all_b okcb
1580: set last_update_date = SYSDATE,

Line 1581: last_updated_by = FND_GLOBAL.USER_ID,

1577: where chr_id = p_chr_id;
1578: /*added for bug7034006*/
1579: Update okc_k_headers_all_b okcb
1580: set last_update_date = SYSDATE,
1581: last_updated_by = FND_GLOBAL.USER_ID,
1582: last_update_login = FND_GLOBAL.LOGIN_ID
1583: where okcb.id = p_chr_id;
1584:
1585: if(SQL%ROWCOUNT =1) then

Line 1582: last_update_login = FND_GLOBAL.LOGIN_ID

1578: /*added for bug7034006*/
1579: Update okc_k_headers_all_b okcb
1580: set last_update_date = SYSDATE,
1581: last_updated_by = FND_GLOBAL.USER_ID,
1582: last_update_login = FND_GLOBAL.LOGIN_ID
1583: where okcb.id = p_chr_id;
1584:
1585: if(SQL%ROWCOUNT =1) then
1586: x_return_status := fnd_api.g_ret_sts_success;

Line 1636: last_updated_by = FND_GLOBAL.USER_ID,

1632:
1633: UPDATE oks_k_headers_b
1634: SET renewal_comment = p_renewal_notes,
1635: last_update_date = SYSDATE,
1636: last_updated_by = FND_GLOBAL.USER_ID,
1637: last_update_login = FND_GLOBAL.LOGIN_ID
1638: WHERE chr_id = p_chr_id;
1639:
1640: UPDATE okc_k_headers_all_b okcb

Line 1637: last_update_login = FND_GLOBAL.LOGIN_ID

1633: UPDATE oks_k_headers_b
1634: SET renewal_comment = p_renewal_notes,
1635: last_update_date = SYSDATE,
1636: last_updated_by = FND_GLOBAL.USER_ID,
1637: last_update_login = FND_GLOBAL.LOGIN_ID
1638: WHERE chr_id = p_chr_id;
1639:
1640: UPDATE okc_k_headers_all_b okcb
1641: SET last_update_date = SYSDATE,

Line 1642: last_updated_by = FND_GLOBAL.USER_ID,

1638: WHERE chr_id = p_chr_id;
1639:
1640: UPDATE okc_k_headers_all_b okcb
1641: SET last_update_date = SYSDATE,
1642: last_updated_by = FND_GLOBAL.USER_ID,
1643: last_update_login = FND_GLOBAL.LOGIN_ID
1644: WHERE okcb.id = p_chr_id;
1645:
1646:

Line 1643: last_update_login = FND_GLOBAL.LOGIN_ID

1639:
1640: UPDATE okc_k_headers_all_b okcb
1641: SET last_update_date = SYSDATE,
1642: last_updated_by = FND_GLOBAL.USER_ID,
1643: last_update_login = FND_GLOBAL.LOGIN_ID
1644: WHERE okcb.id = p_chr_id;
1645:
1646:
1647: --- If any errors happen abort API