APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on FND_GLOBAL

Line 167: Fnd_Global.User_Id,

163: okc_xprt_template_rules_s.NEXTVAL,
164: p_target_template_id,
165: rule_id_tbl(i),
166: 1,
167: Fnd_Global.User_Id,
168: sysdate,
169: Fnd_Global.User_Id,
170: sysdate,
171: Fnd_Global.Login_Id,

Line 169: Fnd_Global.User_Id,

165: rule_id_tbl(i),
166: 1,
167: Fnd_Global.User_Id,
168: sysdate,
169: Fnd_Global.User_Id,
170: sysdate,
171: Fnd_Global.Login_Id,
172: 'N'
173: );

Line 171: Fnd_Global.Login_Id,

167: Fnd_Global.User_Id,
168: sysdate,
169: Fnd_Global.User_Id,
170: sysdate,
171: Fnd_Global.Login_Id,
172: 'N'
173: );
174:
175: END IF; -- rule_id_tbl.COUNT > 0

Line 213: Fnd_Global.User_Id,

209: p_target_template_id,
210: question_id_tbl(i),
211: mandatory_flag_tbl(i),
212: 1,
213: Fnd_Global.User_Id,
214: sysdate,
215: Fnd_Global.User_Id,
216: sysdate,
217: Fnd_Global.Login_Id,

Line 215: Fnd_Global.User_Id,

211: mandatory_flag_tbl(i),
212: 1,
213: Fnd_Global.User_Id,
214: sysdate,
215: Fnd_Global.User_Id,
216: sysdate,
217: Fnd_Global.Login_Id,
218: sequence_num_tbl(i),
219: question_rule_status_tbl(i),

Line 217: Fnd_Global.Login_Id,

213: Fnd_Global.User_Id,
214: sysdate,
215: Fnd_Global.User_Id,
216: sysdate,
217: Fnd_Global.Login_Id,
218: sequence_num_tbl(i),
219: question_rule_status_tbl(i),
220: runtime_available_flag_tbl(i)
221: );

Line 462: last_updated_by= FND_GLOBAL.USER_ID,

458: -- Update okc_xprt_template_rules for Revision template
459: UPDATE okc_xprt_template_rules
460: SET template_id = p_parent_template_id,
461: last_update_date = SYSDATE,
462: last_updated_by= FND_GLOBAL.USER_ID,
463: last_update_login= FND_GLOBAL.LOGIN_ID
464: WHERE template_id = p_template_id;
465:
466: -- Update okc_xprt_question_orders for Revision template

Line 463: last_update_login= FND_GLOBAL.LOGIN_ID

459: UPDATE okc_xprt_template_rules
460: SET template_id = p_parent_template_id,
461: last_update_date = SYSDATE,
462: last_updated_by= FND_GLOBAL.USER_ID,
463: last_update_login= FND_GLOBAL.LOGIN_ID
464: WHERE template_id = p_template_id;
465:
466: -- Update okc_xprt_question_orders for Revision template
467: UPDATE okc_xprt_question_orders

Line 470: last_updated_by= FND_GLOBAL.USER_ID,

466: -- Update okc_xprt_question_orders for Revision template
467: UPDATE okc_xprt_question_orders
468: SET template_id = p_parent_template_id,
469: last_update_date = SYSDATE,
470: last_updated_by= FND_GLOBAL.USER_ID,
471: last_update_login= FND_GLOBAL.LOGIN_ID
472: WHERE template_id = p_template_id;
473:
474: END IF;

Line 471: last_update_login= FND_GLOBAL.LOGIN_ID

467: UPDATE okc_xprt_question_orders
468: SET template_id = p_parent_template_id,
469: last_update_date = SYSDATE,
470: last_updated_by= FND_GLOBAL.USER_ID,
471: last_update_login= FND_GLOBAL.LOGIN_ID
472: WHERE template_id = p_template_id;
473:
474: END IF;
475: