APPS.OKS_K_ACTIONS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 454: TYPE l_chr_id_list IS TABLE OF OKC_K_HEADERS_ALL_B.ID%TYPE INDEX BY BINARY_INTEGER;

450: tmp_contract_list VARCHAR2(8000) ;
451: i NUMBER := 0;
452: j NUMBER := 0;
453:
454: TYPE l_chr_id_list IS TABLE OF OKC_K_HEADERS_ALL_B.ID%TYPE INDEX BY BINARY_INTEGER;
455: l_chr_id_tbl l_chr_id_list;
456:
457: l_request_id NUMBER := 0;
458:

Line 650: FROM okc_k_headers_all_b okck,

646: l_return_val VARCHAR2(1) := 'N';
647:
648: CURSOR reminder_cur IS
649: SELECT 'X'
650: FROM okc_k_headers_all_b okck,
651: okc_statuses_b sts
652: WHERE okck.sts_code = sts.code
653: AND sts.ste_code = 'ENTERED'
654: AND okck.id = p_chr_id;

Line 660: FROM okc_k_headers_all_b okck,

656: reminder_rec reminder_cur%ROWTYPE;
657:
658: CURSOR chr_cur IS
659: SELECT 'X'
660: FROM okc_k_headers_all_b okck,
661: okc_statuses_b sts
662: WHERE okck.sts_code = sts.code
663: AND sts.ste_code = 'ENTERED'
664: AND okck.id = p_chr_id

Line 1215: p_chr_id IN OKC_K_HEADERS_ALL_B.ID%TYPE,

1211:
1212: END send_email;
1213:
1214: PROCEDURE update_single_contracts (
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,

Line 1216: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,

1212: END send_email;
1213:
1214: PROCEDURE update_single_contracts (
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,

Line 1217: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,

1213:
1214: PROCEDURE update_single_contracts (
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,

Line 1244: from okc_k_headers_all_b

1240:
1241: CURSOR csr_k_old_status(c_chr_id in number) IS
1242: Select sts_code,
1243: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contract_number
1244: from okc_k_headers_all_b
1245: Where id = c_chr_id;
1246:
1247: -- bug 5934875, update page should be able to change values for follow-up and forecast to null
1248: CURSOR csr_k_old_forecast IS

Line 1540: Update okc_k_headers_all_b okcb

1536: last_updated_by = FND_GLOBAL.USER_ID,
1537: last_update_login = FND_GLOBAL.LOGIN_ID
1538: where chr_id = p_chr_id;
1539: /*added for bug7034006*/
1540: Update okc_k_headers_all_b okcb
1541: set last_update_date = SYSDATE,
1542: last_updated_by = FND_GLOBAL.USER_ID,
1543: last_update_login = FND_GLOBAL.LOGIN_ID
1544: where okcb.id = p_chr_id;