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

Line 225: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);

221: l_appl_id := wf_engine.GetItemAttrNumber
222: (itemtype => itemtype,
223: itemkey => itemkey,
224: aname =>'APPL_ID');
225: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
226:
227: -- Bug 9000703 End
228: end if;
229:

Line 1842: l_user_id := fnd_global.user_id;

1838:
1839:
1840: BEGIN
1841: -- Bug # 9069005
1842: l_user_id := fnd_global.user_id;
1843: l_resp_id := fnd_global.resp_id;
1844: l_appl_id := fnd_global.resp_appl_id;
1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
1846:

Line 1843: l_resp_id := fnd_global.resp_id;

1839:
1840: BEGIN
1841: -- Bug # 9069005
1842: l_user_id := fnd_global.user_id;
1843: l_resp_id := fnd_global.resp_id;
1844: l_appl_id := fnd_global.resp_appl_id;
1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
1846:
1847: --Bug No:5897122.

Line 1844: l_appl_id := fnd_global.resp_appl_id;

1840: BEGIN
1841: -- Bug # 9069005
1842: l_user_id := fnd_global.user_id;
1843: l_resp_id := fnd_global.resp_id;
1844: l_appl_id := fnd_global.resp_appl_id;
1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
1846:
1847: --Bug No:5897122.
1848: --Bug No: 6865713. Replaced l_trx_id with p_trx_id.

Line 1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);

1841: -- Bug # 9069005
1842: l_user_id := fnd_global.user_id;
1843: l_resp_id := fnd_global.resp_id;
1844: l_appl_id := fnd_global.resp_appl_id;
1845: FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
1846:
1847: --Bug No:5897122.
1848: --Bug No: 6865713. Replaced l_trx_id with p_trx_id.
1849: create_wf_roles(p_trx_id);

Line 1861: avalue => FND_GLOBAL.USER_NAME);

1857: wf_engine.SetItemAttrText
1858: (itemtype => 'FUNRMAIN',
1859: itemkey => p_eventkey,
1860: aname => 'UI_ACTION_USER_NAME',
1861: avalue => FND_GLOBAL.USER_NAME);
1862:
1863: wf_engine.SetItemAttrNumber
1864: (itemtype => 'FUNRMAIN',
1865: itemkey => p_eventkey,

Line 1867: avalue => FND_GLOBAL.USER_ID);

1863: wf_engine.SetItemAttrNumber
1864: (itemtype => 'FUNRMAIN',
1865: itemkey => p_eventkey,
1866: aname => 'UI_ACTION_USER_ID',
1867: avalue => FND_GLOBAL.USER_ID);
1868:
1869: --get process/activity name
1870: SELECT WPA.ACTIVITY_NAME
1871: INTO l_activity_name

Line 1886: l_approver_record.name := FND_GLOBAL.USER_NAME;

1882:
1883: IF l_activity_name IN ('APPROVAL_NTF', 'APPROVAL_ONLY_NTF',
1884: 'FIX_ACCT_DIST_NTF_NO_REJ', 'FIX_ACCT_DIST_NTF' )
1885: THEN
1886: l_approver_record.name := FND_GLOBAL.USER_NAME;
1887: l_approver_record.approval_status := AME_UTIL.approvedStatus;
1888:
1889: ame_api2.updateApprovalStatus(
1890: applicationIdIn => 435,

Line 1899: SET approver_id = FND_GLOBAL.USER_ID,

1895: -- Update the approver id onto the fun_trx_headers table.
1896: -- approver_id will always hold the id of the last person
1897: -- to approve the transaction.
1898: UPDATE fun_trx_headers
1899: SET approver_id = FND_GLOBAL.USER_ID,
1900: approval_date = SYSDATE
1901: WHERE trx_id = p_trx_id;
1902:
1903: END IF;

Line 1967: avalue => FND_GLOBAL.USER_NAME);

1963: wf_engine.SetItemAttrText
1964: (itemtype => 'FUNRMAIN',
1965: itemkey => p_eventkey,
1966: aname => 'UI_ACTION_USER_NAME',
1967: avalue => FND_GLOBAL.USER_NAME);
1968:
1969: wf_engine.SetItemAttrNumber
1970: (itemtype => 'FUNRMAIN',
1971: itemkey => p_eventkey,

Line 1973: avalue => FND_GLOBAL.USER_ID);

1969: wf_engine.SetItemAttrNumber
1970: (itemtype => 'FUNRMAIN',
1971: itemkey => p_eventkey,
1972: aname => 'UI_ACTION_USER_ID',
1973: avalue => FND_GLOBAL.USER_ID);
1974:
1975: --check reject allowed
1976: SELECT reject_allow_flag INTO l_result
1977: FROM fun_trx_batches

Line 2007: l_approver_record.name := FND_GLOBAL.USER_NAME;

2003: p_trx_id => p_trx_id,
2004: p_update_status_to => 'REJECTED');
2005:
2006: -- Update the AME System with the 'APPROVED' status.
2007: l_approver_record.name := FND_GLOBAL.USER_NAME;
2008: l_approver_record.approval_status := AME_UTIL.rejectStatus;
2009:
2010: ame_api2.updateApprovalStatus(
2011: applicationIdIn => 435,

Line 2077: avalue => FND_GLOBAL.USER_NAME);

2073: wf_engine.SetItemAttrText
2074: (itemtype => 'FUNRMAIN',
2075: itemkey => p_eventkey,
2076: aname => 'UI_ACTION_USER_NAME',
2077: avalue => FND_GLOBAL.USER_NAME);
2078:
2079: wf_engine.SetItemAttrNumber
2080: (itemtype => 'FUNRMAIN',
2081: itemkey => p_eventkey,

Line 2083: avalue => FND_GLOBAL.USER_ID);

2079: wf_engine.SetItemAttrNumber
2080: (itemtype => 'FUNRMAIN',
2081: itemkey => p_eventkey,
2082: aname => 'UI_ACTION_USER_ID',
2083: avalue => FND_GLOBAL.USER_ID);
2084:
2085:
2086: --get process/activity name
2087: SELECT WPA.ACTIVITY_NAME

Line 2110: l_approver_record.name := FND_GLOBAL.USER_NAME;

2106: p_trx_id => p_trx_id,
2107: p_update_status_to => 'REJECTED');
2108:
2109: -- Update the AME System with the 'APPROVED' status.
2110: l_approver_record.name := FND_GLOBAL.USER_NAME;
2111: l_approver_record.approval_status := AME_UTIL.rejectStatus;
2112:
2113: ame_api2.updateApprovalStatus(
2114: applicationIdIn => 435,

Line 2298: FND_GLOBAL.USER_ID,

2294: crec.amount_dr,
2295: crec.amount_cr,
2296: l_ccid,
2297: 'N',
2298: FND_GLOBAL.USER_ID,
2299: sysdate,
2300: FND_GLOBAL.USER_ID,
2301: sysdate,
2302: FND_GLOBAL.LOGIN_ID,

Line 2300: FND_GLOBAL.USER_ID,

2296: l_ccid,
2297: 'N',
2298: FND_GLOBAL.USER_ID,
2299: sysdate,
2300: FND_GLOBAL.USER_ID,
2301: sysdate,
2302: FND_GLOBAL.LOGIN_ID,
2303: l_trx_id);
2304:

Line 2302: FND_GLOBAL.LOGIN_ID,

2298: FND_GLOBAL.USER_ID,
2299: sysdate,
2300: FND_GLOBAL.USER_ID,
2301: sysdate,
2302: FND_GLOBAL.LOGIN_ID,
2303: l_trx_id);
2304:
2305: END LOOP;
2306:

Line 3182: , FND_GLOBAL.USER_ID

3178: , 'R'
3179: , SYSDATE
3180: , NULL
3181: , 1
3182: , FND_GLOBAL.USER_ID
3183: , SYSDATE
3184: , FND_GLOBAL.USER_ID
3185: , SYSDATE
3186: , fnd_global.login_id

Line 3184: , FND_GLOBAL.USER_ID

3180: , NULL
3181: , 1
3182: , FND_GLOBAL.USER_ID
3183: , SYSDATE
3184: , FND_GLOBAL.USER_ID
3185: , SYSDATE
3186: , fnd_global.login_id
3187: , l_init_bsv
3188: , l_reci_bsv

Line 3186: , fnd_global.login_id

3182: , FND_GLOBAL.USER_ID
3183: , SYSDATE
3184: , FND_GLOBAL.USER_ID
3185: , SYSDATE
3186: , fnd_global.login_id
3187: , l_init_bsv
3188: , l_reci_bsv
3189: );
3190: END IF;

Line 3340: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;

3336: l_new_dist_tbl(l_new_index).amount_dr := l_init_dist_tbl(1).init_amount_dr;
3337: l_new_dist_tbl(l_new_index).ccid := l_ccid;
3338: l_new_dist_tbl(l_new_index).description := l_init_dist_tbl(1).description;
3339: l_new_dist_tbl(l_new_index).auto_generate_flag := 'Y';
3340: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3341: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3342: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3343: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3344: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 3342: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;

3338: l_new_dist_tbl(l_new_index).description := l_init_dist_tbl(1).description;
3339: l_new_dist_tbl(l_new_index).auto_generate_flag := 'Y';
3340: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3341: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3342: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3343: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3344: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;
3345:
3346: l_new_index := l_new_index + 1;

Line 3344: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;

3340: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3341: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3342: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3343: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3344: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;
3345:
3346: l_new_index := l_new_index + 1;
3347:
3348: -- Generate Recipient Distributions

Line 3642: , FND_GLOBAL.USER_ID

3638: , 'P'
3639: , SYSDATE
3640: , NULL
3641: , 1
3642: , FND_GLOBAL.USER_ID
3643: , SYSDATE
3644: , FND_GLOBAL.USER_ID
3645: , SYSDATE
3646: , fnd_global.login_id

Line 3644: , FND_GLOBAL.USER_ID

3640: , NULL
3641: , 1
3642: , FND_GLOBAL.USER_ID
3643: , SYSDATE
3644: , FND_GLOBAL.USER_ID
3645: , SYSDATE
3646: , fnd_global.login_id
3647: , l_reci_bsv
3648: , l_init_bsv

Line 3646: , fnd_global.login_id

3642: , FND_GLOBAL.USER_ID
3643: , SYSDATE
3644: , FND_GLOBAL.USER_ID
3645: , SYSDATE
3646: , fnd_global.login_id
3647: , l_reci_bsv
3648: , l_init_bsv
3649: );
3650: END IF;

Line 3783: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;

3779: l_new_dist_tbl(l_new_index).amount_dr := l_reci_dist_tbl(1).reci_amount_dr;
3780: l_new_dist_tbl(l_new_index).ccid := l_ccid;
3781: l_new_dist_tbl(l_new_index).description := l_reci_dist_tbl(1).description;
3782: l_new_dist_tbl(l_new_index).auto_generate_flag := 'Y';
3783: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3784: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3785: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3786: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3787: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;

Line 3785: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;

3781: l_new_dist_tbl(l_new_index).description := l_reci_dist_tbl(1).description;
3782: l_new_dist_tbl(l_new_index).auto_generate_flag := 'Y';
3783: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3784: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3785: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3786: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3787: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;
3788:
3789: l_new_index := l_new_index + 1;

Line 3787: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;

3783: l_new_dist_tbl(l_new_index).created_by := FND_GLOBAL.USER_ID;
3784: l_new_dist_tbl(l_new_index).creation_date := SYSDATE;
3785: l_new_dist_tbl(l_new_index).last_updated_by := FND_GLOBAL.USER_ID;
3786: l_new_dist_tbl(l_new_index).last_update_date := SYSDATE;
3787: l_new_dist_tbl(l_new_index).last_update_login := FND_GLOBAL.LOGIN_ID;
3788:
3789: l_new_index := l_new_index + 1;
3790:
3791:

Line 4124: -- FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);

4120: l_trx_id := wf_engine.GetItemAttrNumber
4121: (itemtype => itemtype,
4122: itemkey => itemkey,
4123: aname => 'TRX_ID');
4124: -- FND_GLOBAL.APPS_INITIALIZE(l_user_id,l_resp_id,l_appl_id);
4125:
4126: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4127: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'fun.plsql.fun_recipient_wf.generate_acct_lines', 'l_trx_id = ' || l_trx_id);
4128: END IF;

Line 4201: and role.user_name = FND_GLOBAL.USER_NAME;

4197: CURSOR get_user_names IS
4198: select 'X'
4199: from WF_USER_ROLE_ASSIGNMENTS role
4200: where role.role_name = 'FUN_ADHOC_RECI_'||trx_id
4201: and role.user_name = FND_GLOBAL.USER_NAME;
4202: BEGIN
4203: OPEN get_user_names;
4204: FETCH get_user_names INTO c_user_name;
4205: