DBA Data[Home] [Help]

APPS.IEU_WP_ACTION_PVT dependencies on IEU_WP_ACT_PARAM_SETS_SEED_PKG

Line 737: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;

733: v_numrows1 NUMBER;
734: l_new_param_set_id NUMBER(15);
735: l_wp_action_map_id NUMBER(15);
736: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
737: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;
738: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
739: v_SelectStmt Varchar2(500);
740: v_CursorID INTEGER;
741: v_Dummy INTEGER;

Line 809: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (

805:
806:
807: if l_wp_maction_def_id is not null then
808: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
809: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
810: ACTION_PARAM_SET_ID NUMBER(15),
811: WP_ACTION_DEF_ID NUMBER(15),
812: ACTION_PARAM_SET_LABEL VARCHAR2(128),
813: ACTION_PARAM_SET_DESC VARCHAR2(500),

Line 831: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

827: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
828: param_sets_rec.last_update_date := SYSDATE;
829: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
830: param_sets_rec.owner := 1;
831: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);
832: end if ;
833:
834:
835: v_wp_action_key := r_wp_action_key;

Line 1494: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;

1490: v_numrows1 NUMBER;
1491: l_new_param_set_id NUMBER(15);
1492: l_wp_action_map_id NUMBER(15);
1493: l_temp_map_sequence ieu_wp_action_maps.action_map_sequence%type;
1494: param_sets_rec IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type;
1495: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1496: v_SelectStmt Varchar2(500);
1497: v_CursorID INTEGER;
1498: v_Dummy INTEGER;

Line 1568: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (

1564:
1565:
1566: if l_wp_maction_def_id is not null then
1567: select IEU_wp_act_param_sets_b_S1.NEXTVAL into l_new_param_set_id from sys.dual;
1568: /* TYPE IEU_WP_ACT_PARAM_SETS_SEED_PKG.WP_ACT_PARAM_SETS_rec_type IS RECORD (
1569: ACTION_PARAM_SET_ID NUMBER(15),
1570: WP_ACTION_DEF_ID NUMBER(15),
1571: ACTION_PARAM_SET_LABEL VARCHAR2(128),
1572: ACTION_PARAM_SET_DESC VARCHAR2(500),

Line 1590: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);

1586: param_sets_rec.last_updated_by := FND_GLOBAL.USER_ID;
1587: param_sets_rec.last_update_date := SYSDATE;
1588: param_sets_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1589: param_sets_rec.owner := 1;
1590: IEU_WP_ACT_PARAM_SETS_SEED_PKG.Insert_Row(p_WP_ACT_PARAM_SETS_rec=>param_Sets_rec);
1591: end if ;
1592:
1593: v_wp_action_key := r_wp_action_key;
1594: v_param_set_id := r_param_set_id;