APPS.WMS_LMS_UTILS dependencies on WMS_ELS_INDIVIDUAL_TASKS_S

Line 615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL

611: END IF;
612:
613: FOR els_individual_tasks_rec IN els_individual_tasks_cur(p_org_id) LOOP
614:
615: SELECT WMS_ELS_INDIVIDUAL_TASKS_S.NEXTVAL
616: INTO l_new_els_data_id
617: FROM dual;
618:
619: INSERT INTO wms_els_individual_tasks_b (

Line 1704: wms_els_individual_tasks_s.nextval

1700: , created_by
1701: , creation_date
1702: )
1703: SELECT
1704: wms_els_individual_tasks_s.nextval
1705: , organization_id
1706: , decode(group_id,1,nvl(l_seq_num_man_and_usr_directed,0)+10,
1707: 2,nvl(l_seq_num_man_and_sys_directed,0) + 10,
1708: 3,nvl(l_seq_num_ind_and_sys_directed,0) + 10

Line 2107: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2103: || ' , created_by '
2104: || ' , creation_date '
2105: || ' ) '
2106: || ' SELECT '
2107: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2108: || ' , organization_id ' --organization_id
2109: || ' , nvl ( ' || l_seq_num_man_and_usr_directed || ',0)+10*ROWNUM ' --sequence_number
2110: || ' , ' || p_analysis_type --analysis_id
2111: || ' , activity_id ' --activity_id

Line 2223: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2219: || ' , created_by '
2220: || ' , creation_date '
2221: || ' ) '
2222: || ' SELECT '
2223: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2224: || ' , organization_id ' --organization_id
2225: || ' , nvl ( ' || l_seq_num_man_and_sys_directed || ',0)+10*ROWNUM ' --sequence_number
2226: || ' , ' || p_analysis_type --analysis_id
2227: || ' , activity_id ' --activity_id

Line 2341: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id

2337: || ' , created_by '
2338: || ' , creation_date '
2339: || ' ) '
2340: || ' SELECT '
2341: || ' wms_els_individual_tasks_s.NEXTVAL ' -- els_data_id
2342: || ' , organization_id ' --organization_id
2343: || ' , nvl ( ' || l_seq_num_ind_and_sys_directed || ',0)+10*ROWNUM ' --sequence_number
2344: || ' , ' || p_analysis_type --analysis_id
2345: || ' , activity_id ' --activity_id