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.12 2012/01/04 10:32:48 rassharm 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 2330: --g_user_id := fnd_global.user_id;

2326: 1,
2327: 'N'
2328: );
2329: END IF;
2330: --g_user_id := fnd_global.user_id;
2331: -- fix for bug 3929409
2332: IF l_status = 'APPR' THEN
2333: OPEN get_last_approver (
2334: l_object_approval_id

Line 2355: g_user_id := fnd_global.user_id;

2351: CLOSE get_user_id;
2352: g_user_id := l_user_id;
2353:
2354: ELSE
2355: g_user_id := fnd_global.user_id;
2356:
2357: END IF;
2358:
2359: user_id := fnd_global.user_id;

Line 2359: user_id := fnd_global.user_id;

2355: g_user_id := fnd_global.user_id;
2356:
2357: END IF;
2358:
2359: user_id := fnd_global.user_id;
2360: resp_id := fnd_global.RESP_ID;
2361: resp_appl_id := fnd_global.RESP_APPL_ID;
2362:
2363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2360: resp_id := fnd_global.RESP_ID;

2356:
2357: END IF;
2358:
2359: user_id := fnd_global.user_id;
2360: resp_id := fnd_global.RESP_ID;
2361: resp_appl_id := fnd_global.RESP_APPL_ID;
2362:
2363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2364: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');

Line 2361: resp_appl_id := fnd_global.RESP_APPL_ID;

2357: END IF;
2358:
2359: user_id := fnd_global.user_id;
2360: resp_id := fnd_global.RESP_ID;
2361: resp_appl_id := fnd_global.RESP_APPL_ID;
2362:
2363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2364: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2365: aso_debug_pub.ADD( 'BEFORE resetting the original values ',1,'N');

Line 2366: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');

2362:
2363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2364: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2365: aso_debug_pub.ADD( 'BEFORE resetting the original values ',1,'N');
2366: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2367: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2368: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2369: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2370: END IF;

Line 2367: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');

2363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2364: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2365: aso_debug_pub.ADD( 'BEFORE resetting the original values ',1,'N');
2366: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2367: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2368: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2369: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2370: END IF;
2371: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);

Line 2368: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');

2364: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2365: aso_debug_pub.ADD( 'BEFORE resetting the original values ',1,'N');
2366: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2367: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2368: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2369: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2370: END IF;
2371: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);
2372:

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

2367: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2368: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2369: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2370: END IF;
2371: FND_GLOBAL.APPS_INITIALIZE(g_user_id,0,0,0);
2372:
2373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2374: aso_debug_pub.ADD( 'After setting the global values ',1,'N');
2375: END IF;

Line 2583: FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id,resp_appl_id,0);

2579:
2580: mo_global.set_policy_context('M',null);
2581:
2582:
2583: FND_GLOBAL.APPS_INITIALIZE(user_id,resp_id,resp_appl_id,0);
2584:
2585: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2586: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2587: aso_debug_pub.ADD( 'After resetting back the original values ',1,'N');

Line 2588: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');

2584:
2585: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2586: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2587: aso_debug_pub.ADD( 'After resetting back the original values ',1,'N');
2588: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2589: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2590: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2591: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2592: END IF;

Line 2589: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');

2585: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2586: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2587: aso_debug_pub.ADD( 'After resetting back the original values ',1,'N');
2588: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2589: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2590: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2591: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2592: END IF;
2593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 2590: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');

2586: aso_debug_pub.ADD( 'new debug for bug 6072144 ',1,'N');
2587: aso_debug_pub.ADD( 'After resetting back the original values ',1,'N');
2588: aso_debug_pub.ADD( 'fnd_global.user_id: '|| fnd_global.user_id,1,'N');
2589: aso_debug_pub.ADD( 'fnd_global.resp_id: '|| fnd_global.resp_id,1,'N');
2590: aso_debug_pub.ADD( 'fnd_global.resp_appl_id: '|| fnd_global.resp_appl_id,1,'N');
2591: aso_debug_pub.ADD( 'end debug for bug 6072144 ',1,'N');
2592: END IF;
2593: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2594: aso_debug_pub.ADD (

Line 2755: g_user_id := fnd_global.user_id;

2751: 1,
2752: 'N'
2753: );
2754: END IF;
2755: g_user_id := fnd_global.user_id;
2756: -- get the latest list of approvers
2757: OPEN get_object_id (
2758: p_object_approval_id
2759: );

Line 3124: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3120: ).created_by -- P_CREATED_BY
3121: ,
3122: g_user_id -- P_UPDATED_BY
3123: ,
3124: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3125: ,
3126: l_new_approvers_tbl (
3127: j
3128: ).attribute1 -- p_ATTRIBUTE1

Line 3325: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3321: SYSDATE -- p_LAST_UPDATE_DATE
3322: ,
3323: g_user_id -- P_UPDATED_BY
3324: ,
3325: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3326: ,
3327: p_object_approval_id,
3328: NULL -- p_ATTRIBUTE1
3329: ,

Line 3490: g_user_id := fnd_global.user_id;

3486: 1,
3487: 'N'
3488: );
3489: END IF;
3490: g_user_id := fnd_global.user_id;
3491: OPEN get_application_id (
3492: p_object_approval_id
3493: );
3494: FETCH get_application_id INTO l_object_id, l_object_type, l_application_id;

Line 3637: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN

3633: g_user_id -- P_CREATED_BY
3634: ,
3635: g_user_id -- P_UPDATED_BY
3636: ,
3637: fnd_global.conc_login_id -- p_LAST_UPDATE_LOGIN
3638: ,
3639: NULL -- p_ATTRIBUTE1
3640: ,
3641: NULL -- p_ATTRIBUTE2

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

4124: 1,
4125: 'N'
4126: );
4127: END IF;
4128: document := document || fnd_global.local_chr (
4129: 10
4130: );
4131: document := document || l_attribute_tbl (
4132: 11

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

4130: );
4131: document := document || l_attribute_tbl (
4132: 11
4133: );
4134: document := document || fnd_global.local_chr (
4135: 10
4136: );
4137:
4138: FOR i IN approver_details (

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

4144: aso_apr_int.get_approver_name (
4145: i.approver_user_id,
4146: i.approver_person_id
4147: );
4148: document := document || fnd_global.local_chr (
4149: 10
4150: );
4151: document := document || l_attribute_tbl (
4152: 12

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

4152: 12
4153: );
4154: document := document || ': ';
4155: document := document || l_approver_display_name;
4156: document := document || fnd_global.local_chr (
4157: 10
4158: );
4159: document := document || l_attribute_tbl (
4160: 13

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

4488: document := document
4489: || ''
4490: || l_expiration_date
4491: || '';
4492: document := document || '' || fnd_global.local_chr (
4493: 38
4494: ) || 'nbsp';
4495: document := document
4496: || ''

Line 4497: || fnd_global.local_chr (

4493: 38
4494: ) || 'nbsp';
4495: document := document
4496: || ''
4497: || fnd_global.local_chr (
4498: 38
4499: )
4500: || 'nbsp;';
4501: document := document || ' ';

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

4512: 1,
4513: 'N'
4514: );
4515: END IF;
4516: document := document || fnd_global.local_chr (
4517: 10
4518: );
4519: document := document || l_attribute_tbl (
4520: 3

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

4520: 3
4521: );
4522: document := document || ': ';
4523: document := document || l_quote_name;
4524: document := document || fnd_global.local_chr (
4525: 10
4526: );
4527: document := document || l_attribute_tbl (
4528: 4

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

4528: 4
4529: );
4530: document := document || ': ';
4531: document := document || l_quote_number;
4532: document := document || fnd_global.local_chr (
4533: 10
4534: );
4535: document := document || l_attribute_tbl (
4536: 5

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

4536: 5
4537: );
4538: document := document || ': ';
4539: document := document || l_customer_name;
4540: document := document || fnd_global.local_chr (
4541: 10
4542: );
4543: document := document || l_attribute_tbl (
4544: 6

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

4544: 6
4545: );
4546: document := document || ': ';
4547: document := document || l_account_number;
4548: document := document || fnd_global.local_chr (
4549: 10
4550: );
4551: document := document || l_attribute_tbl (
4552: 7

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

4552: 7
4553: );
4554: document := document || ': ';
4555: document := document || l_contact_name;
4556: document := document || fnd_global.local_chr (
4557: 10
4558: );
4559: document := document || l_attribute_tbl (
4560: 8

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

4560: 8
4561: );
4562: document := document || ': ';
4563: document := document || l_opportunity_name;
4564: document := document || fnd_global.local_chr (
4565: 10
4566: );
4567: document := document || l_attribute_tbl (
4568: 9

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

4726: 1,
4727: 'N'
4728: );
4729: END IF;
4730: document := document || fnd_global.local_chr (
4731: 10
4732: );
4733: document := document || l_attribute_tbl (
4734: 10

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

4732: );
4733: document := document || l_attribute_tbl (
4734: 10
4735: );
4736: document := document || fnd_global.local_chr (
4737: 10
4738: );
4739:
4740: FOR i IN get_requester_details (

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

4743: LOOP
4744: document := document || i.requester_comments;
4745: END LOOP;
4746:
4747: document := document || fnd_global.local_chr (
4748: 10
4749: );
4750: document_type := 'text/plain';
4751: END IF;

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

4950: 1,
4951: 'N'
4952: );
4953: END IF;
4954: document := document || fnd_global.local_chr (
4955: 10
4956: );
4957: document := document || l_attribute_tbl (
4958: 14

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

4956: );
4957: document := document || l_attribute_tbl (
4958: 14
4959: );
4960: document := document || fnd_global.local_chr (
4961: 10
4962: );
4963:
4964: FOR i IN get_rule_details (

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

4985: 15
4986: );
4987: document := document || ': ';
4988: document := document || l_rule_description;
4989: document := document || fnd_global.local_chr (
4990: 10
4991: );
4992: document := document || l_attribute_tbl (
4993: 16

Line 5155: || fnd_global.local_chr (

5151:
5152: l_jsp_name := 'qotSZzpAppsLink.jsp?';
5153: l_jsp_name := l_jsp_name || 'qotFrmMainFile=qotSZzdContainer.jsp';
5154: l_jsp_name := l_jsp_name
5155: || fnd_global.local_chr (
5156: 38
5157: )
5158: || 'qotFrmDspFile=qotSCocOverview.jsp';
5159: l_jsp_name := l_jsp_name

Line 5160: || fnd_global.local_chr (

5156: 38
5157: )
5158: || 'qotFrmDspFile=qotSCocOverview.jsp';
5159: l_jsp_name := l_jsp_name
5160: || fnd_global.local_chr (
5161: 38
5162: )
5163: || 'qotFrmRefFile=qotSCocOverview.jsp';
5164: l_jsp_name := l_jsp_name

Line 5165: || fnd_global.local_chr (

5161: 38
5162: )
5163: || 'qotFrmRefFile=qotSCocOverview.jsp';
5164: l_jsp_name := l_jsp_name
5165: || fnd_global.local_chr (
5166: 38
5167: )
5168: || 'qotDetCode=QUOTE';
5169: l_jsp_name := l_jsp_name

Line 5170: || fnd_global.local_chr (

5166: 38
5167: )
5168: || 'qotDetCode=QUOTE';
5169: l_jsp_name := l_jsp_name
5170: || fnd_global.local_chr (
5171: 38
5172: )
5173: || 'qotPtyType='
5174: || l_party_type;

Line 5176: || fnd_global.local_chr (

5172: )
5173: || 'qotPtyType='
5174: || l_party_type;
5175: l_jsp_name := l_jsp_name
5176: || fnd_global.local_chr (
5177: 38
5178: )
5179: || 'qotHdrId='
5180: || l_quote_header_id;

Line 5182: || fnd_global.local_chr (

5178: )
5179: || 'qotHdrId='
5180: || l_quote_header_id;
5181: l_jsp_name := l_jsp_name
5182: || fnd_global.local_chr (
5183: 38
5184: )
5185: || 'qotHdrAcctId='
5186: || l_cust_account_id;

Line 5188: || fnd_global.local_chr (

5184: )
5185: || 'qotHdrAcctId='
5186: || l_cust_account_id;
5187: l_jsp_name := l_jsp_name
5188: || fnd_global.local_chr (
5189: 38
5190: )
5191: || 'qotHdrNbr='
5192: || l_quote_number;

Line 5194: || fnd_global.local_chr (

5190: )
5191: || 'qotHdrNbr='
5192: || l_quote_number;
5193: l_jsp_name := l_jsp_name
5194: || fnd_global.local_chr (
5195: 38
5196: )
5197: || 'qotReqSetCookie=Y';
5198: l_jsp_name := l_jsp_name

Line 5199: || fnd_global.local_chr (

5195: 38
5196: )
5197: || 'qotReqSetCookie=Y';
5198: l_jsp_name := l_jsp_name
5199: || fnd_global.local_chr (
5200: 38
5201: )
5202: || 'qotFromApvlLink=Y';
5203:

Line 5206: || fnd_global.local_chr (

5202: || 'qotFromApvlLink=Y';
5203:
5204: -- bug 3178070
5205: l_jsp_name := l_jsp_name
5206: || fnd_global.local_chr (
5207: 38
5208: )
5209: || 'qotApvOrgId='
5210: || l_org_id;

Line 5213: || fnd_global.local_chr (

5209: || 'qotApvOrgId='
5210: || l_org_id;
5211:
5212: l_jsp_name := l_jsp_name
5213: || fnd_global.local_chr (
5214: 38
5215: )
5216: || 'qotApvNotifId=&#NID';
5217:

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

5441:
5442: l_approval_object VARCHAR2 (4000);
5443: l_approval_id NUMBER;
5444: l_org_id NUMBER;
5445: l_ampsign VARCHAR2(1) := fnd_global.local_chr(38);
5446: l_url VARCHAR2(32000);
5447:
5448: -- bug 7657061
5449: l_resp_appl_id NUMBER := 880;

Line 5633: last_updated_by = fnd_global.user_id,

5629: SET approver_status = p_status,
5630: date_received = SYSDATE,
5631: last_update_date = SYSDATE,
5632: approver_comments = note,
5633: last_updated_by = fnd_global.user_id,
5634: last_update_login = fnd_global.user_id
5635: WHERE approval_det_id = p_approval_det_id;
5636: END IF;
5637:

Line 5634: last_update_login = fnd_global.user_id

5630: date_received = SYSDATE,
5631: last_update_date = SYSDATE,
5632: approver_comments = note,
5633: last_updated_by = fnd_global.user_id,
5634: last_update_login = fnd_global.user_id
5635: WHERE approval_det_id = p_approval_det_id;
5636: END IF;
5637:
5638: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN