APPS.POS_SURVEY_INTEGRATION dependencies on POS_SURVEY_TRANSACTIONS

Line 32: FROM pos_survey_transactions

28: l_mapping_id NUMBER;
29:
30: CURSOR l_transaction_cur IS
31: SELECT transaction_id, supplier_update_flag
32: FROM pos_survey_transactions
33: WHERE supplier_mapping_id = l_mapping_id
34: AND survey_transaction_id = p_survey_transaction_id;
35:
36: l_transaction_id NUMBER;

Line 111: INSERT INTO pos_survey_transactions

107: END IF;
108:
109: x_status := '60';
110:
111: INSERT INTO pos_survey_transactions
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

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 134: UPDATE pos_survey_transactions

130: END IF;
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,