DBA Data[Home] [Help]

APPS.MSD_WF dependencies on FND_GLOBAL

Line 199: userID := fnd_global.user_id;

195: BEGIN
196: itemtype := iteminput;
197: itemkey := inputkey;
198: owner := inowner;
199: userID := fnd_global.user_id;
200: respID := fnd_global.resp_id;
201: respApplID := fnd_global.resp_appl_id;
202:
203:

Line 200: respID := fnd_global.resp_id;

196: itemtype := iteminput;
197: itemkey := inputkey;
198: owner := inowner;
199: userID := fnd_global.user_id;
200: respID := fnd_global.resp_id;
201: respApplID := fnd_global.resp_appl_id;
202:
203:
204: SELECT demand_plan_name, code_location, shared_db_prefix,

Line 201: respApplID := fnd_global.resp_appl_id;

197: itemkey := inputkey;
198: owner := inowner;
199: userID := fnd_global.user_id;
200: respID := fnd_global.resp_id;
201: respApplID := fnd_global.resp_appl_id;
202:
203:
204: SELECT demand_plan_name, code_location, shared_db_prefix,
205: shared_db_location, express_connect_string INTO PlName,

Line 879: owner := fnd_global.user_name;

875:
876: BEGIN
877: itemtype := 'ODPCYCLE';
878: workflowProcess := 'ODPAUTOMATE';
879: owner := fnd_global.user_name;
880: userID := fnd_global.user_id;
881: respID := fnd_global.resp_id;
882: respApplID := fnd_global.resp_appl_id;
883:

Line 880: userID := fnd_global.user_id;

876: BEGIN
877: itemtype := 'ODPCYCLE';
878: workflowProcess := 'ODPAUTOMATE';
879: owner := fnd_global.user_name;
880: userID := fnd_global.user_id;
881: respID := fnd_global.resp_id;
882: respApplID := fnd_global.resp_appl_id;
883:
884:

Line 881: respID := fnd_global.resp_id;

877: itemtype := 'ODPCYCLE';
878: workflowProcess := 'ODPAUTOMATE';
879: owner := fnd_global.user_name;
880: userID := fnd_global.user_id;
881: respID := fnd_global.resp_id;
882: respApplID := fnd_global.resp_appl_id;
883:
884:
885: errbuf := ' ';

Line 882: respApplID := fnd_global.resp_appl_id;

878: workflowProcess := 'ODPAUTOMATE';
879: owner := fnd_global.user_name;
880: userID := fnd_global.user_id;
881: respID := fnd_global.resp_id;
882: respApplID := fnd_global.resp_appl_id;
883:
884:
885: errbuf := ' ';
886:

Line 1068: fnd_global.apps_initialize(user_id, resp_id, respAppl_id);

1064: show_log_title := wf_engine.GetItemAttrText(Itemtype => gItemType,
1065: Itemkey => gItemKey,
1066: aname => 'SHOW_LOG_TITLE');
1067:
1068: fnd_global.apps_initialize(user_id, resp_id, respAppl_id);
1069:
1070:
1071: script := 'aw attach ap' || 'ps.' || code_aw || ' ro; ';
1072:

Line 1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));

1091: bFailed := true;
1092: end;
1093:
1094: if not(bFailed) then
1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));

Line 1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));

1094: if not(bFailed) then
1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:

Line 1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));

1095: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:
1103: -- detach any aws if they are still attached

Line 1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));

1096: end if;
1097:
1098: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1099: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1100: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1101: script := '';
1102:
1103: -- detach any aws if they are still attached
1104: msd_common_utilities.detach_all_aws;

Line 1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));

1299:
1300: --insert into msd_temp values(script);
1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';

Line 1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));

1300: --insert into msd_temp values(script);
1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:

Line 1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));

1301: msd_common_utilities.dbms_aw_interp_silent(script);
1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:
1309:

Line 1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));

1302:
1303: p_RetCode := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retcode'), 2000));
1304: p_RetText := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.text'), 2000));
1305: p_RetVal := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.retval'), 2000));
1306: p_RetErr := trim(both fnd_global.local_chr(10) from dbms_lob.substr(msd_common_utilities.dbms_aw_interp('shw activity.error'), 2000));
1307: script := '';
1308:
1309:
1310: end execute_dml2;