1374: SET epc = p_gen_epc,
1375: cross_ref_type = p_cross_ref_type,
1376: group_id = p_group_id,
1377: last_update_date = Sysdate,
1378: last_updated_by = fnd_global.user_id,
1379: epc_rule_type_id = p_epc_rule_type_id,
1380: sscc = P_sscc,
1381: gtin = P_gtin,
1382: gtin_serial = NULL,
1424: p_filter_value,
1425: 'S',
1426: 'LABEL_PRINTED',
1427: Sysdate,
1428: fnd_global.user_id,
1429: Sysdate,
1430: fnd_global.user_id,
1431: fnd_global.user_id,
1432: NULL, --epc_id NOT used post R12
1426: 'LABEL_PRINTED',
1427: Sysdate,
1428: fnd_global.user_id,
1429: Sysdate,
1430: fnd_global.user_id,
1431: fnd_global.user_id,
1432: NULL, --epc_id NOT used post R12
1433: NULL); --epc_rule_id NOT used post R12
1434:
1427: Sysdate,
1428: fnd_global.user_id,
1429: Sysdate,
1430: fnd_global.user_id,
1431: fnd_global.user_id,
1432: NULL, --epc_id NOT used post R12
1433: NULL); --epc_rule_id NOT used post R12
1434:
1435: ELSIF p_action = 'DELETE' THEN
1448: SET epc = p_gen_epc,
1449: cross_ref_type = p_cross_ref_type,
1450: group_id = p_group_id,
1451: last_update_date = Sysdate,
1452: last_updated_by = fnd_global.user_id,
1453: epc_rule_type_id = p_epc_rule_type_id,
1454: sscc = NULL,-- No other value possible
1455: gtin = P_gtin,
1456: gtin_serial = NULL,
1498: p_filter_value,
1499: 'S',
1500: 'LABEL_PRINTED',
1501: Sysdate,
1502: fnd_global.user_id,
1503: Sysdate,
1504: fnd_global.user_id,
1505: fnd_global.user_id,
1506: NULL, --epc_id NOT used post R12
1500: 'LABEL_PRINTED',
1501: Sysdate,
1502: fnd_global.user_id,
1503: Sysdate,
1504: fnd_global.user_id,
1505: fnd_global.user_id,
1506: NULL, --epc_id NOT used post R12
1507: NULL); --epc_rule_id NOT used post R12
1508:
1501: Sysdate,
1502: fnd_global.user_id,
1503: Sysdate,
1504: fnd_global.user_id,
1505: fnd_global.user_id,
1506: NULL, --epc_id NOT used post R12
1507: NULL); --epc_rule_id NOT used post R12
1508:
1509: ELSIF p_action = 'DELETE' THEN
1524: SET epc = p_gen_epc,
1525: cross_ref_type = p_cross_ref_type,
1526: group_id = p_group_id,
1527: last_update_date = Sysdate,
1528: last_updated_by = fnd_global.user_id,
1529: epc_rule_type_id = p_epc_rule_type_id,
1530: sscc = NULL, --NO other value possible in this case
1531: serial_number = NULL,
1532: inventory_item_id = NULL,
1574: p_filter_value,
1575: 'S',
1576: 'LABEL_PRINTED',
1577: Sysdate,
1578: fnd_global.user_id,
1579: Sysdate,
1580: fnd_global.user_id,
1581: fnd_global.user_id,
1582: NULL, --epc_id NOT used post R12
1576: 'LABEL_PRINTED',
1577: Sysdate,
1578: fnd_global.user_id,
1579: Sysdate,
1580: fnd_global.user_id,
1581: fnd_global.user_id,
1582: NULL, --epc_id NOT used post R12
1583: NULL); --epc_rule_id NOT used post R12
1584:
1577: Sysdate,
1578: fnd_global.user_id,
1579: Sysdate,
1580: fnd_global.user_id,
1581: fnd_global.user_id,
1582: NULL, --epc_id NOT used post R12
1583: NULL); --epc_rule_id NOT used post R12
1584:
1585: ELSIF p_action = 'DELETE' THEN
2948: null,--filter_object_type
2949: 'S',
2950: 'IMPORTED',
2951: Sysdate,
2952: fnd_global.user_id,
2953: Sysdate,
2954: fnd_global.user_id,
2955: fnd_global.user_id,
2956: NULL, --epc_id NOT used post R12
2950: 'IMPORTED',
2951: Sysdate,
2952: fnd_global.user_id,
2953: Sysdate,
2954: fnd_global.user_id,
2955: fnd_global.user_id,
2956: NULL, --epc_id NOT used post R12
2957: NULL); --epc_rule_id NOT used post R12
2958: --DO NOT COMMIT
2951: Sysdate,
2952: fnd_global.user_id,
2953: Sysdate,
2954: fnd_global.user_id,
2955: fnd_global.user_id,
2956: NULL, --epc_id NOT used post R12
2957: NULL); --epc_rule_id NOT used post R12
2958: --DO NOT COMMIT
2959: