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 2309: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),

2305: p_activity_id => p_schedule_id,
2306: p_activity_type => 'CSCH',
2307: p_approval_type => 'BUDGET',
2308: p_act_budget_id => null,
2309: p_requestor_id => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2310: x_must_preview => l_start_wf_process,
2311: x_return_status => l_return_status);
2312:
2313: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

2335: p_object_version_number => l_object_version,
2336: p_orig_stat_id => l_old_status_id,
2337: p_new_stat_id => p_user_status_id,
2338: p_reject_stat_id => l_deny_status_id,
2339: p_requester_userid => AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id),
2340: p_workflowprocess => 'AMS_APPROVAL',
2341: p_item_type => 'AMSAPRV'
2342: );
2343: ELSE -- If user equals approver and budget approval reqd

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

2836: p_api_version => 1.0,
2837: p_init_msg_list => FND_API.g_false,
2838: p_commit => FND_API.g_false,
2839: -- p_resp_appl_id => l_resp_appl_id, -- 530
2840: -- p_resp_id => l_resp_id, -- fnd global
2841: p_user_id => l_user_id,
2842: -- p_login_id => l_login_id,
2843: x_return_status => l_return_status,
2844: x_msg_count => l_msg_count,

Line 2989: l_user_id := FND_GLOBAL.USER_ID;

2985: WHERE user_status_id = p_user_status_id;
2986:
2987: BEGIN
2988:
2989: l_user_id := FND_GLOBAL.USER_ID;
2990: l_resp_id := FND_GLOBAL.RESP_ID;
2991: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2992:
2993: -- soagrawa on 19-mar-2002

Line 2990: l_resp_id := FND_GLOBAL.RESP_ID;

2986:
2987: BEGIN
2988:
2989: l_user_id := FND_GLOBAL.USER_ID;
2990: l_resp_id := FND_GLOBAL.RESP_ID;
2991: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2992:
2993: -- soagrawa on 19-mar-2002
2994: -- moved the cursor data retrieval from after update to before update

Line 2991: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

2987: BEGIN
2988:
2989: l_user_id := FND_GLOBAL.USER_ID;
2990: l_resp_id := FND_GLOBAL.RESP_ID;
2991: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
2992:
2993: -- soagrawa on 19-mar-2002
2994: -- moved the cursor data retrieval from after update to before update
2995: OPEN c_sch_det;

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

3094:
3095: END IF;
3096:
3097:
3098: l_RESOURCE_id := AMS_Utility_PVT.get_resource_id(FND_GLOBAL.user_id);
3099: --insert_log_mesg('Anirban passing value of l_RESOURCE_id in WF, in amsvsbrb.pls as :'||l_RESOURCE_id);
3100: wf_event.AddParameterToList(p_name => 'ASN_RESOURCE_ID',
3101: p_value => l_RESOURCE_id,
3102: p_parameterlist => l_parameter_list);

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

3415: FND_MSG_PUB.Get(p_msg_index => l_cnt + 1,
3416: p_encoded => FND_API.G_FALSE,
3417: p_data => l_msg_data,
3418: p_msg_index_out => l_msg_index ) ;
3419: l_final_data := l_final_data ||l_msg_index||': '||l_msg_data||fnd_global.local_chr(10);
3420: l_cnt := l_cnt + 1 ;
3421:
3422: END LOOP ;
3423:

Line 3482: l_user_id := FND_GLOBAL.USER_ID;

3478: itemtype => itemtype,
3479: itemkey => itemkey ,
3480: aname => 'SCHEDULE_ID');
3481:
3482: l_user_id := FND_GLOBAL.USER_ID;
3483: l_resp_id := FND_GLOBAL.RESP_ID;
3484: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3485:
3486: AMS_Utility_PVT.Create_Log (

Line 3483: l_resp_id := FND_GLOBAL.RESP_ID;

3479: itemkey => itemkey ,
3480: aname => 'SCHEDULE_ID');
3481:
3482: l_user_id := FND_GLOBAL.USER_ID;
3483: l_resp_id := FND_GLOBAL.RESP_ID;
3484: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3485:
3486: AMS_Utility_PVT.Create_Log (
3487: x_return_status => l_return_status,

Line 3484: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

3480: aname => 'SCHEDULE_ID');
3481:
3482: l_user_id := FND_GLOBAL.USER_ID;
3483: l_resp_id := FND_GLOBAL.RESP_ID;
3484: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3485:
3486: AMS_Utility_PVT.Create_Log (
3487: x_return_status => l_return_status,
3488: p_arc_log_used_by => 'CSCH',

Line 3620: l_user_id := FND_GLOBAL.USER_ID;

3616: ELSIF (p_funcmode = 'TEST_CTX') THEN
3617: -- Code that compares current session context
3618: -- with the work item context required to execute
3619: -- the workflow safely
3620: l_user_id := FND_GLOBAL.USER_ID;
3621: l_resp_id := FND_GLOBAL.RESP_ID;
3622: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3623:
3624: l_schedule_id := WF_ENGINE.GetItemAttrText(

Line 3621: l_resp_id := FND_GLOBAL.RESP_ID;

3617: -- Code that compares current session context
3618: -- with the work item context required to execute
3619: -- the workflow safely
3620: l_user_id := FND_GLOBAL.USER_ID;
3621: l_resp_id := FND_GLOBAL.RESP_ID;
3622: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3623:
3624: l_schedule_id := WF_ENGINE.GetItemAttrText(
3625: itemtype => p_itemtype,

Line 3622: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

3618: -- with the work item context required to execute
3619: -- the workflow safely
3620: l_user_id := FND_GLOBAL.USER_ID;
3621: l_resp_id := FND_GLOBAL.RESP_ID;
3622: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
3623:
3624: l_schedule_id := WF_ENGINE.GetItemAttrText(
3625: itemtype => p_itemtype,
3626: itemkey => p_itemkey ,

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

3657: p_msg_type => 'DEBUG'
3658: );
3659:
3660: -- Set the database session context
3661: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3662: p_result := 'COMPLETE:FALSE';
3663: else
3664: p_result := 'COMPLETE:TRUE';
3665: end if;

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

3684:
3685: l_resp_appl_id := 530;
3686:
3687: -- Set the database session context which also sets the org
3688: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
3689: AMS_Utility_PVT.Create_Log (
3690: x_return_status => l_return_status,
3691: p_arc_log_used_by => 'CSCH',
3692: p_log_used_by_id => l_schedule_id,

Line 3758: last_updated_by = FND_GLOBAL.user_id

3754: UPDATE ams_campaign_schedules_b
3755: SET last_activation_date = SYSDATE,
3756: object_version_number = object_version_number + 1,
3757: last_update_date = SYSDATE,
3758: last_updated_by = FND_GLOBAL.user_id
3759: WHERE schedule_id = l_schedule_id ;
3760:
3761: IF l_schedule_status = 'ACTIVE' THEN
3762: result := 'COMPLETE:ACTIVE' ;

Line 3855: last_updated_by = FND_GLOBAL.user_id

3851: status_date = SYSDATE,
3852: last_activation_date = SYSDATE,
3853: object_version_number = object_version_number + 1,
3854: last_update_date = SYSDATE,
3855: last_updated_by = FND_GLOBAL.user_id
3856: WHERE schedule_id = l_schedule_id ;
3857: --dkailash update AMS_EVENT_OFFERS_ALL_B table for l_activity_type_code ='EVENTS' added for bug #11830352
3858: IF (l_related_event_id IS NOT NULL and l_activity_type_code ='EVENTS')
3859: THEN

Line 3868: LAST_UPDATED_BY=FND_GLOBAL.user_id

3864: USER_STATUS_ID=l_event_status_id,
3865: LAST_STATUS_DATE=SYSDATE,
3866: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
3867: LAST_UPDATE_DATE=SYSDATE,
3868: LAST_UPDATED_BY=FND_GLOBAL.user_id
3869: WHERE EVENT_OFFER_ID = l_related_event_id;
3870: END IF;
3871:
3872: -- call to api to raise business event, as per enh # 3805347

Line 4392: l_user_id := FND_GLOBAL.USER_ID;

4388: itemtype => itemtype,
4389: itemkey => itemkey ,
4390: aname => 'SCHEDULE_ID' );
4391:
4392: l_user_id := FND_GLOBAL.USER_ID;
4393: l_resp_id := FND_GLOBAL.RESP_ID;
4394: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4395:
4396: AMS_Utility_PVT.Create_Log (

Line 4393: l_resp_id := FND_GLOBAL.RESP_ID;

4389: itemkey => itemkey ,
4390: aname => 'SCHEDULE_ID' );
4391:
4392: l_user_id := FND_GLOBAL.USER_ID;
4393: l_resp_id := FND_GLOBAL.RESP_ID;
4394: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4395:
4396: AMS_Utility_PVT.Create_Log (
4397: x_return_status => l_return_status,

Line 4394: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;

4390: aname => 'SCHEDULE_ID' );
4391:
4392: l_user_id := FND_GLOBAL.USER_ID;
4393: l_resp_id := FND_GLOBAL.RESP_ID;
4394: l_resp_appl_id := FND_GLOBAL.RESP_APPL_ID;
4395:
4396: AMS_Utility_PVT.Create_Log (
4397: x_return_status => l_return_status,
4398: p_arc_log_used_by => 'CSCH',

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

4722: VALUES
4723: (
4724: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4725: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4726: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4727: , SYSDATE --CREATION_DATE --NOT NULL DATE
4728: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4729: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4730: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)

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

4724: AS_IMPORT_INTERFACE_S.NEXTVAL --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4725: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4726: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4727: , SYSDATE --CREATION_DATE --NOT NULL DATE
4728: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4729: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4730: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)
4731: , SYSDATE --LOAD_DATE --NOT NULL DATE
4732: , l_schedule_details.source_code --PROMOTION_CODE -- VARCHAR2(50)

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

4725: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4726: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4727: , SYSDATE --CREATION_DATE --NOT NULL DATE
4728: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4729: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4730: , 'LEAD_LOAD' --LOAD_TYPE -- VARCHAR2(20)
4731: , SYSDATE --LOAD_DATE --NOT NULL DATE
4732: , l_schedule_details.source_code --PROMOTION_CODE -- VARCHAR2(50)
4733: , null --STATUS_CODE -- VARCHAR2(30)

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

4799: (
4800: AS_IMP_LINES_INTERFACE_S.NEXTVAL --IMP_LINES_INTERFACE_ID --NOT NULL NUMBER
4801: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4802: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4803: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4804: , SYSDATE --CREATION_DATE --NOT NULL DATE
4805: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4806: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4807: ,l_assoc_product_row.category_id

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

4801: , l_lead_header_ids(j) --IMPORT_INTERFACE_ID --NOT NULL NUMBER
4802: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4803: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4804: , SYSDATE --CREATION_DATE --NOT NULL DATE
4805: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4806: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4807: ,l_assoc_product_row.category_id
4808: ,l_assoc_product_row.inventory_item_id
4809: ,l_assoc_product_row.organization_id

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

4802: , SYSDATE --LAST_UPDATE_DATE --NOT NULL DATE
4803: , FND_GLOBAL.user_id --LAST_UPDATED_BY --NOT NULL NUMBER
4804: , SYSDATE --CREATION_DATE --NOT NULL DATE
4805: , FND_GLOBAL.user_id --CREATED_BY --NOT NULL NUMBER
4806: , FND_GLOBAL.conc_login_id --LAST_UPDATE_LOGIN --NOT NULL NUMBER
4807: ,l_assoc_product_row.category_id
4808: ,l_assoc_product_row.inventory_item_id
4809: ,l_assoc_product_row.organization_id
4810: ,l_schedule_details.source_code_id