APPS.MSC_BAL_UTILS dependencies on FND_GLOBAL

Line 140: 'FND_GLOBAL.USER_ID, '||

136: 'omodv.option_number, '||
137: 'omodv.ship_from_org_id, '||
138: 'omodv.demand_class_code, '||
139: 'sysdate, '||
140: 'FND_GLOBAL.USER_ID, '||
141: 'sysdate, '||
142: 'FND_GLOBAL.USER_ID, '||
143: 'FND_GLOBAL.USER_ID ';
144:

Line 142: 'FND_GLOBAL.USER_ID, '||

138: 'omodv.demand_class_code, '||
139: 'sysdate, '||
140: 'FND_GLOBAL.USER_ID, '||
141: 'sysdate, '||
142: 'FND_GLOBAL.USER_ID, '||
143: 'FND_GLOBAL.USER_ID ';
144:
145: l_new_columns varchar2(100) := ' ,omodv.freight_carrier_code, omodv.flow_status_code ';
146: l_old_columns varchar2(100) := ' ,null, null ';

Line 143: 'FND_GLOBAL.USER_ID ';

139: 'sysdate, '||
140: 'FND_GLOBAL.USER_ID, '||
141: 'sysdate, '||
142: 'FND_GLOBAL.USER_ID, '||
143: 'FND_GLOBAL.USER_ID ';
144:
145: l_new_columns varchar2(100) := ' ,omodv.freight_carrier_code, omodv.flow_status_code ';
146: l_old_columns varchar2(100) := ' ,null, null ';
147:

Line 1147: fnd_global.apps_initialize(p_user_id,

1143: ELSE -- atp is successful , proceed to om call
1144: -- need to reset client_info before
1145: --calling OM api to avoid bug 3145033
1146: --dbms_application_info.set_client_info(fnd_profile.value('ORG_ID'));
1147: fnd_global.apps_initialize(p_user_id,
1148: p_resp_id,
1149: p_appl_id);
1150: mo_global.init('ONT'); -- MOAC changes
1151:

Line 1826: , last_updated_by = FND_GLOBAL.USER_ID

1822:
1823: update mrp_atp_schedule_temp mast
1824: set mast.sequence_number = p_seq_alter.seq_num(j)
1825: , last_update_date = sysdate
1826: , last_updated_by = FND_GLOBAL.USER_ID
1827: , last_update_login = FND_GLOBAL.USER_ID
1828: WHERE mast.session_id = p_session_id
1829: AND mast.order_line_id = p_seq_alter.order_line_id(j) ;
1830:

Line 1827: , last_update_login = FND_GLOBAL.USER_ID

1823: update mrp_atp_schedule_temp mast
1824: set mast.sequence_number = p_seq_alter.seq_num(j)
1825: , last_update_date = sysdate
1826: , last_updated_by = FND_GLOBAL.USER_ID
1827: , last_update_login = FND_GLOBAL.USER_ID
1828: WHERE mast.session_id = p_session_id
1829: AND mast.order_line_id = p_seq_alter.order_line_id(j) ;
1830:
1831:

Line 1838: , last_updated_by = FND_GLOBAL.USER_ID

1834: -1,mast.sequence_number + 1,
1835: 1, mast.sequence_number -1)
1836: -- dsting
1837: , last_update_date = sysdate
1838: , last_updated_by = FND_GLOBAL.USER_ID
1839: , last_update_login = FND_GLOBAL.USER_ID
1840: WHERE
1841: mast.sequence_number BETWEEN
1842: Decode(Sign(p_seq_alter.seq_diff(j)),

Line 1839: , last_update_login = FND_GLOBAL.USER_ID

1835: 1, mast.sequence_number -1)
1836: -- dsting
1837: , last_update_date = sysdate
1838: , last_updated_by = FND_GLOBAL.USER_ID
1839: , last_update_login = FND_GLOBAL.USER_ID
1840: WHERE
1841: mast.sequence_number BETWEEN
1842: Decode(Sign(p_seq_alter.seq_diff(j)),
1843: -1, p_seq_alter.seq_num(j),

Line 1856: , last_updated_by = FND_GLOBAL.USER_ID

1852:
1853: update mrp_atp_schedule_temp mast
1854: set mast.sequence_number = record_firm_filter.seq_num(b)
1855: , last_update_date = sysdate
1856: , last_updated_by = FND_GLOBAL.USER_ID
1857: , last_update_login = FND_GLOBAL.USER_ID
1858: WHERE
1859: mast.session_id = p_session_id
1860: AND mast.order_line_id = record_firm_filter.order_line_id(b) ;

Line 1857: , last_update_login = FND_GLOBAL.USER_ID

1853: update mrp_atp_schedule_temp mast
1854: set mast.sequence_number = record_firm_filter.seq_num(b)
1855: , last_update_date = sysdate
1856: , last_updated_by = FND_GLOBAL.USER_ID
1857: , last_update_login = FND_GLOBAL.USER_ID
1858: WHERE
1859: mast.session_id = p_session_id
1860: AND mast.order_line_id = record_firm_filter.order_line_id(b) ;
1861: