APPS.IEU_WP_ACTION_PVT dependencies on IEU_WP_PARAM_PROPS_SEED_PKG

Line 738: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;

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;
742: v_param_set_id ieu_wp_param_props_b.action_param_set_id%type;

Line 845: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (

841: Loop
842: FETCH c_cur INTO c_rec;
843: EXIT WHEN c_cur%NOTFOUND;
844: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
845: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
846: PARAM_PROPERTY_ID NUMBER(15),
847: ACTION_PARAM_SET_ID NUMBER,
848: PARAM_ID NUMBER,
849: PROPERTY_ID NUMBER,

Line 875: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

871: param_props_rec.last_update_date := SYSDATE;
872: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
873: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
874: param_props_rec.owner := 1;
875: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
876: end LOOP;
877: CLOSE c_cur;
878:
879:

Line 1070: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;

1066: l_my_count NUMBER:=0;
1067: l_max_property NUMBER :=0;
1068: l_max_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1069: l_param_property_key ieu_wp_param_props_b.param_property_id%type;
1070: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1071: param_sets_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1072: v_applId ieu_wp_param_defs_b.application_id%type;
1073: TYPE c_cursor5 IS REF CURSOR;
1074: c_ref c_cursor5;

Line 1071: param_sets_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;

1067: l_max_property NUMBER :=0;
1068: l_max_action_param_set_id IEU_WP_ACT_PARAM_SETS_B.action_param_set_id%type;
1069: l_param_property_key ieu_wp_param_props_b.param_property_id%type;
1070: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1071: param_sets_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;
1072: v_applId ieu_wp_param_defs_b.application_id%type;
1073: TYPE c_cursor5 IS REF CURSOR;
1074: c_ref c_cursor5;
1075:

Line 1186: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (

1182: FETCH c_ref2 INTO l_property_id, l_property_value,l_value_override_flag,l_not_valid_flag;
1183: EXIT WHEN c_ref2%NOTFOUND;
1184:
1185: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1186: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1187: PARAM_PROPERTY_ID NUMBER(15),
1188: ACTION_PARAM_SET_ID NUMBER,
1189: PARAM_ID NUMBER,
1190: PROPERTY_ID NUMBER,

Line 1216: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

1212: param_props_rec.last_update_date := SYSDATE;
1213: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1214: param_props_rec.NOT_VALID_FLAG :=l_not_valid_flag;
1215: param_props_rec.owner := 1;
1216: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
1217: end loop;-- for v_cursor2
1218: --DBMS_SQL.CLOSE_CURSOR(v_cursor2);
1219: CLOSE c_ref2;
1220: END IF ; -- for max action param set is not null

Line 1495: param_props_rec IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type;

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;
1499: v_param_set_id ieu_wp_act_param_sets_tl.action_param_set_id%type;

Line 1603: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (

1599: Loop
1600: FETCH c_cur INTO c_rec;
1601: EXIT WHEN c_cur%NOTFOUND;
1602: select IEU_WP_PARAM_PROPS_B_S1.NEXTVAL into l_param_property_id from sys.dual;
1603: /*TYPE IEU_WP_PARAM_PROPS_SEED_PKG.wp_param_props_rec_type IS RECORD (
1604: PARAM_PROPERTY_ID NUMBER(15),
1605: ACTION_PARAM_SET_ID NUMBER,
1606: PARAM_ID NUMBER,
1607: PROPERTY_ID NUMBER,

Line 1633: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);

1629: param_props_rec.last_update_date := SYSDATE;
1630: param_props_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1631: param_props_rec.NOT_VALID_FLAG := c_rec.not_valid_flag;
1632: param_props_rec.owner := 1;
1633: IEU_WP_PARAM_PROPS_SEED_PKG.Insert_Row(p_wp_param_props_rec => param_props_rec);
1634: end loop;
1635: CLOSE c_cur;
1636:
1637: