DBA Data[Home] [Help]

APPS.PA_PROJECT_ASSETS_PUB dependencies on FND_GLOBAL

Line 9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJECT_ASSETS_PUB';
6: G_ASSET_CODE CONSTANT VARCHAR2(5) := 'ASSET';
7:
8: --Global constants to be used in inserts and updates
9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
10: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
11:
12:
13:

Line 10: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;

6: G_ASSET_CODE CONSTANT VARCHAR2(5) := 'ASSET';
7:
8: --Global constants to be used in inserts and updates
9: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
10: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
11:
12:
13:
14:

Line 381: l_resp_id := FND_GLOBAL.Resp_id;

377: END IF;
378:
379:
380: --Initialize variables
381: l_resp_id := FND_GLOBAL.Resp_id;
382: l_user_id := FND_GLOBAL.User_id;
383: l_module_name := 'PA_PM_ADD_PROJECT_ASSET';
384:
385:

Line 382: l_user_id := FND_GLOBAL.User_id;

378:
379:
380: --Initialize variables
381: l_resp_id := FND_GLOBAL.Resp_id;
382: l_user_id := FND_GLOBAL.User_id;
383: l_module_name := 'PA_PM_ADD_PROJECT_ASSET';
384:
385:
386:

Line 1750: FND_GLOBAL.user_id, --last_updated_by

1746: 'N', --reverse_flag
1747: 'N', --capital_hold_flag
1748: l_asset_in_rec.estimated_in_service_date,
1749: SYSDATE, --last_update_date
1750: FND_GLOBAL.user_id, --last_updated_by
1751: FND_GLOBAL.user_id, --created_by
1752: SYSDATE, --creation_date
1753: FND_GLOBAL.login_id, --last_update_login
1754: l_asset_in_rec.attribute_category,

Line 1751: FND_GLOBAL.user_id, --created_by

1747: 'N', --capital_hold_flag
1748: l_asset_in_rec.estimated_in_service_date,
1749: SYSDATE, --last_update_date
1750: FND_GLOBAL.user_id, --last_updated_by
1751: FND_GLOBAL.user_id, --created_by
1752: SYSDATE, --creation_date
1753: FND_GLOBAL.login_id, --last_update_login
1754: l_asset_in_rec.attribute_category,
1755: l_asset_in_rec.attribute1,

Line 1753: FND_GLOBAL.login_id, --last_update_login

1749: SYSDATE, --last_update_date
1750: FND_GLOBAL.user_id, --last_updated_by
1751: FND_GLOBAL.user_id, --created_by
1752: SYSDATE, --creation_date
1753: FND_GLOBAL.login_id, --last_update_login
1754: l_asset_in_rec.attribute_category,
1755: l_asset_in_rec.attribute1,
1756: l_asset_in_rec.attribute2,
1757: l_asset_in_rec.attribute3,

Line 2115: l_resp_id := FND_GLOBAL.Resp_id;

2111: END IF;
2112:
2113:
2114: --Initialize variables
2115: l_resp_id := FND_GLOBAL.Resp_id;
2116: l_user_id := FND_GLOBAL.User_id;
2117: l_module_name := 'PA_PM_ADD_ASSET_ASSIGNMENT';
2118:
2119:

Line 2116: l_user_id := FND_GLOBAL.User_id;

2112:
2113:
2114: --Initialize variables
2115: l_resp_id := FND_GLOBAL.Resp_id;
2116: l_user_id := FND_GLOBAL.User_id;
2117: l_module_name := 'PA_PM_ADD_ASSET_ASSIGNMENT';
2118:
2119:
2120:

Line 2700: FND_GLOBAL.user_id, --last_updated_by

2696: (l_project_asset_id,
2697: l_task_id,
2698: l_project_id,
2699: SYSDATE, --last_update_date
2700: FND_GLOBAL.user_id, --last_updated_by
2701: SYSDATE, --creation_date
2702: FND_GLOBAL.user_id, --created_by
2703: FND_GLOBAL.login_id, --last_update_login
2704: l_attribute_category,

Line 2702: FND_GLOBAL.user_id, --created_by

2698: l_project_id,
2699: SYSDATE, --last_update_date
2700: FND_GLOBAL.user_id, --last_updated_by
2701: SYSDATE, --creation_date
2702: FND_GLOBAL.user_id, --created_by
2703: FND_GLOBAL.login_id, --last_update_login
2704: l_attribute_category,
2705: l_attribute1,
2706: l_attribute2,

Line 2703: FND_GLOBAL.login_id, --last_update_login

2699: SYSDATE, --last_update_date
2700: FND_GLOBAL.user_id, --last_updated_by
2701: SYSDATE, --creation_date
2702: FND_GLOBAL.user_id, --created_by
2703: FND_GLOBAL.login_id, --last_update_login
2704: l_attribute_category,
2705: l_attribute1,
2706: l_attribute2,
2707: l_attribute3,

Line 3226: l_resp_id := FND_GLOBAL.Resp_id;

3222: END IF;
3223:
3224:
3225: --Initialize variables
3226: l_resp_id := FND_GLOBAL.Resp_id;
3227: l_user_id := FND_GLOBAL.User_id;
3228: l_module_name := 'PA_PM_UPDATE_PROJECT_ASSET';
3229:
3230:

Line 3227: l_user_id := FND_GLOBAL.User_id;

3223:
3224:
3225: --Initialize variables
3226: l_resp_id := FND_GLOBAL.Resp_id;
3227: l_user_id := FND_GLOBAL.User_id;
3228: l_module_name := 'PA_PM_UPDATE_PROJECT_ASSET';
3229:
3230:
3231: --Get Project ID from Project Reference

Line 5285: ' LAST_UPDATED_BY = '||FND_GLOBAL.USER_ID||',';

5281: l_statement := l_statement ||
5282: ' LAST_UPDATE_DATE = SYSDATE'||',';
5283:
5284: l_statement := l_statement ||
5285: ' LAST_UPDATED_BY = '||FND_GLOBAL.USER_ID||',';
5286:
5287: l_statement := l_statement ||
5288: ' LAST_UPDATE_LOGIN = '||FND_GLOBAL.LOGIN_ID;
5289:

Line 5288: ' LAST_UPDATE_LOGIN = '||FND_GLOBAL.LOGIN_ID;

5284: l_statement := l_statement ||
5285: ' LAST_UPDATED_BY = '||FND_GLOBAL.USER_ID||',';
5286:
5287: l_statement := l_statement ||
5288: ' LAST_UPDATE_LOGIN = '||FND_GLOBAL.LOGIN_ID;
5289:
5290: l_statement := l_statement ||
5291: ' WHERE PROJECT_ASSET_ID = '|| TO_CHAR(l_project_asset_id);
5292:

Line 6801: l_resp_id := FND_GLOBAL.Resp_id;

6797: END IF;
6798:
6799:
6800: --Initialize variables
6801: l_resp_id := FND_GLOBAL.Resp_id;
6802: l_user_id := FND_GLOBAL.User_id;
6803: l_module_name := 'PA_PM_DELETE_PROJECT_ASSET';
6804:
6805:

Line 6802: l_user_id := FND_GLOBAL.User_id;

6798:
6799:
6800: --Initialize variables
6801: l_resp_id := FND_GLOBAL.Resp_id;
6802: l_user_id := FND_GLOBAL.User_id;
6803: l_module_name := 'PA_PM_DELETE_PROJECT_ASSET';
6804:
6805:
6806:

Line 7209: l_resp_id := FND_GLOBAL.Resp_id;

7205: END IF;
7206:
7207:
7208: --Initialize variables
7209: l_resp_id := FND_GLOBAL.Resp_id;
7210: l_user_id := FND_GLOBAL.User_id;
7211: l_module_name := 'PA_PM_DELETE_ASSET_ASSIGNMENT';
7212:
7213:

Line 7210: l_user_id := FND_GLOBAL.User_id;

7206:
7207:
7208: --Initialize variables
7209: l_resp_id := FND_GLOBAL.Resp_id;
7210: l_user_id := FND_GLOBAL.User_id;
7211: l_module_name := 'PA_PM_DELETE_ASSET_ASSIGNMENT';
7212:
7213:
7214: