APPS.AMW_LOAD_CTRL_DATA dependencies on AMW_CONTROL_PURPOSES

Line 1151: WHERE lookup_type='AMW_CONTROL_PURPOSES'

1147: IS
1148: CURSOR c_control_PURPOSE IS
1149: SELECT lookup_code
1150: FROM AMW_LOOKUPS
1151: WHERE lookup_type='AMW_CONTROL_PURPOSES'
1152: AND enabled_flag='Y'
1153: AND tag=p_lookup_tag;
1154:
1155: l_ctrl_PURPOSE_code VARCHAR2(30);

Line 1181: from amw_control_PURPOSES

1177:
1178: if (l_ctrl_PURPOSE_flag = 'N') then
1179: select count(*)
1180: into l_PURPOSE_exists
1181: from amw_control_PURPOSES
1182: where control_rev_id = vx_control_rev_id
1183: AND PURPOSE_code = l_ctrl_PURPOSE_code;
1184:
1185: if(l_PURPOSE_exists > 0) then

Line 1186: delete from amw_control_PURPOSEs

1182: where control_rev_id = vx_control_rev_id
1183: AND PURPOSE_code = l_ctrl_PURPOSE_code;
1184:
1185: if(l_PURPOSE_exists > 0) then
1186: delete from amw_control_PURPOSEs
1187: where control_rev_id = vx_control_rev_id
1188: AND PURPOSE_code = l_ctrl_PURPOSE_code;
1189: end if;
1190: end if;

Line 1195: from amw_control_PURPOSEs

1191:
1192: if(l_ctrl_PURPOSE_flag = 'Y') then
1193: select count(*)
1194: into l_PURPOSE_exists
1195: from amw_control_PURPOSEs
1196: where control_rev_id = vx_control_rev_id
1197: AND PURPOSE_code = l_ctrl_PURPOSE_code;
1198:
1199: if(l_PURPOSE_exists = 0)then

Line 1201: INSERT INTO amw_control_PURPOSES(

1197: AND PURPOSE_code = l_ctrl_PURPOSE_code;
1198:
1199: if(l_PURPOSE_exists = 0)then
1200: ---IF SQL%NOTFOUND THEN
1201: INSERT INTO amw_control_PURPOSES(
1202: control_PURPOSE_id
1203: ,last_update_date
1204: ,last_updated_by
1205: ,creation_date

Line 1213: amw_control_PURPOSEs_s.NEXTVAL

1209: ,effective_date_from
1210: ----,effective_date_to
1211: ,OBJECT_VERSION_NUMBER
1212: ) VALUES (
1213: amw_control_PURPOSEs_s.NEXTVAL
1214: ,SYSDATE
1215: ,v_user_id
1216: ,SYSDATE
1217: ,v_user_id

Line 1235: v_table_name := 'AMW_CONTROL_PURPOSES';

1231: || p_lookup_tag
1232: || 'using interface id of: '
1233: || v_interface_id
1234: || ' flag must be Y/N';
1235: v_table_name := 'AMW_CONTROL_PURPOSES';
1236: update_interface_with_error (v_err_msg
1237: ,v_table_name
1238: ,v_interface_id);
1239:

Line 1247: v_table_name := 'AMW_CONTROL_PURPOSES';

1243: || p_lookup_tag
1244: || 'using interface id of: '
1245: || v_interface_id
1246: || ' code does not exist';
1247: v_table_name := 'AMW_CONTROL_PURPOSES';
1248: update_interface_with_error (v_err_msg
1249: ,v_table_name
1250: ,v_interface_id);
1251:

Line 1260: v_table_name := 'AMW_CONTROL_PURPOSES';

1256: || 'using interface id of: '
1257: || v_interface_id
1258: || ' '
1259: || SUBSTR (SQLERRM, 1, 100);
1260: v_table_name := 'AMW_CONTROL_PURPOSES';
1261: update_interface_with_error (v_err_msg
1262: ,v_table_name
1263: ,v_interface_id);
1264: END control_PURPOSEs;