eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_K_ACTIONS_PVT dependencies on OKS_K_HEADERS_B

Line 71: update oks_k_headers_b

67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: -- check if the contract is valid for setting reminders
70: IF validateForRenewalAction (p_chr_id,'RMDR') = 'Y' THEN
71: update oks_k_headers_b
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,

Line 266: Update OKS_K_HEADERS_B

262: x_request_id :=l_request_id;
263:
264: if x_request_id >0 then
265:
266: Update OKS_K_HEADERS_B
267: Set PROCESS_REQUEST_ID = l_request_id
268: Where CHR_ID = p_chr_id;
269:
270: x_return_status :=G_RET_STS_SUCCESS;

Line 607: UPDATE OKS_K_HEADERS_B

603: END IF;
604:
605: IF l_request_id > 0 THEN
606: FORALL i in NVL(l_chr_id_tbl.FIRST,0)..NVL(l_chr_id_tbl.LAST,-1)
607: UPDATE OKS_K_HEADERS_B
608: SET PROCESS_REQUEST_ID = l_request_id
609: WHERE chr_id = l_chr_id_tbl(i);
610: ELSE
611: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');

Line 1192: Update OKS_K_HEADERS_B

1188: x_request_id :=l_request_id;
1189:
1190: if x_request_id >0 then
1191:
1192: Update OKS_K_HEADERS_B
1193: Set PROCESS_REQUEST_ID = l_request_id
1194: Where CHR_ID = p_chr_id;
1195:
1196: x_return_status :=G_RET_STS_SUCCESS;

Line 1248: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,

1244: p_chr_id IN OKC_K_HEADERS_ALL_B.ID%TYPE,
1245: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,
1246: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1247: p_comments IN VARCHAR2,
1248: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1252: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,

Line 1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,

1245: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,
1246: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1247: p_comments IN VARCHAR2,
1248: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1252: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1253: p_renewal_notes IN OKS_K_HEADERS_B.RENEWAL_COMMENT%TYPE,

Line 1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,

1246: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1247: p_comments IN VARCHAR2,
1248: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1252: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1253: p_renewal_notes IN OKS_K_HEADERS_B.RENEWAL_COMMENT%TYPE,
1254: x_succ_err_contract OUT NOCOPY VARCHAR2,

Line 1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,

1247: p_comments IN VARCHAR2,
1248: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1252: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1253: p_renewal_notes IN OKS_K_HEADERS_B.RENEWAL_COMMENT%TYPE,
1254: x_succ_err_contract OUT NOCOPY VARCHAR2,
1255: x_return_status OUT NOCOPY VARCHAR2,

Line 1253: p_renewal_notes IN OKS_K_HEADERS_B.RENEWAL_COMMENT%TYPE,

1249: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1250: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1251: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1252: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1253: p_renewal_notes IN OKS_K_HEADERS_B.RENEWAL_COMMENT%TYPE,
1254: x_succ_err_contract OUT NOCOPY VARCHAR2,
1255: x_return_status OUT NOCOPY VARCHAR2,
1256: x_msg_data OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER)

Line 1283: FROM oks_k_headers_b

1279: SELECT follow_up_date,
1280: follow_up_action,
1281: est_rev_percent,
1282: est_rev_date
1283: FROM oks_k_headers_b
1284: WHERE chr_id = p_chr_id;
1285:
1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;

Line 1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;

1282: est_rev_date
1283: FROM oks_k_headers_b
1284: WHERE chr_id = p_chr_id;
1285:
1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1288: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1290:

Line 1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;

1283: FROM oks_k_headers_b
1284: WHERE chr_id = p_chr_id;
1285:
1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1288: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1290:
1291: BEGIN

Line 1288: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;

1284: WHERE chr_id = p_chr_id;
1285:
1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1288: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1290:
1291: BEGIN
1292: -- start debug log

Line 1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;

1285:
1286: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1287: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1288: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1290:
1291: BEGIN
1292: -- start debug log
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1565: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');

1561: THEN
1562: fnd_log.STRING (fnd_log.level_statement,
1563: g_module ||
1564: l_api_name,
1565: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1566: END IF;
1567: /*modified for bug7034006*/
1568: --Updating Follow Up
1569: Update oks_k_headers_b

Line 1569: Update oks_k_headers_b

1565: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1566: END IF;
1567: /*modified for bug7034006*/
1568: --Updating Follow Up
1569: Update oks_k_headers_b
1570: set follow_up_date = p_due_date,
1571: follow_up_action = p_action,
1572: est_rev_percent = p_est_percent,
1573: est_rev_date = p_est_date,

Line 1630: '222:Now Updating Renewal Comment in oks_k_headers_b');

1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1627: fnd_log.STRING (fnd_log.level_statement,
1628: g_module ||
1629: l_api_name,
1630: '222:Now Updating Renewal Comment in oks_k_headers_b');
1631: END IF;
1632:
1633: UPDATE oks_k_headers_b
1634: SET renewal_comment = p_renewal_notes,

Line 1633: UPDATE oks_k_headers_b

1629: l_api_name,
1630: '222:Now Updating Renewal Comment in oks_k_headers_b');
1631: END IF;
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