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 70: update oks_k_headers_b

66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67:
68: -- check if the contract is valid for setting reminders
69: IF validateForRenewalAction (p_chr_id,'RMDR') = 'Y' THEN
70: update oks_k_headers_b
71: set RMNDR_SUPPRESS_FLAG = p_suppress_yn,
72: object_version_number = object_version_number+1
73: where chr_id = p_chr_id;
74: ELSE

Line 237: Update OKS_K_HEADERS_B

233: x_request_id :=l_request_id;
234:
235: if x_request_id >0 then
236:
237: Update OKS_K_HEADERS_B
238: Set PROCESS_REQUEST_ID = l_request_id
239: Where CHR_ID = p_chr_id;
240:
241: x_return_status :=G_RET_STS_SUCCESS;

Line 578: UPDATE OKS_K_HEADERS_B

574: END IF;
575:
576: IF l_request_id > 0 THEN
577: FORALL i in NVL(l_chr_id_tbl.FIRST,0)..NVL(l_chr_id_tbl.LAST,-1)
578: UPDATE OKS_K_HEADERS_B
579: SET PROCESS_REQUEST_ID = l_request_id
580: WHERE chr_id = l_chr_id_tbl(i);
581: ELSE
582: FND_MESSAGE.SET_NAME('OKS','OKS_CP_ERROR');

Line 1163: Update OKS_K_HEADERS_B

1159: x_request_id :=l_request_id;
1160:
1161: if x_request_id >0 then
1162:
1163: Update OKS_K_HEADERS_B
1164: Set PROCESS_REQUEST_ID = l_request_id
1165: Where CHR_ID = p_chr_id;
1166:
1167: x_return_status :=G_RET_STS_SUCCESS;

Line 1219: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,

1215: p_chr_id IN OKC_K_HEADERS_ALL_B.ID%TYPE,
1216: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,
1217: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1218: p_comments IN VARCHAR2,
1219: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1220: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1221: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1222: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1223: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,

Line 1220: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,

1216: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,
1217: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1218: p_comments IN VARCHAR2,
1219: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1220: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1221: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1222: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1223: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1224: x_succ_err_contract OUT NOCOPY VARCHAR2,

Line 1221: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,

1217: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,
1218: p_comments IN VARCHAR2,
1219: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1220: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1221: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1222: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1223: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1224: x_succ_err_contract OUT NOCOPY VARCHAR2,
1225: x_return_status OUT NOCOPY VARCHAR2,

Line 1222: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,

1218: p_comments IN VARCHAR2,
1219: p_due_date IN OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE,
1220: p_action IN OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE,
1221: p_est_percent IN OKS_K_HEADERS_B.EST_REV_PERCENT%TYPE,
1222: p_est_date IN OKS_K_HEADERS_B.EST_REV_DATE%TYPE,
1223: p_contract_notes IN JTF_NOTES_TL.NOTES%TYPE,
1224: x_succ_err_contract OUT NOCOPY VARCHAR2,
1225: x_return_status OUT NOCOPY VARCHAR2,
1226: x_msg_data OUT NOCOPY VARCHAR2,

Line 1253: FROM oks_k_headers_b

1249: SELECT follow_up_date,
1250: follow_up_action,
1251: est_rev_percent,
1252: est_rev_date
1253: FROM oks_k_headers_b
1254: WHERE chr_id = p_chr_id;
1255:
1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;

Line 1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;

1252: est_rev_date
1253: FROM oks_k_headers_b
1254: WHERE chr_id = p_chr_id;
1255:
1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1258: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1260:

Line 1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;

1253: FROM oks_k_headers_b
1254: WHERE chr_id = p_chr_id;
1255:
1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1258: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1260:
1261: BEGIN

Line 1258: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;

1254: WHERE chr_id = p_chr_id;
1255:
1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1258: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1260:
1261: BEGIN
1262: -- start debug log

Line 1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;

1255:
1256: l_old_follow_up_date oks_k_headers_b.follow_up_date%TYPE;
1257: l_old_follow_up_action oks_k_headers_b.follow_up_action%TYPE;
1258: l_old_est_rev_percent oks_k_headers_b.est_rev_percent%TYPE;
1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1260:
1261: BEGIN
1262: -- start debug log
1263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

1522: THEN
1523: fnd_log.STRING (fnd_log.level_statement,
1524: g_module ||
1525: l_api_name,
1526: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1527: END IF;
1528: /*modified for bug7034006*/
1529: --Updating Follow Up
1530: Update oks_k_headers_b

Line 1530: Update oks_k_headers_b

1526: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1527: END IF;
1528: /*modified for bug7034006*/
1529: --Updating Follow Up
1530: Update oks_k_headers_b
1531: set follow_up_date = p_due_date,
1532: follow_up_action = p_action,
1533: est_rev_percent = p_est_percent,
1534: est_rev_date = p_est_date,