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_WF_K_PROCESS_PVT dependencies on OKS_K_HEADERS_B

Line 352: FROM oks_k_headers_b

348:
349:
350: CURSOR csr_k_item_key IS
351: SELECT wf_item_key
352: FROM oks_k_headers_b
353: WHERE chr_id = p_contract_id;
354:
355: l_rownotfound BOOLEAN := FALSE;
356: BEGIN

Line 1013: -- if p_process_status is passed then update the renewal status in oks_k_headers_b

1009: ELSE
1010: l_item_key := p_item_key;
1011: END IF; -- p_item_key IS NULL
1012:
1013: -- if p_process_status is passed then update the renewal status in oks_k_headers_b
1014: IF p_process_status IS NOT NULL THEN
1015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1017: 'Updating Contract '||G_PKG_NAME ||'.'||l_api_name);

Line 1020: UPDATE oks_k_headers_b

1016: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1017: 'Updating Contract '||G_PKG_NAME ||'.'||l_api_name);
1018: END IF;
1019:
1020: UPDATE oks_k_headers_b
1021: SET renewal_status = p_process_status ,
1022: -- commented and replaced following 2 lines. Accepted by and date accepted were getting cleared
1023: -- accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,FND_GLOBAL.USER_ID,accepted_by),
1024: -- date_accepted = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,sysdate,date_accepted),

Line 1109: FROM oks_k_headers_b

1105: l_api_name CONSTANT VARCHAR2(30) := 'get_negotiation_status';
1106:
1107: CURSOR l_NegotiationStatus_csr(l_contract_id NUMBER) IS
1108: SELECT renewal_status
1109: FROM oks_k_headers_b
1110: WHERE chr_id = l_contract_id;
1111:
1112: l_negotiation_status VARCHAR2(30);
1113: BEGIN

Line 1263: FROM oks_k_headers_b

1259: l_api_name CONSTANT VARCHAR2(30) := 'get_qto_email';
1260:
1261: CURSOR l_QToContact_csr ( l_contract_id NUMBER ) IS
1262: SELECT quote_to_email_id
1263: FROM oks_k_headers_b
1264: WHERE chr_id = l_contract_id;
1265:
1266: CURSOR l_emailAddress_csr ( p_contactPoint_id NUMBER ) IS
1267: SELECT email_address

Line 1384: FROM oks_k_headers_b ks, fnd_user fu

1380:
1381: -- Get quote To contact fnd user name
1382: CURSOR l_qto_name_csr(p_chr_id NUMBER) IS
1383: SELECT fu.user_name
1384: FROM oks_k_headers_b ks, fnd_user fu
1385: WHERE ks.chr_id = p_chr_id
1386: AND fu.person_party_id = ks.person_party_id;
1387:
1388: -- Get quote To contact name

Line 1391: FROM OKS_K_HEADERS_B OKSH,

1387:
1388: -- Get quote To contact name
1389: CURSOR l_qtocontact_name_csr(p_chr_id NUMBER) IS
1390: select SUBSTRB(P.PERSON_LAST_NAME,1,50) || ', ' || SUBSTRB(P.PERSON_FIRST_NAME,1,40) name
1391: FROM OKS_K_HEADERS_B OKSH,
1392: HZ_CUST_ACCOUNT_ROLES CAR,
1393: HZ_PARTIES P,
1394: HZ_RELATIONSHIPS R
1395: WHERE OKSH.quote_to_contact_id = car.CUST_ACCOUNT_ROLE_ID

Line 2477: oks_k_headers_b oksh,

2473:
2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning
2476: FROM okc_k_headers_all_b okch,
2477: oks_k_headers_b oksh,
2478: fnd_lookups fndl
2479: WHERE okch.id = oksh.chr_id
2480: AND oksh.chr_id = p_chr_id
2481: AND fndl.lookup_code = DECODE(oksh.payment_type, NULL, okch.payment_instruction_type)

Line 3465: Function : This procedure updates renewal status in OKS_K_HEADERS_B

3461:
3462: /*=========================================================================
3463: API name : update_negotiation_status
3464: Type : Private.
3465: Function : This procedure updates renewal status in OKS_K_HEADERS_B
3466: and bumps up the version.
3467: Pre-reqs : None.
3468: Parameters :
3469: IN : p_api_version IN NUMBER Required

Line 3526: UPDATE oks_k_headers_b

3522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3523: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
3524: 'Updating Contract: '||G_PKG_NAME ||'.'||l_api_name);
3525: END IF;
3526: UPDATE oks_k_headers_b
3527: SET renewal_status = p_negotiation_status,
3528: object_version_number = object_version_number + 1,
3529: last_update_date = SYSDATE,
3530: last_updated_by = FND_GLOBAL.USER_ID,

Line 4509: UPDATE oks_k_headers_b

4505:
4506: -- Update contract header with the workflow item key only if it is not
4507: -- updated earlier by calling modules
4508: IF p_wf_attributes.item_key IS NULL THEN
4509: UPDATE oks_k_headers_b
4510: SET wf_item_key = l_item_key,
4511: renewal_status = nvl(p_wf_attributes.negotiation_status, 'DRAFT'),
4512: object_version_number = object_version_number + 1,
4513: last_update_date = SYSDATE,

Line 5022: FROM oks_k_headers_b oksh, fnd_user fndu

5018: l_api_name CONSTANT VARCHAR2(30) := 'get_old_wf_status';
5019:
5020: CURSOR l_rru_csr(p_chr_id NUMBER) IS
5021: SELECT oksh.renewal_type_used, fndu.user_name
5022: FROM oks_k_headers_b oksh, fnd_user fndu
5023: WHERE oksh.chr_id = p_chr_id
5024: AND oksh.renewal_notification_to = fndu.user_id(+);
5025:
5026: CURSOR l_user_dtls_csr(p_chr_id NUMBER) IS

Line 6135: SELECT renewal_status FROM oks_k_headers_b

6131: l_activity_name VARCHAR2(30);
6132: l_negotiation_status VARCHAR2(30);
6133:
6134: CURSOR l_nego_sts_csr (p_chr_id NUMBER) IS
6135: SELECT renewal_status FROM oks_k_headers_b
6136: WHERE chr_id = p_chr_id;
6137:
6138: BEGIN
6139:

Line 6178: update oks_k_headers_b set renewal_status = G_NEG_STS_QUOTE_SENT

6174: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6175: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6176: 'Updating Negotiation status ' || l_negotiation_status || ' to Quote Published');
6177: END IF;
6178: update oks_k_headers_b set renewal_status = G_NEG_STS_QUOTE_SENT
6179: where chr_id = p_contract_id;
6180: ELSE
6181: -- Check whether publish to customer action is applicable for this contract
6182: -- If k is not in 'Entered' status, we should not allow for publishing it online

Line 7129: Function : This procedure updates renewal status in OKS_K_HEADERS_B

7125:
7126: /*=========================================================================
7127: API name : process_negotiation_status
7128: Type : Private.
7129: Function : This procedure updates renewal status in OKS_K_HEADERS_B
7130: and bumps up the version. This is invoked from the workflow.
7131: Pre-reqs : None.
7132: Parameters :
7133: IN : itemtype IN VARCHAR2 Required

Line 8190: UPDATE oks_k_headers_b

8186: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8187: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8188: 'Aborting Process and Updating Contract '||G_PKG_NAME ||'.'||l_api_name);
8189: END IF;
8190: UPDATE oks_k_headers_b
8191: SET renewal_status = G_NEG_STS_QUOTE_CNCLD,
8192: accepted_by = NULL,
8193: date_accepted = NULL,
8194: object_version_number = object_version_number + 1,

Line 8552: FROM OKS_K_HEADERS_B oksk,

8548: nvl(oksk.APPROVAL_TYPE_USED, G_IRR_FLAG_REQD) APPROVAL_TYPE_USED,
8549: okck.CONTRACT_NUMBER CONTRACT_NUMBER,
8550: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8551: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8552: FROM OKS_K_HEADERS_B oksk,
8553: OKC_K_HEADERS_ALL_B okck,
8554: OKC_STATUSES_B sts
8555: WHERE oksk.chr_id = okck.id
8556: AND sts.ste_code = 'ENTERED'

Line 8686: p_update_item_key : Y|N indicating if oks_k_headers_b and oks_k_headers_bh are to be

8682:
8683: Parameters
8684: p_wf_attributes_tbl : table of records containg the details of the workflow to be
8685: launched
8686: p_update_item_key : Y|N indicating if oks_k_headers_b and oks_k_headers_bh are to be
8687: updated with the passed item keys
8688:
8689: Rules for input record fiels
8690: 1. Contract_id must be passed, if not passed the record is ignored

Line 8912: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update', ',upating oks_k_headers_b');

8908:
8909: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN
8910:
8911: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
8912: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update', ',upating oks_k_headers_b');
8913: END IF;
8914:
8915: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
8916: UPDATE oks_k_headers_b

Line 8916: UPDATE oks_k_headers_b

8912: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update', ',upating oks_k_headers_b');
8913: END IF;
8914:
8915: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
8916: UPDATE oks_k_headers_b
8917: SET wf_item_key = l_item_keys(i),
8918: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
8919: object_version_number = object_version_number + 1,
8920: last_update_date = SYSDATE,

Line 8926: UPDATE oks_k_headers_bh

8922: last_update_login = FND_GLOBAL.LOGIN_ID
8923: WHERE chr_id = l_contract_id_values(i);
8924:
8925: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
8926: UPDATE oks_k_headers_bh
8927: SET wf_item_key = l_item_keys(i),
8928: object_version_number = object_version_number + 1,
8929: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
8930: last_update_date = SYSDATE,