APPS.OKS_K_ACTIONS_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 80: UPDATE okc_k_headers_all_b okcb

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,
82: last_updated_by = FND_GLOBAL.USER_ID,
83: last_update_login = FND_GLOBAL.LOGIN_ID
84: WHERE okcb.id = p_chr_id;

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

479: tmp_contract_list VARCHAR2(8000) ;
480: i NUMBER := 0;
481: j NUMBER := 0;
482:
483: TYPE l_chr_id_list IS TABLE OF OKC_K_HEADERS_ALL_B.ID%TYPE INDEX BY BINARY_INTEGER;
484: l_chr_id_tbl l_chr_id_list;
485:
486: l_request_id NUMBER := 0;
487:

Line 679: FROM okc_k_headers_all_b okck,

675: l_return_val VARCHAR2(1) := 'N';
676:
677: CURSOR reminder_cur IS
678: SELECT 'X'
679: FROM okc_k_headers_all_b okck,
680: okc_statuses_b sts
681: WHERE okck.sts_code = sts.code
682: AND sts.ste_code = 'ENTERED'
683: AND okck.id = p_chr_id;

Line 689: FROM okc_k_headers_all_b okck,

685: reminder_rec reminder_cur%ROWTYPE;
686:
687: CURSOR chr_cur IS
688: SELECT 'X'
689: FROM okc_k_headers_all_b okck,
690: okc_statuses_b sts
691: WHERE okck.sts_code = sts.code
692: AND sts.ste_code = 'ENTERED'
693: AND okck.id = p_chr_id

Line 1244: p_chr_id IN OKC_K_HEADERS_ALL_B.ID%TYPE,

1240:
1241: END send_email;
1242:
1243: PROCEDURE update_single_contracts (
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,

Line 1245: p_status_code IN OKC_K_HEADERS_ALL_B.STS_CODE%TYPE,

1241: END send_email;
1242:
1243: PROCEDURE update_single_contracts (
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,

Line 1246: p_reason_code IN OKC_K_HEADERS_ALL_B.TRN_CODE%TYPE,

1242:
1243: PROCEDURE update_single_contracts (
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,

Line 1274: from okc_k_headers_all_b

1270:
1271: CURSOR csr_k_old_status(c_chr_id in number) IS
1272: Select sts_code,
1273: contract_number||decode(contract_number_modifier, NULL,'','-'||contract_number_modifier) contract_number
1274: from okc_k_headers_all_b
1275: Where id = c_chr_id;
1276:
1277: -- bug 5934875, update page should be able to change values for follow-up and forecast to null
1278: CURSOR csr_k_old_forecast IS

Line 1579: Update okc_k_headers_all_b okcb

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,
1581: last_updated_by = FND_GLOBAL.USER_ID,
1582: last_update_login = FND_GLOBAL.LOGIN_ID
1583: where okcb.id = p_chr_id;

Line 1640: UPDATE okc_k_headers_all_b okcb

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,
1642: last_updated_by = FND_GLOBAL.USER_ID,
1643: last_update_login = FND_GLOBAL.LOGIN_ID
1644: WHERE okcb.id = p_chr_id;