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

Line 1452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

1448: x_loading_status OUT NOCOPY VARCHAR2
1449: ) RETURN VARCHAR2 IS
1450:
1451: G_LAST_UPDATE_DATE DATE := sysdate;
1452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1453: G_CREATION_DATE DATE := sysdate;
1454: G_CREATED_BY NUMBER := fnd_global.user_id;
1455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1456:

Line 1454: G_CREATED_BY NUMBER := fnd_global.user_id;

1450:
1451: G_LAST_UPDATE_DATE DATE := sysdate;
1452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1453: G_CREATION_DATE DATE := sysdate;
1454: G_CREATED_BY NUMBER := fnd_global.user_id;
1455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1456:
1457: l_api_name CONSTANT VARCHAR2(30) := 'populate_ap_interface';
1458: --for Performance issues SQL ID 16120772 we had to break this sql

Line 1455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

1451: G_LAST_UPDATE_DATE DATE := sysdate;
1452: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1453: G_CREATION_DATE DATE := sysdate;
1454: G_CREATED_BY NUMBER := fnd_global.user_id;
1455: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1456:
1457: l_api_name CONSTANT VARCHAR2(30) := 'populate_ap_interface';
1458: --for Performance issues SQL ID 16120772 we had to break this sql
1459: /*

Line 1738: WHERE user_id = fnd_global.user_id;

1734:
1735: SELECT user_name
1736: INTO l_user
1737: FROM fnd_user
1738: WHERE user_id = fnd_global.user_id;
1739:
1740: -- Fetch all the salesrep (who are vendors) who are eligible to be paid
1741: FOR vendor IN get_vendors
1742: LOOP

Line 1807: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

1803: l_api_name CONSTANT VARCHAR2(30) := 'Create_Payrun';
1804: l_api_version CONSTANT NUMBER := 1.0;
1805:
1806: G_LAST_UPDATE_DATE DATE := sysdate;
1807: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1808: G_CREATION_DATE DATE := sysdate;
1809: G_CREATED_BY NUMBER := fnd_global.user_id;
1810: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1811: g_credit_type_id CONSTANT NUMBER := -1000;

Line 1809: G_CREATED_BY NUMBER := fnd_global.user_id;

1805:
1806: G_LAST_UPDATE_DATE DATE := sysdate;
1807: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1808: G_CREATION_DATE DATE := sysdate;
1809: G_CREATED_BY NUMBER := fnd_global.user_id;
1810: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1811: g_credit_type_id CONSTANT NUMBER := -1000;
1812:
1813: l_has_access BOOLEAN;

Line 1810: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

1806: G_LAST_UPDATE_DATE DATE := sysdate;
1807: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
1808: G_CREATION_DATE DATE := sysdate;
1809: G_CREATED_BY NUMBER := fnd_global.user_id;
1810: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
1811: g_credit_type_id CONSTANT NUMBER := -1000;
1812:
1813: l_has_access BOOLEAN;
1814: l_note_msg VARCHAR2(240);

Line 2141: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

2137: l_api_name CONSTANT VARCHAR2(30) := 'Update_Payrun';
2138: l_api_version CONSTANT NUMBER := 1.0;
2139:
2140: G_LAST_UPDATE_DATE DATE := sysdate;
2141: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2142: G_CREATION_DATE DATE := sysdate;
2143: G_CREATED_BY NUMBER := fnd_global.user_id;
2144: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2145:

Line 2143: G_CREATED_BY NUMBER := fnd_global.user_id;

2139:
2140: G_LAST_UPDATE_DATE DATE := sysdate;
2141: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2142: G_CREATION_DATE DATE := sysdate;
2143: G_CREATED_BY NUMBER := fnd_global.user_id;
2144: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2145:
2146: l_status cn_payruns.status%TYPE;
2147: l_status_meaning cn_payruns.status%TYPE;

Line 2144: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

2140: G_LAST_UPDATE_DATE DATE := sysdate;
2141: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2142: G_CREATION_DATE DATE := sysdate;
2143: G_CREATED_BY NUMBER := fnd_global.user_id;
2144: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2145:
2146: l_status cn_payruns.status%TYPE;
2147: l_status_meaning cn_payruns.status%TYPE;
2148: l_payrun_id NUMBER;

Line 2407: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

2403: WHERE payrun_id = p_payrun_id
2404: AND quota_id = null;
2405:
2406: G_LAST_UPDATE_DATE DATE := sysdate;
2407: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2408: G_CREATION_DATE DATE := sysdate;
2409: G_CREATED_BY NUMBER := fnd_global.user_id;
2410: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2411: g_credit_type_id CONSTANT NUMBER := -1000;

Line 2409: G_CREATED_BY NUMBER := fnd_global.user_id;

2405:
2406: G_LAST_UPDATE_DATE DATE := sysdate;
2407: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2408: G_CREATION_DATE DATE := sysdate;
2409: G_CREATED_BY NUMBER := fnd_global.user_id;
2410: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2411: g_credit_type_id CONSTANT NUMBER := -1000;
2412:
2413: l_has_access BOOLEAN;

Line 2410: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

2406: G_LAST_UPDATE_DATE DATE := sysdate;
2407: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2408: G_CREATION_DATE DATE := sysdate;
2409: G_CREATED_BY NUMBER := fnd_global.user_id;
2410: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2411: g_credit_type_id CONSTANT NUMBER := -1000;
2412:
2413: l_has_access BOOLEAN;
2414: l_note_msg VARCHAR2(240);

Line 2969: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;

2965: --R12
2966: AND org_id = p_org_id;
2967:
2968: G_LAST_UPDATE_DATE DATE := sysdate;
2969: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2970: G_CREATION_DATE DATE := sysdate;
2971: G_CREATED_BY NUMBER := fnd_global.user_id;
2972: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2973:

Line 2971: G_CREATED_BY NUMBER := fnd_global.user_id;

2967:
2968: G_LAST_UPDATE_DATE DATE := sysdate;
2969: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2970: G_CREATION_DATE DATE := sysdate;
2971: G_CREATED_BY NUMBER := fnd_global.user_id;
2972: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2973:
2974: l_has_access BOOLEAN;
2975:

Line 2972: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;

2968: G_LAST_UPDATE_DATE DATE := sysdate;
2969: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
2970: G_CREATION_DATE DATE := sysdate;
2971: G_CREATED_BY NUMBER := fnd_global.user_id;
2972: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
2973:
2974: l_has_access BOOLEAN;
2975:
2976: BEGIN

Line 3107: l_batch_rec.created_by := fnd_global.user_id;

3103: p_payrun_id ||'-'||
3104: l_posting_batch_id;
3105:
3106: -- shouldn't need to pass who columns to TH but pass them for now
3107: l_batch_rec.created_by := fnd_global.user_id;
3108: l_batch_rec.creation_date := sysdate;
3109: l_batch_rec.last_updated_by := fnd_global.user_id;
3110: l_batch_rec.last_update_date := sysdate;
3111: l_batch_rec.last_update_login:= fnd_global.login_id;

Line 3109: l_batch_rec.last_updated_by := fnd_global.user_id;

3105:
3106: -- shouldn't need to pass who columns to TH but pass them for now
3107: l_batch_rec.created_by := fnd_global.user_id;
3108: l_batch_rec.creation_date := sysdate;
3109: l_batch_rec.last_updated_by := fnd_global.user_id;
3110: l_batch_rec.last_update_date := sysdate;
3111: l_batch_rec.last_update_login:= fnd_global.login_id;
3112:
3113: -- call table handler

Line 3111: l_batch_rec.last_update_login:= fnd_global.login_id;

3107: l_batch_rec.created_by := fnd_global.user_id;
3108: l_batch_rec.creation_date := sysdate;
3109: l_batch_rec.last_updated_by := fnd_global.user_id;
3110: l_batch_rec.last_update_date := sysdate;
3111: l_batch_rec.last_update_login:= fnd_global.login_id;
3112:
3113: -- call table handler
3114: --cn_prepostbatches.insert_record(l_batch_rec);
3115: -- use old API