DBA Data[Home] [Help]

APPS.AMW_RL_HIERARCHY_PKG dependencies on AMW_CHILD_ORDER_S

Line 1233: AMW_CHILD_ORDER_S.nextval,

1229: )
1230: VALUES (-1,
1231: p_parent_process_id,
1232: p_child_process_id,
1233: AMW_CHILD_ORDER_S.nextval,
1234: l_sysdate,
1235: g_user_id,
1236: g_login_id,
1237: l_sysdate,

Line 2352: select display_name, description, AMW_CHILD_ORDER_S.nextval

2348: iStart := iEnd + 1;
2349:
2350:
2351: /* do your processing */
2352: select display_name, description, AMW_CHILD_ORDER_S.nextval
2353: into cur_display_name, cur_description, cur_instance_id
2354: from wf_activities_vl
2355: where name = cur_name
2356: and item_type = cur_item_type

Line 2571: SELECT AMW_CHILD_ORDER_S.nextval INTO L_CHILD_ORDER FROM DUAL;

2567: --update the latest hierarchy table
2568: ---IF p_child_order_number IS -100, THIS MEANS THAT NO SEQ NUM WAS DEFINED BY USER
2569: --SO GENERATED VIA SEQUENCE
2570: IF(P_CHILD_ORDER_NUMBER = -100) THEN
2571: SELECT AMW_CHILD_ORDER_S.nextval INTO L_CHILD_ORDER FROM DUAL;
2572: ELSE
2573: L_CHILD_ORDER := P_CHILD_ORDER_NUMBER;
2574: END IF;
2575:

Line 4252: AMW_CHILD_ORDER_S.nextval,

4248: )
4249: VALUES (-1,
4250: p_parent_process_id,
4251: l_child_id,
4252: AMW_CHILD_ORDER_S.nextval,
4253: p_sysdate,
4254: g_user_id,
4255: g_login_id,
4256: p_sysdate,