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 FND_GLOBAL

Line 581: OPEN l_acceptedby_csr(FND_GLOBAL.USER_ID);

577: -- Quote has been accepted by either salesrep or Customer
578: IF p_document_type = G_REPORT_TYPE_ACCEPT THEN
579: x_email_attr_rec.ih_subject := get_message('OKS_IH_SUBJECT_ACCEPT',l_language);
580: -- assemble interaction history body
581: OPEN l_acceptedby_csr(FND_GLOBAL.USER_ID);
582: FETCH l_acceptedby_csr INTO l_accepted_by;
583: CLOSE l_acceptedby_csr;
584:
585: x_email_attr_rec.ih_message := get_message('OKS_IH_MESSAGE_ACCEPT',l_language);

Line 1023: -- accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,FND_GLOBAL.USER_ID,accepted_by),

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),
1025: accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(accepted_by,FND_GLOBAL.USER_ID),accepted_by),
1026: date_accepted = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(date_accepted,sysdate),date_accepted),
1027: object_version_number = object_version_number + 1,

Line 1025: accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(accepted_by,FND_GLOBAL.USER_ID),accepted_by),

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),
1025: accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(accepted_by,FND_GLOBAL.USER_ID),accepted_by),
1026: date_accepted = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(date_accepted,sysdate),date_accepted),
1027: object_version_number = object_version_number + 1,
1028: last_update_date = SYSDATE,
1029: last_updated_by = FND_GLOBAL.USER_ID,

Line 1029: last_updated_by = FND_GLOBAL.USER_ID,

1025: accepted_by = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(accepted_by,FND_GLOBAL.USER_ID),accepted_by),
1026: date_accepted = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(date_accepted,sysdate),date_accepted),
1027: object_version_number = object_version_number + 1,
1028: last_update_date = SYSDATE,
1029: last_updated_by = FND_GLOBAL.USER_ID,
1030: last_update_login = FND_GLOBAL.LOGIN_ID
1031: WHERE chr_id = p_contract_id;
1032:
1033: /* MKS 10/12/2005 Bug#4643300

Line 1030: last_update_login = FND_GLOBAL.LOGIN_ID

1026: date_accepted = DECODE(p_process_status,G_NEG_STS_QUOTE_ACPTD,NVL(date_accepted,sysdate),date_accepted),
1027: object_version_number = object_version_number + 1,
1028: last_update_date = SYSDATE,
1029: last_updated_by = FND_GLOBAL.USER_ID,
1030: last_update_login = FND_GLOBAL.LOGIN_ID
1031: WHERE chr_id = p_contract_id;
1032:
1033: /* MKS 10/12/2005 Bug#4643300
1034: -- bump up the minor version number

Line 1039: last_updated_by = FND_GLOBAL.USER_ID,

1035: UPDATE okc_k_vers_numbers
1036: SET minor_version = minor_version + 1,
1037: object_version_number = object_version_number + 1,
1038: last_update_date = SYSDATE,
1039: last_updated_by = FND_GLOBAL.USER_ID,
1040: last_update_login = FND_GLOBAL.LOGIN_ID
1041: WHERE chr_id = p_contract_id;
1042: */
1043: END IF; -- p_process_status is passed

Line 1040: last_update_login = FND_GLOBAL.LOGIN_ID

1036: SET minor_version = minor_version + 1,
1037: object_version_number = object_version_number + 1,
1038: last_update_date = SYSDATE,
1039: last_updated_by = FND_GLOBAL.USER_ID,
1040: last_update_login = FND_GLOBAL.LOGIN_ID
1041: WHERE chr_id = p_contract_id;
1042: */
1043: END IF; -- p_process_status is passed
1044:

Line 2231: OPEN l_acceptedby_csr(FND_GLOBAL.USER_ID);

2227: l_ih_subject := p_email_attr.IH_SUBJECT;
2228: END IF;
2229: -- assemble interaction history body
2230: IF p_email_attr.IH_MESSAGE IS NULL THEN
2231: OPEN l_acceptedby_csr(FND_GLOBAL.USER_ID);
2232: FETCH l_acceptedby_csr INTO l_accepted_by;
2233: CLOSE l_acceptedby_csr;
2234:
2235: l_ih_message := get_message('OKS_IH_MESSAGE_ACCEPT',l_language);

Line 3646: last_updated_by = FND_GLOBAL.USER_ID,

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,
3647: last_update_login = FND_GLOBAL.LOGIN_ID,
3648: /* Added by sjanakir for Bug# 7639337 */
3649: quote_sent_flag = DECODE(p_negotiation_status,G_NEG_STS_QUOTE_SENT,'Y',quote_sent_flag)
3650: WHERE chr_id = p_chr_id;

Line 3647: last_update_login = FND_GLOBAL.LOGIN_ID,

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,
3647: last_update_login = FND_GLOBAL.LOGIN_ID,
3648: /* Added by sjanakir for Bug# 7639337 */
3649: quote_sent_flag = DECODE(p_negotiation_status,G_NEG_STS_QUOTE_SENT,'Y',quote_sent_flag)
3650: WHERE chr_id = p_chr_id;
3651:

Line 3658: last_updated_by = FND_GLOBAL.USER_ID,

3654: UPDATE okc_k_vers_numbers
3655: SET minor_version = minor_version + 1,
3656: object_version_number = object_version_number + 1,
3657: last_update_date = SYSDATE,
3658: last_updated_by = FND_GLOBAL.USER_ID,
3659: last_update_login = FND_GLOBAL.LOGIN_ID
3660: WHERE chr_id = p_chr_id;
3661: */
3662: END IF;

Line 3659: last_update_login = FND_GLOBAL.LOGIN_ID

3655: SET minor_version = minor_version + 1,
3656: object_version_number = object_version_number + 1,
3657: last_update_date = SYSDATE,
3658: last_updated_by = FND_GLOBAL.USER_ID,
3659: last_update_login = FND_GLOBAL.LOGIN_ID
3660: WHERE chr_id = p_chr_id;
3661: */
3662: END IF;
3663:

Line 4584: avalue => fnd_global.user_id

4580: (
4581: itemtype => G_ITEM_TYPE,
4582: itemkey => l_item_key,
4583: aname => 'USER_ID',
4584: avalue => fnd_global.user_id
4585: );
4586:
4587: wf_engine.SetItemAttrNumber
4588: (

Line 4592: avalue => fnd_global.resp_id

4588: (
4589: itemtype => G_ITEM_TYPE,
4590: itemkey => l_item_key,
4591: aname => 'RESP_ID',
4592: avalue => fnd_global.resp_id
4593: );
4594:
4595: wf_engine.SetItemAttrNumber
4596: (

Line 4600: avalue => fnd_global.resp_appl_id

4596: (
4597: itemtype => G_ITEM_TYPE,
4598: itemkey => l_item_key,
4599: aname => 'RESP_APPL_ID',
4600: avalue => fnd_global.resp_appl_id
4601: );
4602:
4603: wf_engine.SetItemAttrNumber
4604: (

Line 4608: avalue => fnd_global.security_group_id

4604: (
4605: itemtype => G_ITEM_TYPE,
4606: itemkey => l_item_key,
4607: aname => 'SECURITY_GROUP_ID',
4608: avalue => fnd_global.security_group_id
4609: );
4610:
4611: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
4612: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 4623: owner => fnd_global.user_name

4619: WF_ENGINE.setitemowner
4620: (
4621: itemtype => G_ITEM_TYPE,
4622: itemkey => l_item_key,
4623: owner => fnd_global.user_name
4624: );
4625:
4626: -- Start the workflow process
4627: WF_ENGINE.STARTPROCESS

Line 4641: last_updated_by = FND_GLOBAL.USER_ID,

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,
4641: last_updated_by = FND_GLOBAL.USER_ID,
4642: last_update_login = FND_GLOBAL.LOGIN_ID
4643: WHERE chr_id = p_wf_attributes.contract_id;
4644:
4645: -- Don't have to bump up minor version for updating design attributes

Line 4642: last_update_login = FND_GLOBAL.LOGIN_ID

4638: renewal_status = nvl(p_wf_attributes.negotiation_status, 'DRAFT'),
4639: object_version_number = object_version_number + 1,
4640: last_update_date = SYSDATE,
4641: last_updated_by = FND_GLOBAL.USER_ID,
4642: last_update_login = FND_GLOBAL.LOGIN_ID
4643: WHERE chr_id = p_wf_attributes.contract_id;
4644:
4645: -- Don't have to bump up minor version for updating design attributes
4646: -- bump up the minor version number

Line 4652: last_updated_by = FND_GLOBAL.USER_ID,

4648: UPDATE okc_k_vers_numbers
4649: SET minor_version = minor_version + 1,
4650: object_version_number = object_version_number + 1,
4651: last_update_date = SYSDATE,
4652: last_updated_by = FND_GLOBAL.USER_ID,
4653: last_update_login = FND_GLOBAL.LOGIN_ID
4654: WHERE chr_id = p_wf_attributes.contract_id;
4655: */
4656: END IF;

Line 4653: last_update_login = FND_GLOBAL.LOGIN_ID

4649: SET minor_version = minor_version + 1,
4650: object_version_number = object_version_number + 1,
4651: last_update_date = SYSDATE,
4652: last_updated_by = FND_GLOBAL.USER_ID,
4653: last_update_login = FND_GLOBAL.LOGIN_ID
4654: WHERE chr_id = p_wf_attributes.contract_id;
4655: */
4656: END IF;
4657:

Line 5261: -- is incorrectly setting these attributes to FND_GLOBAL values

5257: ELSIF l_negotiation_status = G_NEG_STS_QUOTE_SENT then
5258:
5259: -- get USER_ID, RESP_ID and SECURITY_GROUP_ID from old OKSARENW wf
5260: -- and stamp it in the new OKSKPRCS wf. bug 5723364. R12 Upgrade script
5261: -- is incorrectly setting these attributes to FND_GLOBAL values
5262: FOR l_user_dtls_rec IN l_user_dtls_csr(l_contract_id)
5263: LOOP
5264: wf_engine.SetItemAttrNumber
5265: (

Line 6301: p_user_id => fnd_global.user_id,

6297:
6298: -- Set wf item attributes to reflect the current user submitting for approval
6299: x_return_status := set_user_context(
6300: p_wf_item_key => l_item_key,
6301: p_user_id => fnd_global.user_id,
6302: p_resp_id => fnd_global.resp_id,
6303: p_resp_appl_id => fnd_global.resp_appl_id,
6304: p_security_group_id => fnd_global.security_group_id,
6305: p_commit => G_TRUE

Line 6302: p_resp_id => fnd_global.resp_id,

6298: -- Set wf item attributes to reflect the current user submitting for approval
6299: x_return_status := set_user_context(
6300: p_wf_item_key => l_item_key,
6301: p_user_id => fnd_global.user_id,
6302: p_resp_id => fnd_global.resp_id,
6303: p_resp_appl_id => fnd_global.resp_appl_id,
6304: p_security_group_id => fnd_global.security_group_id,
6305: p_commit => G_TRUE
6306: );

Line 6303: p_resp_appl_id => fnd_global.resp_appl_id,

6299: x_return_status := set_user_context(
6300: p_wf_item_key => l_item_key,
6301: p_user_id => fnd_global.user_id,
6302: p_resp_id => fnd_global.resp_id,
6303: p_resp_appl_id => fnd_global.resp_appl_id,
6304: p_security_group_id => fnd_global.security_group_id,
6305: p_commit => G_TRUE
6306: );
6307:

Line 6304: p_security_group_id => fnd_global.security_group_id,

6300: p_wf_item_key => l_item_key,
6301: p_user_id => fnd_global.user_id,
6302: p_resp_id => fnd_global.resp_id,
6303: p_resp_appl_id => fnd_global.resp_appl_id,
6304: p_security_group_id => fnd_global.security_group_id,
6305: p_commit => G_TRUE
6306: );
6307:
6308: -- This call is made for Authoring so that they don't have to access DB to get

Line 8500: last_updated_by = FND_GLOBAL.USER_ID,

8496: accepted_by = NULL,
8497: date_accepted = NULL,
8498: object_version_number = object_version_number + 1,
8499: last_update_date = SYSDATE,
8500: last_updated_by = FND_GLOBAL.USER_ID,
8501: last_update_login = FND_GLOBAL.LOGIN_ID
8502: WHERE chr_id = p_contract_id;
8503: wf_engine.AbortProcess (G_ITEM_TYPE, l_item_key);
8504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8501: last_update_login = FND_GLOBAL.LOGIN_ID

8497: date_accepted = NULL,
8498: object_version_number = object_version_number + 1,
8499: last_update_date = SYSDATE,
8500: last_updated_by = FND_GLOBAL.USER_ID,
8501: last_update_login = FND_GLOBAL.LOGIN_ID
8502: WHERE chr_id = p_contract_id;
8503: wf_engine.AbortProcess (G_ITEM_TYPE, l_item_key);
8504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

Line 9110: l_user_id_values(l_contract_id_count) := fnd_global.user_id;

9106: l_irr_flag_names(l_contract_id_count) := 'IRR_FLAG';
9107: l_irr_flag_values(l_contract_id_count) := nvl(p_wf_attributes_tbl(i).irr_flag, G_IRR_FLAG_REQD);
9108:
9109: l_user_id_names(l_contract_id_count) := 'USER_ID';
9110: l_user_id_values(l_contract_id_count) := fnd_global.user_id;
9111:
9112: l_responsibility_id_names(l_contract_id_count) := 'RESP_ID';
9113: l_responsibility_id_values(l_contract_id_count) := fnd_global.resp_id;
9114:

Line 9113: l_responsibility_id_values(l_contract_id_count) := fnd_global.resp_id;

9109: l_user_id_names(l_contract_id_count) := 'USER_ID';
9110: l_user_id_values(l_contract_id_count) := fnd_global.user_id;
9111:
9112: l_responsibility_id_names(l_contract_id_count) := 'RESP_ID';
9113: l_responsibility_id_values(l_contract_id_count) := fnd_global.resp_id;
9114:
9115: l_resp_appl_id_names(l_contract_id_count) := 'RESP_APPL_ID';
9116: l_resp_appl_id_values(l_contract_id_count) := fnd_global.resp_appl_id;
9117:

Line 9116: l_resp_appl_id_values(l_contract_id_count) := fnd_global.resp_appl_id;

9112: l_responsibility_id_names(l_contract_id_count) := 'RESP_ID';
9113: l_responsibility_id_values(l_contract_id_count) := fnd_global.resp_id;
9114:
9115: l_resp_appl_id_names(l_contract_id_count) := 'RESP_APPL_ID';
9116: l_resp_appl_id_values(l_contract_id_count) := fnd_global.resp_appl_id;
9117:
9118: l_security_group_id_names(l_contract_id_count) := 'SECURITY_GROUP_ID';
9119: l_security_group_id_values(l_contract_id_count) := fnd_global.security_group_id;
9120:

Line 9119: l_security_group_id_values(l_contract_id_count) := fnd_global.security_group_id;

9115: l_resp_appl_id_names(l_contract_id_count) := 'RESP_APPL_ID';
9116: l_resp_appl_id_values(l_contract_id_count) := fnd_global.resp_appl_id;
9117:
9118: l_security_group_id_names(l_contract_id_count) := 'SECURITY_GROUP_ID';
9119: l_security_group_id_values(l_contract_id_count) := fnd_global.security_group_id;
9120:
9121: l_neg_status_names(l_contract_id_count) := 'NEGOTIATION_STATUS';
9122: IF (p_wf_attributes_tbl(i).negotiation_status IS NULL OR
9123: p_wf_attributes_tbl(i).negotiation_status = G_NEG_STS_PRE_DRAFT) THEN

Line 9225: last_updated_by = FND_GLOBAL.USER_ID,

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,
9225: last_updated_by = FND_GLOBAL.USER_ID,
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

Line 9226: last_update_login = FND_GLOBAL.LOGIN_ID

9222: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
9223: object_version_number = object_version_number + 1,
9224: last_update_date = SYSDATE,
9225: last_updated_by = FND_GLOBAL.USER_ID,
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

Line 9235: last_updated_by = FND_GLOBAL.USER_ID,

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,
9235: last_updated_by = FND_GLOBAL.USER_ID,
9236: last_update_login = FND_GLOBAL.LOGIN_ID
9237: WHERE chr_id = l_contract_id_values(i);
9238: END IF;
9239: END IF;

Line 9236: last_update_login = FND_GLOBAL.LOGIN_ID

9232: object_version_number = object_version_number + 1,
9233: renewal_status = nvl(renewal_status,G_NEG_STS_DRAFT),
9234: last_update_date = SYSDATE,
9235: last_updated_by = FND_GLOBAL.USER_ID,
9236: last_update_login = FND_GLOBAL.LOGIN_ID
9237: WHERE chr_id = l_contract_id_values(i);
9238: END IF;
9239: END IF;
9240: