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.ASO_APR_WF_PVT dependencies on FND_GLOBAL

Line 3: g_user_id NUMBER:= FND_GLOBAL.USER_ID;

1: PACKAGE BODY aso_apr_wf_pvt AS
2: /* $Header: asovwapb.pls 120.9 2007/01/31 19:12:16 skulkarn ship $ */
3: g_user_id NUMBER:= FND_GLOBAL.USER_ID;
4:
5: PROCEDURE start_aso_approvals (
6: P_Object_approval_id IN NUMBER,
7: P_itemtype_name IN VARCHAR2,

Line 374: last_updated_by = fnd_global.user_id,

370: UPDATE aso_apr_approval_details
371: SET approver_status = 'PEND',
372: date_sent = SYSDATE,
373: last_update_date = SYSDATE,
374: last_updated_by = fnd_global.user_id,
375: last_update_login = fnd_global.user_id
376: WHERE object_approval_id = l_approval_id
377: AND approver_sequence = next_seq;
378: END LOOP;

Line 375: last_update_login = fnd_global.user_id

371: SET approver_status = 'PEND',
372: date_sent = SYSDATE,
373: last_update_date = SYSDATE,
374: last_updated_by = fnd_global.user_id,
375: last_update_login = fnd_global.user_id
376: WHERE object_approval_id = l_approval_id
377: AND approver_sequence = next_seq;
378: END LOOP;
379:

Line 1720: last_updated_by = fnd_global.user_id,

1716: UPDATE aso_apr_approval_details
1717: SET approver_status = 'CAN',
1718: date_sent = SYSDATE,
1719: last_update_date = SYSDATE,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.user_id
1722: WHERE approval_det_id = i.approval_det_id;
1723: END LOOP;
1724:

Line 1721: last_update_login = fnd_global.user_id

1717: SET approver_status = 'CAN',
1718: date_sent = SYSDATE,
1719: last_update_date = SYSDATE,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.user_id
1722: WHERE approval_det_id = i.approval_det_id;
1723: END LOOP;
1724:
1725: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2326: --g_user_id := fnd_global.user_id;

2322: 1,
2323: 'N'
2324: );
2325: END IF;
2326: --g_user_id := fnd_global.user_id;
2327: -- fix for bug 3929409
2328: IF l_status = 'APPR' THEN
2329: OPEN get_last_approver (
2330: l_object_approval_id

Line 2351: g_user_id := fnd_global.user_id;

2347: CLOSE get_user_id;
2348: g_user_id := l_user_id;
2349:
2350: ELSE
2351: g_user_id := fnd_global.user_id;
2352:
2353: END IF;
2354:
2355: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);

Line 2355: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);

2351: g_user_id := fnd_global.user_id;
2352:
2353: END IF;
2354:
2355: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);
2356:
2357:
2358: l_quote_header_rec := aso_quote_pub.g_miss_qte_header_rec;
2359:

Line 2726: g_user_id := fnd_global.user_id;

2722: 1,
2723: 'N'
2724: );
2725: END IF;
2726: g_user_id := fnd_global.user_id;
2727: -- get the latest list of approvers
2728: OPEN get_object_id (
2729: p_object_approval_id
2730: );

Line 3095: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3091: ).created_by -- P_CREATED_BY
3092: ,
3093: g_user_id -- P_UPDATED_BY
3094: ,
3095: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3096: ,
3097: l_new_approvers_tbl (
3098: j
3099: ).attribute1 -- p_ATTRIBUTE1

Line 3296: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3292: SYSDATE -- p_LAST_UPDATE_DATE
3293: ,
3294: g_user_id -- P_UPDATED_BY
3295: ,
3296: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3297: ,
3298: p_object_approval_id,
3299: NULL -- p_ATTRIBUTE1
3300: ,

Line 3461: g_user_id := fnd_global.user_id;

3457: 1,
3458: 'N'
3459: );
3460: END IF;
3461: g_user_id := fnd_global.user_id;
3462: OPEN get_application_id (
3463: p_object_approval_id
3464: );
3465: FETCH get_application_id INTO l_object_id, l_object_type, l_application_id;

Line 3608: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3604: g_user_id -- P_CREATED_BY
3605: ,
3606: g_user_id -- P_UPDATED_BY
3607: ,
3608: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3609: ,
3610: NULL -- p_ATTRIBUTE1
3611: ,
3612: NULL -- p_ATTRIBUTE2

Line 4098: document := document || fnd_global.local_chr (

4094: 1,
4095: 'N'
4096: );
4097: END IF;
4098: document := document || fnd_global.local_chr (
4099: 10
4100: );
4101: document := document || l_attribute_tbl (
4102: 11

Line 4104: document := document || fnd_global.local_chr (

4100: );
4101: document := document || l_attribute_tbl (
4102: 11
4103: );
4104: document := document || fnd_global.local_chr (
4105: 10
4106: );
4107:
4108: FOR i IN approver_details (

Line 4118: document := document || fnd_global.local_chr (

4114: aso_apr_int.get_approver_name (
4115: i.approver_user_id,
4116: i.approver_person_id
4117: );
4118: document := document || fnd_global.local_chr (
4119: 10
4120: );
4121: document := document || l_attribute_tbl (
4122: 12

Line 4126: document := document || fnd_global.local_chr (

4122: 12
4123: );
4124: document := document || ': ';
4125: document := document || l_approver_display_name;
4126: document := document || fnd_global.local_chr (
4127: 10
4128: );
4129: document := document || l_attribute_tbl (
4130: 13

Line 4462: document := document || '' || fnd_global.local_chr (

4458: document := document
4459: || ''
4460: || l_expiration_date
4461: || '';
4462: document := document || '' || fnd_global.local_chr (
4463: 38
4464: ) || 'nbsp';
4465: document := document
4466: || ''

Line 4467: || fnd_global.local_chr (

4463: 38
4464: ) || 'nbsp';
4465: document := document
4466: || ''
4467: || fnd_global.local_chr (
4468: 38
4469: )
4470: || 'nbsp;';
4471: document := document || ' ';

Line 4486: document := document || fnd_global.local_chr (

4482: 1,
4483: 'N'
4484: );
4485: END IF;
4486: document := document || fnd_global.local_chr (
4487: 10
4488: );
4489: document := document || l_attribute_tbl (
4490: 3

Line 4494: document := document || fnd_global.local_chr (

4490: 3
4491: );
4492: document := document || ': ';
4493: document := document || l_quote_name;
4494: document := document || fnd_global.local_chr (
4495: 10
4496: );
4497: document := document || l_attribute_tbl (
4498: 4

Line 4502: document := document || fnd_global.local_chr (

4498: 4
4499: );
4500: document := document || ': ';
4501: document := document || l_quote_number;
4502: document := document || fnd_global.local_chr (
4503: 10
4504: );
4505: document := document || l_attribute_tbl (
4506: 5

Line 4510: document := document || fnd_global.local_chr (

4506: 5
4507: );
4508: document := document || ': ';
4509: document := document || l_customer_name;
4510: document := document || fnd_global.local_chr (
4511: 10
4512: );
4513: document := document || l_attribute_tbl (
4514: 6

Line 4518: document := document || fnd_global.local_chr (

4514: 6
4515: );
4516: document := document || ': ';
4517: document := document || l_account_number;
4518: document := document || fnd_global.local_chr (
4519: 10
4520: );
4521: document := document || l_attribute_tbl (
4522: 7

Line 4526: document := document || fnd_global.local_chr (

4522: 7
4523: );
4524: document := document || ': ';
4525: document := document || l_contact_name;
4526: document := document || fnd_global.local_chr (
4527: 10
4528: );
4529: document := document || l_attribute_tbl (
4530: 8

Line 4534: document := document || fnd_global.local_chr (

4530: 8
4531: );
4532: document := document || ': ';
4533: document := document || l_opportunity_name;
4534: document := document || fnd_global.local_chr (
4535: 10
4536: );
4537: document := document || l_attribute_tbl (
4538: 9

Line 4700: document := document || fnd_global.local_chr (

4696: 1,
4697: 'N'
4698: );
4699: END IF;
4700: document := document || fnd_global.local_chr (
4701: 10
4702: );
4703: document := document || l_attribute_tbl (
4704: 10

Line 4706: document := document || fnd_global.local_chr (

4702: );
4703: document := document || l_attribute_tbl (
4704: 10
4705: );
4706: document := document || fnd_global.local_chr (
4707: 10
4708: );
4709:
4710: FOR i IN get_requester_details (

Line 4717: document := document || fnd_global.local_chr (

4713: LOOP
4714: document := document || i.requester_comments;
4715: END LOOP;
4716:
4717: document := document || fnd_global.local_chr (
4718: 10
4719: );
4720: document_type := 'text/plain';
4721: END IF;

Line 4924: document := document || fnd_global.local_chr (

4920: 1,
4921: 'N'
4922: );
4923: END IF;
4924: document := document || fnd_global.local_chr (
4925: 10
4926: );
4927: document := document || l_attribute_tbl (
4928: 14

Line 4930: document := document || fnd_global.local_chr (

4926: );
4927: document := document || l_attribute_tbl (
4928: 14
4929: );
4930: document := document || fnd_global.local_chr (
4931: 10
4932: );
4933:
4934: FOR i IN get_rule_details (

Line 4959: document := document || fnd_global.local_chr (

4955: 15
4956: );
4957: document := document || ': ';
4958: document := document || l_rule_description;
4959: document := document || fnd_global.local_chr (
4960: 10
4961: );
4962: document := document || l_attribute_tbl (
4963: 16

Line 5125: || fnd_global.local_chr (

5121:
5122: l_jsp_name := 'qotSZzpAppsLink.jsp?';
5123: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
5124: l_jsp_name := l_jsp_name
5125: || fnd_global.local_chr (
5126: 38
5127: )
5128: || 'qotFrmDspFile=qotSCocOverview.jsp';
5129: l_jsp_name := l_jsp_name

Line 5130: || fnd_global.local_chr (

5126: 38
5127: )
5128: || 'qotFrmDspFile=qotSCocOverview.jsp';
5129: l_jsp_name := l_jsp_name
5130: || fnd_global.local_chr (
5131: 38
5132: )
5133: || 'qotFrmRefFile=qotSCocOverview.jsp';
5134: l_jsp_name := l_jsp_name

Line 5135: || fnd_global.local_chr (

5131: 38
5132: )
5133: || 'qotFrmRefFile=qotSCocOverview.jsp';
5134: l_jsp_name := l_jsp_name
5135: || fnd_global.local_chr (
5136: 38
5137: )
5138: || 'qotDetCode=QUOTE';
5139: l_jsp_name := l_jsp_name

Line 5140: || fnd_global.local_chr (

5136: 38
5137: )
5138: || 'qotDetCode=QUOTE';
5139: l_jsp_name := l_jsp_name
5140: || fnd_global.local_chr (
5141: 38
5142: )
5143: || 'qotPtyType='
5144: || l_party_type;

Line 5146: || fnd_global.local_chr (

5142: )
5143: || 'qotPtyType='
5144: || l_party_type;
5145: l_jsp_name := l_jsp_name
5146: || fnd_global.local_chr (
5147: 38
5148: )
5149: || 'qotHdrId='
5150: || l_quote_header_id;

Line 5152: || fnd_global.local_chr (

5148: )
5149: || 'qotHdrId='
5150: || l_quote_header_id;
5151: l_jsp_name := l_jsp_name
5152: || fnd_global.local_chr (
5153: 38
5154: )
5155: || 'qotHdrAcctId='
5156: || l_cust_account_id;

Line 5158: || fnd_global.local_chr (

5154: )
5155: || 'qotHdrAcctId='
5156: || l_cust_account_id;
5157: l_jsp_name := l_jsp_name
5158: || fnd_global.local_chr (
5159: 38
5160: )
5161: || 'qotHdrNbr='
5162: || l_quote_number;

Line 5164: || fnd_global.local_chr (

5160: )
5161: || 'qotHdrNbr='
5162: || l_quote_number;
5163: l_jsp_name := l_jsp_name
5164: || fnd_global.local_chr (
5165: 38
5166: )
5167: || 'qotReqSetCookie=Y';
5168: l_jsp_name := l_jsp_name

Line 5169: || fnd_global.local_chr (

5165: 38
5166: )
5167: || 'qotReqSetCookie=Y';
5168: l_jsp_name := l_jsp_name
5169: || fnd_global.local_chr (
5170: 38
5171: )
5172: || 'qotFromApvlLink=Y';
5173:

Line 5176: || fnd_global.local_chr (

5172: || 'qotFromApvlLink=Y';
5173:
5174: -- bug 3178070
5175: l_jsp_name := l_jsp_name
5176: || fnd_global.local_chr (
5177: 38
5178: )
5179: || 'qotApvOrgId='
5180: || l_org_id;

Line 5183: || fnd_global.local_chr (

5179: || 'qotApvOrgId='
5180: || l_org_id;
5181:
5182: l_jsp_name := l_jsp_name
5183: || fnd_global.local_chr (
5184: 38
5185: )
5186: || 'qotApvNotifId=&#NID';
5187:

Line 5415: l_ampsign VARCHAR2(1) := fnd_global.local_chr(38);

5411:
5412: l_approval_object VARCHAR2 (4000);
5413: l_approval_id NUMBER;
5414: l_org_id NUMBER;
5415: l_ampsign VARCHAR2(1) := fnd_global.local_chr(38);
5416: l_url VARCHAR2(32000);
5417:
5418:
5419: CURSOR OBJECT (

Line 5490: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,

5486:
5487: -- bug 5350149
5488: l_url := aso_apr_wf_pvt.GetRunFuncURL(
5489: p_function_name => 'QOT_OAUI_QUOTE_DETAILS',
5490: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
5491: p_resp_id => FND_GLOBAL.RESP_ID,
5492: p_parameters => l_ampsign||l_ampsign||'QotIntgEvtSrc=ApvlNotif'||l_ampsign||'QotIntgEvt=Event.QuoteDet'||l_ampsign||'QotIntgEvtVal='
5493: ||i.quote_header_id||l_ampsign||'QotIntgEvtVal1='||i.quote_number||l_ampsign||'addBreadCrumb=Y') ;
5494:

Line 5491: p_resp_id => FND_GLOBAL.RESP_ID,

5487: -- bug 5350149
5488: l_url := aso_apr_wf_pvt.GetRunFuncURL(
5489: p_function_name => 'QOT_OAUI_QUOTE_DETAILS',
5490: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
5491: p_resp_id => FND_GLOBAL.RESP_ID,
5492: p_parameters => l_ampsign||l_ampsign||'QotIntgEvtSrc=ApvlNotif'||l_ampsign||'QotIntgEvt=Event.QuoteDet'||l_ampsign||'QotIntgEvtVal='
5493: ||i.quote_header_id||l_ampsign||'QotIntgEvtVal1='||i.quote_number||l_ampsign||'addBreadCrumb=Y') ;
5494:
5495:

Line 5497: aso_debug_pub.ADD ('RESP_APPL_ID: ' || FND_GLOBAL.RESP_APPL_ID,1,'N');

5493: ||i.quote_header_id||l_ampsign||'QotIntgEvtVal1='||i.quote_number||l_ampsign||'addBreadCrumb=Y') ;
5494:
5495:
5496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5497: aso_debug_pub.ADD ('RESP_APPL_ID: ' || FND_GLOBAL.RESP_APPL_ID,1,'N');
5498: aso_debug_pub.ADD ('RESP_ID: ' || FND_GLOBAL.RESP_ID,1,'N');
5499: aso_debug_pub.ADD ('l_url: '||substr(l_url,1,240),1,'N');
5500: END IF;
5501:

Line 5498: aso_debug_pub.ADD ('RESP_ID: ' || FND_GLOBAL.RESP_ID,1,'N');

5494:
5495:
5496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5497: aso_debug_pub.ADD ('RESP_APPL_ID: ' || FND_GLOBAL.RESP_APPL_ID,1,'N');
5498: aso_debug_pub.ADD ('RESP_ID: ' || FND_GLOBAL.RESP_ID,1,'N');
5499: aso_debug_pub.ADD ('l_url: '||substr(l_url,1,240),1,'N');
5500: END IF;
5501:
5502:

Line 5598: last_updated_by = fnd_global.user_id,

5594: SET approver_status = p_status,
5595: date_received = SYSDATE,
5596: last_update_date = SYSDATE,
5597: approver_comments = note,
5598: last_updated_by = fnd_global.user_id,
5599: last_update_login = fnd_global.user_id
5600: WHERE approval_det_id = p_approval_det_id;
5601: END IF;
5602:

Line 5599: last_update_login = fnd_global.user_id

5595: date_received = SYSDATE,
5596: last_update_date = SYSDATE,
5597: approver_comments = note,
5598: last_updated_by = fnd_global.user_id,
5599: last_update_login = fnd_global.user_id
5600: WHERE approval_det_id = p_approval_det_id;
5601: END IF;
5602:
5603: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN