DBA Data[Home] [Help]

APPS.POS_SURVEY_INTEGRATION dependencies on FND_GLOBAL

Line 116: (pos_survey_transactions_s.NEXTVAL, l_mapping_id, p_survey_transaction_id, fnd_global.user_id,

112: (transaction_id, supplier_mapping_id, survey_transaction_id, created_by,
113: creation_date, last_updated_by, last_update_date, last_update_login,
114: respondent_table_name, respondent_id, supplier_update_flag)
115: VALUES
116: (pos_survey_transactions_s.NEXTVAL, l_mapping_id, p_survey_transaction_id, fnd_global.user_id,
117: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
118: p_respondent_table_name, p_respondent_id, l_supplier_update_flag);
119:
120: ELSE

Line 117: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

113: creation_date, last_updated_by, last_update_date, last_update_login,
114: respondent_table_name, respondent_id, supplier_update_flag)
115: VALUES
116: (pos_survey_transactions_s.NEXTVAL, l_mapping_id, p_survey_transaction_id, fnd_global.user_id,
117: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
118: p_respondent_table_name, p_respondent_id, l_supplier_update_flag);
119:
120: ELSE
121:

Line 135: SET last_updated_by = fnd_global.user_id,

131:
132: x_status := '70';
133:
134: UPDATE pos_survey_transactions
135: SET last_updated_by = fnd_global.user_id,
136: last_update_date = sysdate,
137: last_update_login = fnd_global.login_id,
138: respondent_table_name = p_respondent_table_name,
139: respondent_id = p_respondent_id,

Line 137: last_update_login = fnd_global.login_id,

133:
134: UPDATE pos_survey_transactions
135: SET last_updated_by = fnd_global.user_id,
136: last_update_date = sysdate,
137: last_update_login = fnd_global.login_id,
138: respondent_table_name = p_respondent_table_name,
139: respondent_id = p_respondent_id,
140: supplier_update_flag = l_supplier_update_flag
141: WHERE transaction_id = l_transaction_id;