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 2494: FROM oks_k_headers_b

2490: AND name = 'CC_EMAIL';
2491:
2492: CURSOR get_cc_email(p_chr_id NUMBER) IS
2493: SELECT cc_email_address
2494: FROM oks_k_headers_b
2495: WHERE chr_id=p_chr_id;
2496:
2497: l_cc_email_address VARCHAR2(2000);
2498: l_text_value varchar2(2000);

Line 2834: FROM oks_k_headers_b

2830:
2831:
2832: CURSOR get_cc_email(p_chr_id NUMBER) IS
2833: SELECT cc_email_address
2834: FROM oks_k_headers_b
2835: WHERE chr_id=p_chr_id;
2836:
2837: l_cc_email_address VARCHAR2(2000);
2838:

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

3577:
3578: /*=========================================================================
3579: API name : update_negotiation_status
3580: Type : Private.
3581: Function : This procedure updates renewal status in OKS_K_HEADERS_B
3582: and bumps up the version.
3583: Pre-reqs : None.
3584: Parameters :
3585: IN : p_api_version IN NUMBER Required

Line 3642: UPDATE oks_k_headers_b

3638: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3639: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
3640: 'Updating Contract: '||G_PKG_NAME ||'.'||l_api_name);
3641: END IF;
3642: UPDATE oks_k_headers_b
3643: SET renewal_status = p_negotiation_status,
3644: object_version_number = object_version_number + 1,
3645: last_update_date = SYSDATE,
3646: last_updated_by = FND_GLOBAL.USER_ID,

Line 4636: UPDATE oks_k_headers_b

4632:
4633: -- Update contract header with the workflow item key only if it is not
4634: -- updated earlier by calling modules
4635: IF p_wf_attributes.item_key IS NULL THEN
4636: UPDATE oks_k_headers_b
4637: SET wf_item_key = l_item_key,
4638: renewal_status = nvl(p_wf_attributes.negotiation_status, 'DRAFT'),
4639: object_version_number = object_version_number + 1,
4640: last_update_date = SYSDATE,

Line 5188: FROM oks_k_headers_b oksh, fnd_user fndu

5184: l_api_name CONSTANT VARCHAR2(30) := 'get_old_wf_status';
5185:
5186: CURSOR l_rru_csr(p_chr_id NUMBER) IS
5187: SELECT oksh.renewal_type_used, fndu.user_name
5188: FROM oks_k_headers_b oksh, fnd_user fndu
5189: WHERE oksh.chr_id = p_chr_id
5190: AND oksh.renewal_notification_to = fndu.user_id(+);
5191:
5192: CURSOR l_user_dtls_csr(p_chr_id NUMBER) IS

Line 6439: SELECT renewal_status FROM oks_k_headers_b

6435: l_activity_name VARCHAR2(30);
6436: l_negotiation_status VARCHAR2(30);
6437:
6438: CURSOR l_nego_sts_csr (p_chr_id NUMBER) IS
6439: SELECT renewal_status FROM oks_k_headers_b
6440: WHERE chr_id = p_chr_id;
6441:
6442: BEGIN
6443:

Line 6482: update oks_k_headers_b set renewal_status = G_NEG_STS_QUOTE_SENT

6478: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6479: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6480: 'Updating Negotiation status ' || l_negotiation_status || ' to Quote Published');
6481: END IF;
6482: update oks_k_headers_b set renewal_status = G_NEG_STS_QUOTE_SENT
6483: where chr_id = p_contract_id;
6484: ELSE
6485: -- Check whether publish to customer action is applicable for this contract
6486: -- If k is not in 'Entered' status, we should not allow for publishing it online

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

7429:
7430: /*=========================================================================
7431: API name : process_negotiation_status
7432: Type : Private.
7433: Function : This procedure updates renewal status in OKS_K_HEADERS_B
7434: and bumps up the version. This is invoked from the workflow.
7435: Pre-reqs : None.
7436: Parameters :
7437: IN : itemtype IN VARCHAR2 Required

Line 8494: UPDATE oks_k_headers_b

8490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8492: 'Aborting Process and Updating Contract '||G_PKG_NAME ||'.'||l_api_name);
8493: END IF;
8494: UPDATE oks_k_headers_b
8495: SET renewal_status = G_NEG_STS_QUOTE_CNCLD,
8496: accepted_by = NULL,
8497: date_accepted = NULL,
8498: object_version_number = object_version_number + 1,

Line 8856: FROM OKS_K_HEADERS_B oksk,

8852: nvl(oksk.APPROVAL_TYPE_USED, G_IRR_FLAG_REQD) APPROVAL_TYPE_USED,
8853: okck.CONTRACT_NUMBER CONTRACT_NUMBER,
8854: nvl(okck.CONTRACT_NUMBER_MODIFIER, FND_API.G_MISS_CHAR) CONTRACT_NUMBER_MODIFIER,
8855: nvl(oksk.RENEWAL_STATUS, G_NEG_STS_DRAFT) RENEWAL_STATUS
8856: FROM OKS_K_HEADERS_B oksk,
8857: OKC_K_HEADERS_ALL_B okck,
8858: OKC_STATUSES_B sts
8859: WHERE oksk.chr_id = okck.id
8860: AND sts.ste_code = 'ENTERED'

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

8986:
8987: Parameters
8988: p_wf_attributes_tbl : table of records containg the details of the workflow to be
8989: launched
8990: p_update_item_key : Y|N indicating if oks_k_headers_b and oks_k_headers_bh are to be
8991: updated with the passed item keys
8992:
8993: Rules for input record fiels
8994: 1. Contract_id must be passed, if not passed the record is ignored

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

9212:
9213: IF ( nvl(p_update_item_key, 'N') = 'Y' ) THEN
9214:
9215: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
9216: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update', ',upating oks_k_headers_b');
9217: END IF;
9218:
9219: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
9220: UPDATE oks_k_headers_b

Line 9220: UPDATE oks_k_headers_b

9216: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.update', ',upating oks_k_headers_b');
9217: END IF;
9218:
9219: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
9220: UPDATE oks_k_headers_b
9221: SET wf_item_key = l_item_keys(i),
9222: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
9223: object_version_number = object_version_number + 1,
9224: last_update_date = SYSDATE,

Line 9230: UPDATE oks_k_headers_bh

9226: last_update_login = FND_GLOBAL.LOGIN_ID
9227: WHERE chr_id = l_contract_id_values(i);
9228:
9229: FORALL i IN l_contract_id_values.FIRST..l_contract_id_values.LAST
9230: UPDATE oks_k_headers_bh
9231: SET wf_item_key = l_item_keys(i),
9232: object_version_number = object_version_number + 1,
9233: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
9234: last_update_date = SYSDATE,