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.ENG_CHANGE_LIFECYCLE_UTIL dependencies on FND_PROFILE

Line 165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));

161: ----------------------------------------------------------------
162: -- Open the Debug Log Session, p_debug_flag is TRUE or
163: -- if Profile is set to TRUE: INV_DEBUG_TRACE Yes, INV_DEBUG_LEVEL 20
164: ----------------------------------------------------------------
165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
167:
168: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
169: OR FND_API.to_Boolean(p_debug_flag)

Line 166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));

162: -- Open the Debug Log Session, p_debug_flag is TRUE or
163: -- if Profile is set to TRUE: INV_DEBUG_TRACE Yes, INV_DEBUG_LEVEL 20
164: ----------------------------------------------------------------
165: g_profile_debug_option := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), TO_CHAR(0));
166: g_profile_debug_level := NVL(FND_PROFILE.VALUE('INV_DEBUG_LEVEL'), TO_CHAR(0));
167:
168: IF (g_profile_debug_option = '1' AND TO_NUMBER(g_profile_debug_level) >= 20)
169: OR FND_API.to_Boolean(p_debug_flag)
170: THEN

Line 347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

343: ,x_auto_demote_status OUT NOCOPY NUMBER
344: )
345: IS
346:
347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

Line 348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

344: )
345: IS
346:
347: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
348: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
349:
350: l_cm_type_code eng_engineering_changes.CHANGE_MGMT_TYPE_CODE%TYPE;
351: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
352:

Line 381: -- FND_PROFILE package is not available for workflow (WF),

377: Write_Debug('-----------------------------------------------------');
378: Write_Debug('Initializing return status... ' );
379: END IF;
380:
381: -- FND_PROFILE package is not available for workflow (WF),
382: -- therefore manually set WHO column values
383: IF p_api_caller = 'WF' THEN
384: l_fnd_user_id := G_ENG_WF_USER_ID;
385: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

598: l_return_status VARCHAR2(1);
599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601:
602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
604:
605: l_updated BOOLEAN := FALSE ;
606:

Line 603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

599: l_msg_count NUMBER;
600: l_msg_data VARCHAR2(2000);
601:
602: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
603: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
604:
605: l_updated BOOLEAN := FALSE ;
606:
607: l_phase_sn eng_lifecycle_statuses.sequence_number%TYPE;

Line 663: -- FND_PROFILE package is not available for workflow (WF),

659:
660: -- Initialize API return status to success
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662:
663: -- FND_PROFILE package is not available for workflow (WF),
664: -- therefore manually set WHO column values
665: IF p_api_caller = 'WF' THEN
666: l_fnd_user_id := G_ENG_WF_USER_ID;
667: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1267: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1263: l_msg_count NUMBER;
1264: l_msg_data VARCHAR2(2000);
1265:
1266: l_api_caller VARCHAR2(2) := NULL;
1267: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1268: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1269:
1270:
1271: l_change_line_id NUMBER ;

Line 1268: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1264: l_msg_data VARCHAR2(2000);
1265:
1266: l_api_caller VARCHAR2(2) := NULL;
1267: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1268: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1269:
1270:
1271: l_change_line_id NUMBER ;
1272: l_line_wf_route_id NUMBER ;

Line 1350: -- FND_PROFILE package is not available for workflow (WF),

1346:
1347: -- Initialize API return status to success
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350: -- FND_PROFILE package is not available for workflow (WF),
1351: -- therefore manually set WHO column values
1352: IF p_api_caller = 'WF' THEN
1353: l_fnd_user_id := G_ENG_WF_USER_ID;
1354: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1535: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1531: l_msg_count NUMBER;
1532: l_msg_data VARCHAR2(2000);
1533:
1534: l_api_caller VARCHAR2(2) := NULL;
1535: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1536: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1537:
1538: l_action_id eng_change_actions.action_id%TYPE;
1539:

Line 1536: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1532: l_msg_data VARCHAR2(2000);
1533:
1534: l_api_caller VARCHAR2(2) := NULL;
1535: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1536: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1537:
1538: l_action_id eng_change_actions.action_id%TYPE;
1539:
1540: l_wf_route_id eng_lifecycle_statuses.change_wf_route_id%TYPE;

Line 1588: -- FND_PROFILE package is not available for workflow (WF),

1584:
1585: -- Initialize API return status to success
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:
1588: -- FND_PROFILE package is not available for workflow (WF),
1589: -- therefore manually set WHO column values
1590: IF p_api_caller = 'WF' THEN
1591: l_fnd_user_id := G_ENG_WF_USER_ID;
1592: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 1949: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1945: IS
1946: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Header';
1947: l_api_version CONSTANT NUMBER := 1.0;
1948:
1949: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1950: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1951:
1952: l_is_imp_phase_used VARCHAR2(1) := 'F';
1953:

Line 1950: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1946: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Header';
1947: l_api_version CONSTANT NUMBER := 1.0;
1948:
1949: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1950: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1951:
1952: l_is_imp_phase_used VARCHAR2(1) := 'F';
1953:
1954: l_last_status_type NUMBER;

Line 2117: -- FND_PROFILE package is not available for workflow (WF),

2113:
2114: -- Initialize API return status to success
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116:
2117: -- FND_PROFILE package is not available for workflow (WF),
2118: -- therefore manually set WHO column values
2119: IF p_api_caller = 'WF' THEN
2120: l_fnd_user_id := G_ENG_WF_USER_ID;
2121: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 3047: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3043: IS
3044: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Header';
3045: l_api_version CONSTANT NUMBER := 1.0;
3046:
3047: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3048: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3049:
3050: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
3051:

Line 3048: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

3044: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Header';
3045: l_api_version CONSTANT NUMBER := 1.0;
3046:
3047: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3048: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3049:
3050: l_curr_appr_status eng_engineering_changes.approval_status_type%TYPE;
3051:
3052: l_is_imp_phase_used VARCHAR2(1) := 'F';

Line 3158: -- FND_PROFILE package is not available for workflow (WF),

3154:
3155: -- Initialize API return status to success
3156: x_return_status := FND_API.G_RET_STS_SUCCESS;
3157:
3158: -- FND_PROFILE package is not available for workflow (WF),
3159: -- therefore manually set WHO column values
3160: IF p_api_caller = 'WF' THEN
3161: l_fnd_user_id := G_ENG_WF_USER_ID;
3162: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 3778: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

3774: IS
3775: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Revised_Item';
3776: l_api_version CONSTANT NUMBER := 1.0;
3777:
3778: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3779: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3780:
3781: l_return_status VARCHAR2(1);
3782: l_msg_count NUMBER;

Line 3779: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

3775: l_api_name CONSTANT VARCHAR2(30) := 'Promote_Revised_Item';
3776: l_api_version CONSTANT NUMBER := 1.0;
3777:
3778: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3779: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
3780:
3781: l_return_status VARCHAR2(1);
3782: l_msg_count NUMBER;
3783: l_msg_data VARCHAR2(2000);

Line 3839: -- FND_PROFILE package is not available for workflow (WF),

3835:
3836: -- Initialize API return status to success
3837: x_return_status := FND_API.G_RET_STS_SUCCESS;
3838:
3839: -- FND_PROFILE package is not available for workflow (WF),
3840: -- therefore manually set WHO column values
3841: IF p_api_caller = 'WF' THEN
3842: l_fnd_user_id := G_ENG_WF_USER_ID;
3843: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 4154: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

4150: IS
4151: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Revised_Item';
4152: l_api_version CONSTANT NUMBER := 1.0;
4153:
4154: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4155: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4156:
4157: l_api_caller VARCHAR2(2) := NULL;
4158:

Line 4155: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

4151: l_api_name CONSTANT VARCHAR2(30) := 'Demote_Revised_Item';
4152: l_api_version CONSTANT NUMBER := 1.0;
4153:
4154: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4155: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4156:
4157: l_api_caller VARCHAR2(2) := NULL;
4158:
4159: l_return_status VARCHAR2(1);

Line 4213: -- FND_PROFILE package is not available for workflow (WF),

4209:
4210: -- Initialize API return status to success
4211: x_return_status := FND_API.G_RET_STS_SUCCESS;
4212:
4213: -- FND_PROFILE package is not available for workflow (WF),
4214: -- therefore manually set WHO column values
4215: IF p_api_caller = 'WF' THEN
4216: l_fnd_user_id := G_ENG_WF_USER_ID;
4217: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 4844: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

4840: l_return_status VARCHAR2(1);
4841: l_msg_count NUMBER;
4842: l_msg_data VARCHAR2(2000);
4843:
4844: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4845: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4846:
4847: l_api_caller VARCHAR2(2) := NULL;
4848:

Line 4845: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

4841: l_msg_count NUMBER;
4842: l_msg_data VARCHAR2(2000);
4843:
4844: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
4845: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
4846:
4847: l_api_caller VARCHAR2(2) := NULL;
4848:
4849: l_action_id eng_change_actions.action_id%TYPE;

Line 4933: -- FND_PROFILE package is not available for workflow (WF),

4929:
4930: -- Initialize API return status to success
4931: x_return_status := FND_API.G_RET_STS_SUCCESS;
4932:
4933: -- FND_PROFILE package is not available for workflow (WF),
4934: -- therefore manually set WHO column values
4935: IF p_api_caller = 'WF' THEN
4936: l_fnd_user_id := G_ENG_WF_USER_ID;
4937: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 6274: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

6270: l_return_status VARCHAR2(1);
6271: l_msg_count NUMBER;
6272: l_msg_data VARCHAR2(2000);
6273:
6274: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6275: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6276:
6277: CURSOR c_currPhase IS
6278: SELECT *

Line 6275: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

6271: l_msg_count NUMBER;
6272: l_msg_data VARCHAR2(2000);
6273:
6274: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6275: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6276:
6277: CURSOR c_currPhase IS
6278: SELECT *
6279: FROM eng_lifecycle_statuses

Line 6335: -- FND_PROFILE package is not available for workflow (WF),

6331:
6332: -- Initialize API return status to success
6333: x_return_status := FND_API.G_RET_STS_SUCCESS;
6334:
6335: -- FND_PROFILE package is not available for workflow (WF),
6336: -- therefore manually set WHO column values
6337: IF p_api_caller = 'WF' THEN
6338: l_fnd_user_id := G_ENG_WF_USER_ID;
6339: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 6516: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

6512: l_return_status VARCHAR2(1);
6513: l_msg_count NUMBER;
6514: l_msg_data VARCHAR2(2000);
6515:
6516: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6517: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6518:
6519: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6520: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;

Line 6517: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

6513: l_msg_count NUMBER;
6514: l_msg_data VARCHAR2(2000);
6515:
6516: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
6517: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
6518:
6519: l_cm_type_code eng_engineering_changes.change_mgmt_type_code%TYPE;
6520: l_base_cm_type_code eng_change_order_types.BASE_CHANGE_MGMT_TYPE_CODE%TYPE;
6521: l_bug_number NUMBER := 0;

Line 6601: -- FND_PROFILE package is not available for workflow (WF),

6597:
6598: -- Initialize API return status to success
6599: x_return_status := FND_API.G_RET_STS_SUCCESS;
6600:
6601: -- FND_PROFILE package is not available for workflow (WF),
6602: -- therefore manually set WHO column values
6603: IF p_api_caller = 'WF' THEN
6604: l_fnd_user_id := G_ENG_WF_USER_ID;
6605: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7104: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7100: l_return_status VARCHAR2(1);
7101: l_msg_count NUMBER;
7102: l_msg_data VARCHAR2(2000);
7103:
7104: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7105: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7106:
7107: BEGIN
7108: -- Standard Start of API savepoint

Line 7105: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7101: l_msg_count NUMBER;
7102: l_msg_data VARCHAR2(2000);
7103:
7104: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7105: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7106:
7107: BEGIN
7108: -- Standard Start of API savepoint
7109: --SAVEPOINT Update_RevItem_Lifecycle;

Line 7144: -- FND_PROFILE package is not available for workflow (WF),

7140:
7141: -- Initialize API return status to success
7142: x_return_status := FND_API.G_RET_STS_SUCCESS;
7143:
7144: -- FND_PROFILE package is not available for workflow (WF),
7145: -- therefore manually set WHO column values
7146: IF p_api_caller = 'WF' THEN
7147: l_fnd_user_id := G_ENG_WF_USER_ID;
7148: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7254: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7250:
7251: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Phase';
7252: l_api_version CONSTANT NUMBER := 1.0;
7253:
7254: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7255: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7256:
7257: l_return_status VARCHAR2(1);
7258: l_msg_count NUMBER;

Line 7255: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7251: l_api_name CONSTANT VARCHAR2(30) := 'Reset_Phase';
7252: l_api_version CONSTANT NUMBER := 1.0;
7253:
7254: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7255: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7256:
7257: l_return_status VARCHAR2(1);
7258: l_msg_count NUMBER;
7259: l_msg_data VARCHAR2(2000);

Line 7329: -- FND_PROFILE package is not available for workflow (WF),

7325:
7326: -- Initialize API return status to success
7327: x_return_status := FND_API.G_RET_STS_SUCCESS;
7328:
7329: -- FND_PROFILE package is not available for workflow (WF),
7330: -- therefore manually set WHO column values
7331: IF p_api_caller = 'WF' THEN
7332: l_fnd_user_id := G_ENG_WF_USER_ID;
7333: l_fnd_login_id := G_ENG_WF_LOGIN_ID;

Line 7699: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

7695:
7696: l_api_name CONSTANT VARCHAR2(30) := 'Sync_LC_Phase_Setup';
7697: l_api_version CONSTANT NUMBER := 1.0;
7698:
7699: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7700: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7701:
7702: l_return_status VARCHAR2(1);
7703: l_msg_count NUMBER;

Line 7700: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

7696: l_api_name CONSTANT VARCHAR2(30) := 'Sync_LC_Phase_Setup';
7697: l_api_version CONSTANT NUMBER := 1.0;
7698:
7699: l_fnd_user_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
7700: l_fnd_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
7701:
7702: l_return_status VARCHAR2(1);
7703: l_msg_count NUMBER;
7704: l_msg_data VARCHAR2(2000);

Line 7762: -- FND_PROFILE package is not available for workflow (WF),

7758:
7759: -- Initialize API return status to success
7760: x_return_status := FND_API.G_RET_STS_SUCCESS;
7761:
7762: -- FND_PROFILE package is not available for workflow (WF),
7763: -- therefore manually set WHO column values
7764: IF p_api_caller = 'WF' THEN
7765: l_fnd_user_id := G_ENG_WF_USER_ID;
7766: l_fnd_login_id := G_ENG_WF_LOGIN_ID;