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

Line 477: FND_GLOBAL.user_id,

473: arc_source_code_for
474: ) VALUES (
475: ams_source_codes_gen_s.NEXTVAL,
476: SYSDATE,
477: FND_GLOBAL.user_id,
478: SYSDATE,
479: FND_GLObAL.user_id,
480: FND_GLOBAL.conc_login_id,
481: 1, -- object version number

Line 479: FND_GLObAL.user_id,

475: ams_source_codes_gen_s.NEXTVAL,
476: SYSDATE,
477: FND_GLOBAL.user_id,
478: SYSDATE,
479: FND_GLObAL.user_id,
480: FND_GLOBAL.conc_login_id,
481: 1, -- object version number
482: p_campaign_source_code,
483: 0,

Line 480: FND_GLOBAL.conc_login_id,

476: SYSDATE,
477: FND_GLOBAL.user_id,
478: SYSDATE,
479: FND_GLObAL.user_id,
480: FND_GLOBAL.conc_login_id,
481: 1, -- object version number
482: p_campaign_source_code,
483: 0,
484: 'NONE' -- Not generated for any specific object

Line 1233: WHERE user_id = FND_GLOBAL.user_id ;

1229: IS
1230: CURSOR c_resource IS
1231: SELECT resource_id
1232: FROM ams_jtf_rs_emp_v
1233: WHERE user_id = FND_GLOBAL.user_id ;
1234:
1235: CURSOR c_schedule IS
1236: SELECT *
1237: FROM ams_campaign_schedules_vl

Line 2297: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

2293: p_activity_id => p_schedule_id,
2294: p_activity_type => 'CSCH',
2295: p_approval_type => 'BUDGET',
2296: p_act_budget_id => null,
2297: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2298: x_must_preview => l_start_wf_process,
2299: x_return_status => l_return_status);
2300:
2301: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2327: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

2323: p_object_version_number => l_object_version,
2324: p_orig_stat_id => l_old_status_id,
2325: p_new_stat_id => p_user_status_id,
2326: p_reject_stat_id => l_deny_status_id,
2327: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2328: p_workflowprocess => 'AMS_APPROVAL',
2329: p_item_type => 'AMSAPRV'
2330: );
2331: ELSE -- If user equals approver and budget approval reqd

Line 2828: -- p_resp_id => l_resp_id, -- fnd global

2824: p_api_version => 1.0,
2825: p_init_msg_list => FND_API.g_false,
2826: p_commit => FND_API.g_false,
2827: -- p_resp_appl_id => l_resp_appl_id, -- 530
2828: -- p_resp_id => l_resp_id, -- fnd global
2829: p_user_id => l_user_id,
2830: -- p_login_id => l_login_id,
2831: x_return_status => l_return_status,
2832: x_msg_count => l_msg_count,

Line 2977: l_user_id := FND_GLOBAL.USER_ID;

2973: WHERE user_status_id = p_user_status_id;
2974:
2975: BEGIN
2976:
2977: l_user_id := FND_GLOBAL.USER_ID;
2978: l_resp_id := FND_GLOBAL.RESP_ID;
2979: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2980:
2981: -- soagrawa on 19-mar-2002

Line 2978: l_resp_id := FND_GLOBAL.RESP_ID;

2974:
2975: BEGIN
2976:
2977: l_user_id := FND_GLOBAL.USER_ID;
2978: l_resp_id := FND_GLOBAL.RESP_ID;
2979: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2980:
2981: -- soagrawa on 19-mar-2002
2982: -- moved the cursor data retrieval from after update to before update

Line 2979: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

2975: BEGIN
2976:
2977: l_user_id := FND_GLOBAL.USER_ID;
2978: l_resp_id := FND_GLOBAL.RESP_ID;
2979: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2980:
2981: -- soagrawa on 19-mar-2002
2982: -- moved the cursor data retrieval from after update to before update
2983: OPEN c_sch_det;

Line 3086: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);

3082:
3083: END IF;
3084:
3085:
3086: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
3087: --insert_log_mesg('Anirban passing value of l_RESOURCE_id in WF, in amsvsbrb.pls as :'||l_RESOURCE_id);
3088: wf_event.AddParameterToList(p_name => 'ASN_RESOURCE_ID',
3089: p_value => l_RESOURCE_id,
3090: p_parameterlist => l_parameter_list);

Line 3407: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);

3403: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,
3404: p_encoded => FND_API.G_FALSE,
3405: p_data => l_msg_data,
3406: p_msg_index_out => l_msg_index ) ;
3407: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);
3408: l_cnt := l_cnt + 1 ;
3409:
3410: END LOOP ;
3411:

Line 3470: l_user_id := FND_GLOBAL.USER_ID;

3466: itemtype => itemtype,
3467: itemkey => itemkey ,
3468: aname => 'SCHEDULE_ID');
3469:
3470: l_user_id := FND_GLOBAL.USER_ID;
3471: l_resp_id := FND_GLOBAL.RESP_ID;
3472: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3473:
3474: AMS_Utility_PVT.Create_Log (

Line 3471: l_resp_id := FND_GLOBAL.RESP_ID;

3467: itemkey => itemkey ,
3468: aname => 'SCHEDULE_ID');
3469:
3470: l_user_id := FND_GLOBAL.USER_ID;
3471: l_resp_id := FND_GLOBAL.RESP_ID;
3472: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3473:
3474: AMS_Utility_PVT.Create_Log (
3475: x_return_status => l_return_status,

Line 3472: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

3468: aname => 'SCHEDULE_ID');
3469:
3470: l_user_id := FND_GLOBAL.USER_ID;
3471: l_resp_id := FND_GLOBAL.RESP_ID;
3472: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3473:
3474: AMS_Utility_PVT.Create_Log (
3475: x_return_status => l_return_status,
3476: p_arc_log_used_by => 'CSCH',

Line 3608: l_user_id := FND_GLOBAL.USER_ID;

3604: ELSIF (p_funcmode = 'TEST_CTX') THEN
3605: -- Code that compares current session context
3606: -- with the work item context required to execute
3607: -- the workflow safely
3608: l_user_id := FND_GLOBAL.USER_ID;
3609: l_resp_id := FND_GLOBAL.RESP_ID;
3610: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3611:
3612: l_schedule_id := WF_ENGINE.GetItemAttrText(

Line 3609: l_resp_id := FND_GLOBAL.RESP_ID;

3605: -- Code that compares current session context
3606: -- with the work item context required to execute
3607: -- the workflow safely
3608: l_user_id := FND_GLOBAL.USER_ID;
3609: l_resp_id := FND_GLOBAL.RESP_ID;
3610: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3611:
3612: l_schedule_id := WF_ENGINE.GetItemAttrText(
3613: itemtype => p_itemtype,

Line 3610: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

3606: -- with the work item context required to execute
3607: -- the workflow safely
3608: l_user_id := FND_GLOBAL.USER_ID;
3609: l_resp_id := FND_GLOBAL.RESP_ID;
3610: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3611:
3612: l_schedule_id := WF_ENGINE.GetItemAttrText(
3613: itemtype => p_itemtype,
3614: itemkey => p_itemkey ,

Line 3649: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

3645: p_msg_type => 'DEBUG'
3646: );
3647:
3648: -- Set the database session context
3649: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3650: p_result := 'COMPLETE:FALSE';
3651: else
3652: p_result := 'COMPLETE:TRUE';
3653: end if;

Line 3676: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);

3672:
3673: l_resp_appl_id := 530;
3674:
3675: -- Set the database session context which also sets the org
3676: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3677: AMS_Utility_PVT.Create_Log (
3678: x_return_status => l_return_status,
3679: p_arc_log_used_by => 'CSCH',
3680: p_log_used_by_id => l_schedule_id,

Line 3746: last_updated_by = FND_GLOBAL.user_id

3742: UPDATE ams_campaign_schedules_b
3743: SET last_activation_date = SYSDATE,
3744: object_version_number = object_version_number + 1,
3745: last_update_date = SYSDATE,
3746: last_updated_by = FND_GLOBAL.user_id
3747: WHERE schedule_id = l_schedule_id ;
3748:
3749: IF l_schedule_status = 'ACTIVE' THEN
3750: result := 'COMPLETE:ACTIVE' ;

Line 3839: last_updated_by = FND_GLOBAL.user_id

3835: status_date = SYSDATE,
3836: last_activation_date = SYSDATE,
3837: object_version_number = object_version_number + 1,
3838: last_update_date = SYSDATE,
3839: last_updated_by = FND_GLOBAL.user_id
3840: WHERE schedule_id = l_schedule_id ;
3841:
3842: -- call to api to raise business event, as per enh # 3805347
3843: RAISE_BE_ON_STATUS_CHANGE(p_obj_id => l_schedule_id,

Line 4362: l_user_id := FND_GLOBAL.USER_ID;

4358: itemtype => itemtype,
4359: itemkey => itemkey ,
4360: aname => 'SCHEDULE_ID' );
4361:
4362: l_user_id := FND_GLOBAL.USER_ID;
4363: l_resp_id := FND_GLOBAL.RESP_ID;
4364: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4365:
4366: AMS_Utility_PVT.Create_Log (

Line 4363: l_resp_id := FND_GLOBAL.RESP_ID;

4359: itemkey => itemkey ,
4360: aname => 'SCHEDULE_ID' );
4361:
4362: l_user_id := FND_GLOBAL.USER_ID;
4363: l_resp_id := FND_GLOBAL.RESP_ID;
4364: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4365:
4366: AMS_Utility_PVT.Create_Log (
4367: x_return_status => l_return_status,

Line 4364: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

4360: aname => 'SCHEDULE_ID' );
4361:
4362: l_user_id := FND_GLOBAL.USER_ID;
4363: l_resp_id := FND_GLOBAL.RESP_ID;
4364: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4365:
4366: AMS_Utility_PVT.Create_Log (
4367: x_return_status => l_return_status,
4368: p_arc_log_used_by => 'CSCH',

Line 4696: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER

4692: VALUES
4693: (
4694: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4695: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4696: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4697: , SYSDATE --CREATION_DATE --NOT NULL DATE
4698: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4699: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4700: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)

Line 4698: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER

4694: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4695: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4696: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4697: , SYSDATE --CREATION_DATE --NOT NULL DATE
4698: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4699: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4700: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)
4701: , SYSDATE --LOAD_DATE --NOT NULL DATE
4702: , l_schedule_details.source_code --PROMOTION_CODE -- VARCHAR2(50)

Line 4699: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER

4695: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4696: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4697: , SYSDATE --CREATION_DATE --NOT NULL DATE
4698: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4699: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4700: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)
4701: , SYSDATE --LOAD_DATE --NOT NULL DATE
4702: , l_schedule_details.source_code --PROMOTION_CODE -- VARCHAR2(50)
4703: , null --STATUS_CODE -- VARCHAR2(30)

Line 4773: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER

4769: (
4770: AS_IMP_LINES_INTERFACE_S.NEXTVAL --IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4771: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4772: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4773: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4774: , SYSDATE --CREATION_DATE --NOT NULL DATE
4775: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4776: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4777: ,l_assoc_product_row.category_id

Line 4775: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER

4771: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4772: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4773: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4774: , SYSDATE --CREATION_DATE --NOT NULL DATE
4775: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4776: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4777: ,l_assoc_product_row.category_id
4778: ,l_assoc_product_row.inventory_item_id
4779: ,l_assoc_product_row.organization_id

Line 4776: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER

4772: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4773: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4774: , SYSDATE --CREATION_DATE --NOT NULL DATE
4775: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4776: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4777: ,l_assoc_product_row.category_id
4778: ,l_assoc_product_row.inventory_item_id
4779: ,l_assoc_product_row.organization_id
4780: ,l_schedule_details.source_code_id