APPS.ASN_METHODOLOGY_PVT dependencies on AS_METH_STAGE_INSTANCES

Line 39: SELECT AS_METH_STAGE_INSTANCES_S.nextval

35: FROM ASO_SUP_TMPL_SECT_MAP
36: WHERE template_id = p_template_id;
37:
38: CURSOR c_next_meth_stage_instance_id IS
39: SELECT AS_METH_STAGE_INSTANCES_S.nextval
40: FROM DUAL;
41:
42: CURSOR c_relationship_exists(p_object_type_code VARCHAR2,
43: p_object_id NUMBER,

Line 184: insert into AS_METH_STAGE_INSTANCES

180: FETCH c_next_meth_stage_instance_id INTO l_meth_stage_instance_id;
181: CLOSE c_next_meth_stage_instance_id;
182:
183: -- Create sales stage instance
184: insert into AS_METH_STAGE_INSTANCES
185: (METH_STAGE_INSTANCE_ID,
186: LAST_UPDATE_DATE,
187: LAST_UPDATED_BY,
188: CREATION_DATE,

Line 279: p_owner_table_name => 'AS_METH_STAGE_INSTANCES',

275: p_comp_sect_map_id => l_comp_sect_map_id,
276: p_response_value => l_response_value,
277: p_response_id => l_response_id,
278: p_mult_ans_flag => l_mult_ans_flag,
279: p_owner_table_name => 'AS_METH_STAGE_INSTANCES',
280: p_owner_table_id => l_meth_stage_instance_id,
281: x_template_instance_id => l_template_instance_id,
282: x_return_status => x_return_status,
283: x_msg_count => x_msg_count,