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
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,
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);
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:
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
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: )
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:
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,
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');
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)
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
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
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,
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
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;
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
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,
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:
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